The Complete SQL Series with Real time examples
0.0 (0 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
517 students enrolled

The Complete SQL Series with Real time examples

From zero to hero, become the SQL expert.
0.0 (0 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
517 students enrolled
Created by Shakzee Arain
Last updated 10/2019
English
Current price: $31.99 Original price: $49.99 Discount: 36% off
23 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Learn complex queries
  • How to perform read and write operations
  • Introduction to No-SQL databases
  • How to fetch records using joins
Course content
Expand 31 lectures 02:24:16
+ Introduction
31 lectures 02:24:16
Select distinct statement in SQL
02:02
Where Clause in SQL
03:42
SQL And, OR, not operators
04:24
Order by keyword in SQL
04:10
Insert statement in SQL
04:08
NULL values in SQL
05:17
Update statement in SQL
06:43
Delete statement in SQL
05:37
IN operator in SQL
05:58
SQL Alias
03:56
Between operator in SQL
04:05
Min,Max,Sum,Count,Avg in SQL
04:10
Like in SQL
06:35
Introduction to join and creating the second tables
07:38
Inner Join in SQL
06:06
Left join in SQL
04:19
Group by in SQL
04:50
Having clause in SQL
02:49
Introduction to subquery in SQL
03:11
Creating the Databases
01:54
Creating the tables in SQL
05:44
Alter Columns in SQL
04:27
SQL constraints in SQL
04:41
Conclusion
02:12
Requirements
  • You just need a computer, no prior technical experience is required.
Description

Working on any language is a plus point, but how to store data in the database, how to fetch the data from the database, these are the question every new programmer ask. Most people think that SQL is a complicated thing to learn, but believe me, it's straightforward, it's just like the English language. In this series, we are going to cover every fundamental concept related to SQL.

We start from zero what is the database, how to store data in the database, we will also discuss about the NO-SQL database like MongoDB.

You will learn how to fetch the record, and we will also talk about the relational database and also how to bring the data from two tables using joins.

We will discuss different types of joins and how to use the theme. You will learn a lot of things in this series. At the end of this series, I will give you an overview of MongoDB so you can easily take the next step.

Who this course is for:
  • Beginners who don't about SQL
  • New programmer who want to know about storing data permanent