SQL & Relational Databases — Zero to Hero

2h 53m total

A complete, hands-on journey through SQL and relational databases, taught on PostgreSQL 16/17 — from your very first SELECT to designing, indexing, and tuning schemas that hold up in production. You'll query with filters, joins, aggregation, subqueries and CTEs, and window functions; model data with normalization, keys, and constraints; read EXPLAIN ANALYZE plans and add the right indexes; and reason about transactions, ACID, and isolation levels. Mixes prose, runnable queries, MCQ checks, output-prediction drills, ordering and matching activities, an embedded SQL console, and mentor-chat prompts so every skill is rehearsed in the format that fits it best.

SQL CoreDatabases RelationalCareer SWE Foundations

Includes:

Cheat sheet
Progress tracking
Audio narration
Mentor context

Outline

Enroll to unlock

1.
Getting Set Up: PostgreSQL, psql, and Relations
22 min3 lessons
1. Locked — enroll to unlock. Install PostgreSQL and connect with psql8 min
2. Locked — enroll to unlock. Create a database and run your first query8 min
3. Locked — enroll to unlock. What a relation actually is6 min
2.
SELECT, Filtering, Ordering, and NULLs
22 min3 lessons
1. Locked — enroll to unlock. Reading columns and computing expressions6 min
2. Locked — enroll to unlock. Filtering, ordering, and limiting10 min
3. Locked — enroll to unlock. NULL: the value that means unknown6 min
3.
Joins and Set Operations
19 min3 lessons
1. Locked — enroll to unlock. INNER and LEFT joins8 min
2. Locked — enroll to unlock. RIGHT, FULL, CROSS, and self-joins6 min
3. Locked — enroll to unlock. Set operations: UNION, INTERSECT, EXCEPT5 min
4.
Aggregation, GROUP BY, HAVING, Grouping Sets
21 min3 lessons
1. Locked — enroll to unlock. Aggregate functions6 min
2. Locked — enroll to unlock. GROUP BY and HAVING10 min
3. Locked — enroll to unlock. Grouping sets, ROLLUP, and CUBE5 min
5.
Subqueries, CTEs, and Recursion
19 min3 lessons
1. Locked — enroll to unlock. Subqueries8 min
2. Locked — enroll to unlock. Common table expressions (WITH)5 min
3. Locked — enroll to unlock. Recursive CTEs6 min
6.
Window Functions
16 min3 lessons
1. Locked — enroll to unlock. The OVER clause5 min
2. Locked — enroll to unlock. Ranking functions5 min
3. Locked — enroll to unlock. Offsets, running totals, and frames6 min
7.
Data Modeling, Normalization, and DDL
17 min3 lessons
1. Locked — enroll to unlock. Modeling entities and relationships5 min
2. Locked — enroll to unlock. Normalization (1NF to 3NF)6 min
3. Locked — enroll to unlock. CREATE TABLE: types, keys, and constraints6 min
8.
Indexing, EXPLAIN, and Query Performance
17 min3 lessons
1. Locked — enroll to unlock. Indexes6 min
2. Locked — enroll to unlock. EXPLAIN: reading the query plan6 min
3. Locked — enroll to unlock. Tuning heuristics5 min
9.
Transactions, ACID, Isolation, and a Real Capstone
20 min3 lessons
1. Locked — enroll to unlock. Transactions and ACID6 min
2. Locked — enroll to unlock. Isolation levels and locking6 min
3. Locked — enroll to unlock. Capstone: model and query a lending library8 min

Includes:

Cheat sheet
Progress tracking
Audio narration
Mentor context

Outline

Enroll to unlock

1.
Getting Set Up: PostgreSQL, psql, and Relations
22 min3 lessons
1. Locked — enroll to unlock. Install PostgreSQL and connect with psql8 min
2. Locked — enroll to unlock. Create a database and run your first query8 min
3. Locked — enroll to unlock. What a relation actually is6 min
2.
SELECT, Filtering, Ordering, and NULLs
22 min3 lessons
1. Locked — enroll to unlock. Reading columns and computing expressions6 min
2. Locked — enroll to unlock. Filtering, ordering, and limiting10 min
3. Locked — enroll to unlock. NULL: the value that means unknown6 min
3.
Joins and Set Operations
19 min3 lessons
1. Locked — enroll to unlock. INNER and LEFT joins8 min
2. Locked — enroll to unlock. RIGHT, FULL, CROSS, and self-joins6 min
3. Locked — enroll to unlock. Set operations: UNION, INTERSECT, EXCEPT5 min
4.
Aggregation, GROUP BY, HAVING, Grouping Sets
21 min3 lessons
1. Locked — enroll to unlock. Aggregate functions6 min
2. Locked — enroll to unlock. GROUP BY and HAVING10 min
3. Locked — enroll to unlock. Grouping sets, ROLLUP, and CUBE5 min
5.
Subqueries, CTEs, and Recursion
19 min3 lessons
1. Locked — enroll to unlock. Subqueries8 min
2. Locked — enroll to unlock. Common table expressions (WITH)5 min
3. Locked — enroll to unlock. Recursive CTEs6 min
6.
Window Functions
16 min3 lessons
1. Locked — enroll to unlock. The OVER clause5 min
2. Locked — enroll to unlock. Ranking functions5 min
3. Locked — enroll to unlock. Offsets, running totals, and frames6 min
7.
Data Modeling, Normalization, and DDL
17 min3 lessons
1. Locked — enroll to unlock. Modeling entities and relationships5 min
2. Locked — enroll to unlock. Normalization (1NF to 3NF)6 min
3. Locked — enroll to unlock. CREATE TABLE: types, keys, and constraints6 min
8.
Indexing, EXPLAIN, and Query Performance
17 min3 lessons
1. Locked — enroll to unlock. Indexes6 min
2. Locked — enroll to unlock. EXPLAIN: reading the query plan6 min
3. Locked — enroll to unlock. Tuning heuristics5 min
9.
Transactions, ACID, Isolation, and a Real Capstone
20 min3 lessons
1. Locked — enroll to unlock. Transactions and ACID6 min
2. Locked — enroll to unlock. Isolation levels and locking6 min
3. Locked — enroll to unlock. Capstone: model and query a lending library8 min

Outline

Getting Set Up: PostgreSQL, psql, and Relations

SELECT, Filtering, Ordering, and NULLs

Joins and Set Operations

Aggregation, GROUP BY, HAVING, Grouping Sets

Subqueries, CTEs, and Recursion

Window Functions

Data Modeling, Normalization, and DDL

Indexing, EXPLAIN, and Query Performance

Transactions, ACID, Isolation, and a Real Capstone

Outline

Getting Set Up: PostgreSQL, psql, and Relations

SELECT, Filtering, Ordering, and NULLs

Joins and Set Operations

Aggregation, GROUP BY, HAVING, Grouping Sets

Subqueries, CTEs, and Recursion

Window Functions

Data Modeling, Normalization, and DDL

Indexing, EXPLAIN, and Query Performance

Transactions, ACID, Isolation, and a Real Capstone