Comprehensive beginner-friendly SQL tutorial series. Master relational databases from core SELECT queries, filtering, and data modification to multi-table joins, window functions, and real-world database analysis.
Course Syllabus (82 Chapters)
1
Start →
SQL Home, Syllabus & Study Plan
2
Start →
SQL Intro & RDBMS Architecture
3
Start →
SQL Editor & Sample Database Setup
4
Start →
SQL Syntax, Semicolons & Comments
5
Start →
SQL SELECT Statement
6
Start →
SQL SELECT DISTINCT
7
Start →
SQL WHERE Clause
8
Start →
SQL ORDER BY (ASC / DESC)
9
Start →
SQL AND, OR & NOT Operators
10
Start →
SQL Comparison & Arithmetic Operators
11
Start →
SQL String Functions
12
Start →
SQL Numeric Functions
13
Start →
SQL SELECT TOP, LIMIT & FETCH
14
Start →
SQL LIKE & Pattern Wildcards
15
Start →
SQL IN & BETWEEN Operators
16
Start →
SQL Aliases (AS) for Columns & Tables
17
Start →
SQL NULL Values (IS NULL / IS NOT NULL)
18
Start →
SQL INSERT INTO Statement
19
Start →
SQL UPDATE Statement
20
Start →
SQL DELETE vs TRUNCATE vs DROP
21
Start →
SQL MERGE & UPSERT
22
Start →
SQL Aggregate Functions & COUNT()
23
Start →
SQL MIN() & MAX()
24
Start →
SQL SUM() & AVG()
25
Start →
SQL GROUP BY Statement
26
Start →
SQL HAVING Clause
27
Start →
SQL Joins & INNER JOIN
28
Start →
SQL LEFT JOIN
29
Start →
SQL RIGHT JOIN
30
Start →
SQL FULL OUTER JOIN
31
Start →
SQL SELF JOIN & CROSS JOIN
32
Start →
SQL UNION & UNION ALL
33
Start →
SQL Subqueries
34
Start →
SQL EXISTS, ANY & ALL
35
Start →
SQL CASE Statement
36
Start →
SQL NULL Functions (COALESCE, IFNULL, NVL)
37
Start →
SQL CAST & CONVERT
38
Start →
SQL SELECT INTO & INSERT INTO SELECT
39
Start →
SQL CTEs (Common Table Expressions) & Recursion
40
Start →
SQL Window Functions I (ROW_NUMBER, RANK, DENSE_RANK)
41
Start →
SQL Window Functions II (LAG, LEAD, Running Totals)
42
Start →
SQL Pivot & Conditional Aggregation
43
Start →
SQL JSON Functions & Array Querying
44
Start →
SQL CREATE & DROP DATABASE
45
Start →
SQL Database Backups & Restore
46
Start →
SQL Data Types Deep Dive
47
Start →
SQL CREATE TABLE & DROP TABLE
48
Start →
SQL ALTER TABLE
49
Start →
SQL Constraints & NOT NULL
50
Start →
SQL UNIQUE & PRIMARY KEY
51
Start →
SQL FOREIGN KEY & Referential Integrity
52
Start →
SQL CHECK & DEFAULT Constraints
53
Start →
SQL CREATE INDEX (Performance Optimization)
54
Start →
SQL Query Optimization & EXPLAIN Plans
55
Start →
SQL AUTO INCREMENT & Sequences
56
Start →
SQL Database Design & Normalization (1NF, 2NF, 3NF)
57
Start →
SQL Dates & Time-Series Operations
58
Start →
SQL Views & Materialized Views
59
Start →
SQL Stored Procedures & Parameters
60
Start →
SQL User-Defined Functions (UDFs)
61
Start →
SQL Triggers (Audit Logs & Validation)
62
Start →
SQL Transactions (ACID, COMMIT, ROLLBACK)
63
Start →
SQL Users, GRANT & REVOKE Permissions
64
Start →
SQL Injection Attacks & Prevention
65
Start →
SQL Parameters & Prepared Statements
66
Start →
SQL Database Hosting & Cloud Deployment
67
Start →
SQL Keywords Alphabetical Reference
68
Start →
MySQL Built-In Functions Reference
69
Start →
SQL Server (T-SQL) Functions Reference
70
Start →
MS Access Functions Reference
71
Start →
PostgreSQL Functions & Operators Reference
72
Start →
SQL Quick Reference & Cheat Sheet
73
Start →
Data Cleaning with SQL
74
Start →
Time-Series Analysis & MoM Growth
75
Start →
Cohort & Customer Retention Analysis
76
Start →
Funnel Conversion & Drop-Off Analysis
77
Start →
RFM Customer Segmentation with NTILE
78
Start →
SQL with Python (Pandas & SQLAlchemy)
79
Start →
SQL with BI Tools (Power BI & Tableau)
80
Start →
Project 1: E-commerce Sales Performance
81
Start →
Project 2: HR Workforce & Attrition Analytics
82
Start →