Master Basic SQL in Just 3.5 Hours – Beginner-Friendly 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.