MySQL 49
- Query Cost and EXPLAIN
- MySQL 8+ Training Course Index
- Recursive CTEs — Traversing Hierarchies
- Correlated Subqueries — Row-by-Row Subqueries
- Nested Subqueries — Queries Within Queries
- RANK() and DENSE_RANK() — Handling Ties in Rankings
- COALESCE — First Non-NULL Value
- RIGHT JOIN
- My Progress Tracker
- Transactions — Ensuring Data Integrity
- ROW_NUMBER() — Numbering Rows with Window Functions
- Views — Reusable Query Logic
- Date and Time Functions — Working with Temporal Data
- Multiple Joins — Combining 3+ Tables
- Self Joins — Comparing Rows Within the Same Table
- CASE WHEN — Conditional Logic in SQL
- SUBSTRING — Extract Parts of Text
- String Functions (UPPER, LOWER)
- NULL Handling
- DISTINCT
- LEFT JOIN
- INNER JOIN
- Primary Key and Foreign Key Concepts
- HAVING vs WHERE
- GROUP BY
- Aggregate Functions
- LIMIT
- ORDER BY
- Filtering Data
- SELECT with FROM and WHERE
- DROP TABLE
- ALTER TABLE
- DELETE
- UPDATE
- INSERT
- CREATE TABLE — Building Your Database Structure
- Mini Challenge 11 — Capstone: Complete Business Intelligence Dashboard
- Mini Challenge 10 — Recursive CTEs, Dates, Views
- Mini Challenge 9 — COALESCE, Subqueries
- Mini Challenge 8 — SUBSTRING, CASE, Self Joins, Multiple Joins
- Mini Challenge 7 — NULL Handling, String Functions, and SUBSTRING
- Mini Challenge 6 — LEFT JOIN, RIGHT JOIN, and DISTINCT
- Mini Challenge 5 — HAVING, Keys, and INNER JOIN
- Mini Challenge 4 — LIMIT, Aggregate Functions, GROUP BY
- Mini Challenge 3 — SELECT, Filtering, and ORDER BY
- MySQL 8+ Training Course
- Mini Challenge 2 — ALTER TABLE, DROP TABLE
- Mini Challenge 1 — CREATE TABLE, INSERT, UPDATE, DELETE
- Database Setup: company_db