MySQL 8+ Training Course Index

---

title: “MySQL 8+ Training Course — Complete Index” —

MySQL 8+ Training Course Index

Welcome to your complete MySQL training journey. This index lists every topic in the course. Check off each one as you complete it!

---

Setup

• Database Setup: company_db

---

Part 1 — Foundations

• CREATE TABLE
• INSERT
• UPDATE
• DELETE
• ALTER TABLE
• DROP TABLE
• SELECT with FROM and WHERE
• Filtering Data
• ORDER BY
• LIMIT
• Aggregate Functions (COUNT, SUM, AVG, MIN, MAX)
• GROUP BY
• HAVING vs WHERE
• Primary Key and Foreign Key Concepts
• INNER JOIN
• LEFT JOIN
• RIGHT JOIN
• DISTINCT
• NULL Handling (IS NULL / IS NOT NULL)
• String Functions (UPPER, LOWER)

---

Part 2 — Intermediate

• SUBSTRING
• CASE WHEN
• Self Joins
• Multiple Joins in One Query
• COALESCE
• Nested Subqueries
• Correlated Subqueries

---

Part 3 — Advanced

• Hierarchies Using Recursive CTEs
• Date Functions (NOW, DATE, DATEDIFF)
• Views (CREATE VIEW)
• ROW_NUMBER()
• RANK()
• Transactions (BEGIN, COMMIT, ROLLBACK)
• Query Cost and EXPLAIN

---

Mini Challenges

• Mini Challenge 1 — Topics 1-4
• Mini Challenge 2 — Topics 5-6
• Mini Challenge 3 — Topics 7-9
• Mini Challenge 4 — Topics 10-12
• Mini Challenge 5 — Topics 13-15
• Mini Challenge 6 — Topics 16-18
• Mini Challenge 7 — Topics 19-20, Substring
• Mini Challenge 8 — CASE WHEN, Self Joins, Multiple Joins
• Mini Challenge 9 — COALESCE, Nested Subqueries, Correlated Subqueries
• Mini Challenge 10 — Recursive CTEs, Date Functions, Views
• Mini Challenge 11 — ROW_NUMBER, RANK, Transactions

---

Your Progress

Track your learning journey in progress.md

---

Course Philosophy: One topic at a time. Master the fundamentals before moving forward. Say “next” when you’re ready.