Learn Basic SQL in 3.5 hrs | Complete SQL Beginner Course

Get a 30-day free trial of Brilliant using the link: https://brilliant.org/techTFQ/ 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: https://techtfq.com/blog/sql-tutorial-for-beginners-in-3-hours 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.