Learn Basic SQL in 3.5 hrs | Complete SQL Beginner Course

This video contains a full SQL course for beginners. Anyone willing to learn SQL from scratch will benefit from this video. Here I only cover IMPORTANT basic SQL concepts that can help you clear interviews and perform SQL activities at your job.

All the scripts, datasets, and notes used during the video can be downloaded from my blog below:

Timestamp:
00:00 Intro
00:15 Overview of video content
01:39 Install PostgreSQL Database & PgAdmin tool
06:59 Create a new database
07:40 Brilliant Overview
10:02 What is a database?
11:40 What is a table?
12:23 Create a simple table
18:52 Load data
24:55 Read data
36:06 Modify data
46:14 Remove data
50:18 SQL Commands
55:00 Remove table
57:46 Modify table
01:00:54 Primary Key Constraint
01:10:08 Identity Constraint (column)
01:16:54 Foreign Key Constraint
01:21:17 Creating the Sales Order Dataset
01:24:15 Case Study
01:25:39 Problem no 1
01:28:44 Problem no 2
01:39:11 Problem no 3
01:44:17 INNER JOIN in SQL
01:52:00 Problem no 4
01:58:33 Problem no 5
01:59:35 GROUP BY in SQL
02:07:32 Problem no 6
02:11:00 Problem no 7
02:21:00 Problem no 8
02:26:40 Problem no 9
02:30:22 Problem no 10
02:39:40 Problem no 11
02:47:52 Problem no 12
02:52:09 Problem no 13
02:54:54 LEFT and RIGHT Outer JOIN
03:03:52 Problem no 14
03:08:12 Problem no 15
03:14:54 Problem no 16
03:18:50 Problem no 17
03:21:49 Problem no 18
03:26:26 Problem no 19
03:29:06 Problem no 20

Thank you for watching!

Subscribe to the channel for more such content.

[techTFQ]

Get a 30-day free trial of Brilliant using the link below:

[christianwiah]

I have watched and learned from a lot of your lectures and teachings. Some are over 2 or 3 years, and with you planning a whole new and full SQL videos makes me happy. I see a lot of Postgres and MySQL rather than SQL Server around new SQL videos lately.

[sidheshbhambid]

I had attended one of your bootcamps and have learned almost entire SQL from you. This helped me greatly in my previous job and made me feel confident about SQL. You make SQL look so easy through your flawless teaching style. Thank you for all your videos on YouTube!!

[encyashiktaneja]

Just stupendulous Thoufiq, even after knowing the concepts came to know about their finest of key points through the video. the question variety was great and the way you incorporated all the concepts through the question flow was absolutely smooth.

[rishabhkushwaha]

Thnaks, Please also upload immediate and advanced sql topics....your videos clears every concept very easily

[zero_analyst]

This is one the best video on youtube to learn SQL from scratch!

Thank you so much for publishing this video sir!

[rajeshm]

Change the column to primary key using alter command is
alter tablename add primary key(column_name)

[SherlinSounderrajan]

I work as an ETL tester, and my main skill is SQL. I’m confident that all the videos are beneficial to me. If you have any videos explaining ETL in more detail, I would appreciate it if you could upload those too.

[akankshajagtap]

best video so please provide the advanced sql tutorial

[hairavyadav]

I allready know but still I am watching because I believe I something new from techtfq

[harilalchauhan]

Your sql video has helped me a lot understanding sql concepts.

Your teaching makes sql easy to understand.

Thanks You

[aakashmishra]

Hi,

I feel that in Q9, you should have multiplied the price by the quantity of each type of product sold on a particular day and eventually should have added the quantities obtained for each day to have found the total sales each day

[rupalichaurasia]

Sir, I watched your all videos they're valuable for us.

[harishpatil]

This is excellent! Please create a video for intermediate and advanced levels in a similar format

[ShamTheAnalyst]

Thanks a lot! As a beginner this tutorial is really helpful and provides a clear understanding .

[secret_step]

Indeed an amazing video on sql problems. This is how we learn from a mentor. Thanks Taufiq

[chrincypallattujose]

Thank you so much for your videos techTFQ.. Your videos are just amazing!!

[SANDATA]

So far, I can confidently say that Toufiq Mohamed's SQL course is the best, especially with the way he teaches

[mohammedshahil]

Much needed video for a beginner in SQL👌🏻👌🏻👌🏻 Super easy to understand and very informative 👍🏻

[pamlayyevette]

Thank you for making this video. Very detailed and informative. I was able to follow along and I’m happy I found your channel. You’ve helped me to land a role now that I fully understand sql