SQL Basics Tutorial for Beginners (Practice SQL Queries)

SQL Basics Tutorial for Beginners is made to help you learn SQL the right way.
Video also includes Practice SQL Queries which can be downloaded from my blog (link mentioned below).

This is a complete SQL Tutorial covering all the SQL Basics including how to write simple SQL Queries. This Basic SQL Tutorial is aimed at beginners who are new to SQL programming language or are just exploring an easy programming language to get started.

This SQL Tutorial for Beginners not only explains the concept of SQL but also go through all the different types of queries that can be written using the basic SQL concepts.

Timestamps:
00:00 Intro
01:42 What is SQL
03:14 Different types of SQL Commands
03:36 What is Data Definition Language (DDL)
04:46 What is Data Type in SQL
06:11 What are Constraints in SQL
08:33 What is Data Manipulation Language (DML)
09:40 Practice SQL Commands (DDL, DML)
21:10 What is Data Query Language (DQL)
23:13 Practice simple SQL Queries
25:18 Operators in SQL (Comparison Operators, Arithmetic Operators, Logical Operators)
34:48 Case Statement in SQL
36:15 Different ways to write queries in SQL
42:30 UNION and UNION ALL Operators in SQL
47:18 GROUP BY Statement in SQL
56:10 Sub Queries in SQL
58:55 Aggregate Functions in SQL (AVG, MIN, MAX, COUNT, SUM)
01:01:56 SQL Joins (Inner Join, Left Join, Right Join, Full Outer Join)

At 70 minutes this video tries to cover all of the Basic SQL concepts and SQL Queries which are required to get started with SQL.

We cover the following:
1. Introduction to SQL
• Why is it important to learn SQL.
2. What is SQL?
3. SQL Commands
• DDL (Data Definition Language)
i. CREATE Table
ii. ALTER Table
iii. DROP Table
iv. TRUNCATE Table
• DML (Data Manipulation Language)
i. INSERT
ii. UPDATE
iii. DELETE
• DCL (Data Control Language)
i. GRANT
ii. REVOKE
• TCL (Transaction Control Language)
i. COMMIT
ii. ROLLBACK
iii. SAVEPOINT
• DQL (Data Query Language)
i. SELECT
4. Different SELECT Query functionalities:
• SQL Operators
i. Logical Operators
ii. Comparison Operators
iii. Arithmetic Operators
• CASE Statement
• Two ways of writing SQL Queries
i. Using comma separator
ii. Using JOIN
• UNION & UNION ALL Operators
• GROUP BY Statement
i. HAVING Clause
• Subquery
• Aggregate Functions
i. COUNT
ii. AVG
iii. MIN
iv. MAX
v. SUM
• SQL JOINS
i. INNER JOIN
ii. OUTER JOIN
1. LEFT OUTER JOIN
2. RIGHT OUTER JOIN
3. FULL OUTER JOIN

In this video, I am using PostgreSQL to practice and execute the SQL commands and SQL Queries. However the SQL syntax and SQL concepts are applicable to any other Relational Database or RDBMS (Relational Database Management System).

Download Link:
Download the SQL Scripts (DDL, DML and all SELECT Queries) from here:

From this link click on:
1) “Download DDL & DML” button to download a “.sql” file which has all the Create table and Insert Table scripts to create required tables and to insert meaningful data into it.
2) “Download SELECT Queries” button to download another “.sql” file which contains all the SELECT Queries which we practiced in this video.

My Blog:

Where you can find useful blog related to SQL, Database and many more in near future.

Reference Links:
If you wish to know more about SQL then I suggest going through the below links:

PostgreSQL All supported Data Types:

PostgreSQL Tutorial blog:

SQL Tutorial blog:

🔴 WATCH MORE VIDEOS HERE 👇

✅ SQL Tutorial - Basic concepts:

✅ SQL Tutorial - Intermediate concepts:

✅ SQL Tutorial - Advance concepts:

✅ Practice Solving Basic SQL Queries:

✅ Practice Solving Intermediate SQL Queries:

✅ Practice Solving Complex SQL Queries:

✅ SQL Course, SQL Training Platform Recommendations:

[techTFQ]

Since it's a long video, I am adding the timestamp to each of the sections covered in this video so you can skip and watch only the sections, you are interested in. A BIG THANK YOU to each and everyone one of you for appreciating this video!!!

Timestamps:
00:00​ Intro
01:42​ What is SQL
03:14​ Different types of SQL Commands
03:36​ What is Data Definition Language (DDL)
04:46​ What is Data Type in SQL
06:11​ What are Constraints in SQL
08:33​ What is Data Manipulation Language (DML)
09:40​ Practice SQL Commands (DDL, DML)
21:10​ What is Data Query Language (DQL)
23:13​ Practice simple SQL Queries
25:18​ Operators in SQL (Comparison Operators, Arithmetic Operators, Logical Operators)
34:48​ Case Statement in SQL
36:15​ Different ways to write queries in SQL
42:30​ UNION and UNION ALL Operators in SQL
47:18​ GROUP BY Statement in SQL
56:10​ Sub Queries in SQL
58:55​ Aggregate Functions in SQL (AVG, MIN, MAX, COUNT, SUM)
01:01:56​ SQL Joins (Inner Join, Left Join, Right Join, Full Outer Join)

[sonamkumar]

For the past 3 days, I have been trying to learn the basics of SQL from different channels. This video is, so far, the best in explanation. I love the fact that you make SQL sound so simple and easy to understand. I would definitely recommend you to other people who want to go into the data analytics business. Thank you so much.

[vshal]

Bro, i have to admit you are the best SQL teacher of the YouTube even better than my offline faculty. Thank You very much man.

[iReaperYo]

This video is absolutely brilliant. 1 hour to learn what I've been struggling with for months! This was vital in understanding the bigger picture. I am so grateful.

[aaronschwartzman]

Incredible content! You explain SQL very well. Never thought I’d learn SQL in an hour and 10 minutes. Thank you!

[aleskerovw]

I don't understand why this video has so small number of views and likes... The video is very informative, thank you very much!

[hemantgoyal]

Hands down one of the best SQL tutorials I've seen on the Internet! Perfectly planned and executed!

[gerrielegue]

Today I took basic SQL lessons. A very good and clear explanation. Thank you for setting up the lessons professionally. I am already looking forward to the next lessons.

I wish you and your family a healthy 2023

[payalsingh]

Thanks, I am giving interviews ri8 now and its so helpful to clear all doubt in less time. I love the fact that you make SQL sound so simple and easy to understand. I would definitely recommend you to other people who want to go into the data analytics business. Thank you so much.

[tekndesign]

You are a legend man! This is one of the best SQL tutorials out there. And the provided downloadable SQL Scripts just made it the best ever! The plain english language reference in front of each SQL queries, just gave me a goosebumps. A massive thank you, just what I've been looking for as SQL beginner.

[subramanianramasamy]

One of the best SQL Fundamental video I have seen!! You have really co ordinated every thing you can cover!! Well Done Mate!

[terihandrick]

Wow I am glad I found your channel. You have an excellent teaching ability! Clear and concise and you have presented content I have not seen elsewhere laying the groundwork for SQL. Great job!!

[samratdey]

Excellent! You are doing a great job dude. Hats off to your dedication and expertise. Wish our schools and colleges could atleast deliver 1% of what you are doing.

[peterwan]

This guide was extremely informative, clear, and well organized; thank you for this video! Wish you were a professor at my college!

[sheebaparveen]

Absolutely amazing video. Have watched so many videos on SQL but never such video like this where the required concepts are brilliantly explained without any dragging and just to the point. Perfect video for people who want to learn SQL in just little time. Great job. Loved this. Looking forward for more such videos.

[rufaiabiodun]

Great course for the beginners. Much appreciated! Thank you so much.

[yeasinarafat]

One of the best tutorials in SQL on YouTube. Thanks a lot for your contribution ❤

[shubhamshanker]

Amazing video in 1 hour you will understand all the basics concepts of SQL. Otherwise rest of the videos are 3 to 4 hours long. Thank you so much for the amazing and informative content<3

[ushalandesahoo]

Recently I switched from BA to DA role and your SQL videos are very useful. I have watched many videos but your way of explanation is easy to understand.

[anilkumarpasumarthi]

You have put things in an easy way and more practical. Great way of explanation, I thoroughly enjoyed the session.