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. 

If you’d like to practice SQL queries or explore my recorded SQL courses, check out my all-in-one SQL learning platform, SQLNest 👇
https://sqlnest.com/

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.

techTFQ

A beginner-focused SQL course covering installation of PostgreSQL and pgAdmin, database and table creation, data types, CRUD operations (INSERT, SELECT, UPDATE, DELETE), filtering with WHERE and LIKE, aggregate functions (COUNT, SUM, AVG), aliases, date functions, and DDL commands like CREATE, DROP, ALTER, and TRUNCATE. Uses a sales order dataset with 20 practice queries to build foundational SQL skills applicable to any relational database.

Learn Basic SQL in 3.5 hrs | Complete SQL Beginner Course