▶
📚 What you'll learn
✓SELECT, WHERE, ORDER BY, LIMIT mastery
✓GROUP BY, HAVING, aggregate functions
✓INNER JOIN, LEFT JOIN, all JOIN types
✓Subqueries, CTEs and correlated queries
✓Window functions: ROW_NUMBER, RANK, LAG
✓Database design and ERD diagrams
✓Normalization to 3NF
✓Indexes, views and stored procedures
Course Curriculum
01Introduction to Databases & SQL
▾
🎬
What is a Database? Relational vs NoSQLVideo · 18:00
FREE
🎬
Installing MySQL & Running First QueriesVideo · 22:00
FREE
🎬
SELECT — Querying DataVideo · 28:00
🎬
WHERE — Filtering DataVideo · 25:00
📝
Quiz — SQL FoundationsQuiz · 15:00
02Aggregation, Grouping & Joins
▾
🎬
Aggregate Functions — COUNT, SUM, AVG, MIN, MAXVideo · 28:00
🎬
GROUP BY & HAVINGVideo · 30:00
🎬
INNER JOIN & LEFT JOINVideo · 35:00
🎬
Subqueries & CTEsVideo · 30:00
🎬
Window Functions — ROW_NUMBER, RANK, LAGVideo · 32:00
🛠️
Project 1 — School Database AnalyticsProject · 90:00
03Database Design & Normalization
▾
🎬
Entity Relationship Diagrams (ERD)Video · 28:00
🎬
Normalization — 1NF, 2NF, 3NFVideo · 30:00
🎬
Indexes, Views & Stored ProceduresVideo · 28:00
🛠️
Project 2 — E-Commerce Database DesignProject · 90:00
04MySQL with Python & Advanced Topics
▾
🎬
Connecting Python to MySQLVideo · 28:00
🎬
Transactions & ACID PropertiesVideo · 22:00
🎬
Query Optimization & EXPLAINVideo · 25:00
🛠️
Final Project — Full Database SystemProject · 120:00