My Progress Tracker

---

title: “My MySQL Learning Progress” —

My Progress Tracker

Use this file to track which topics you’ve completed. Mark each checkbox with an x when you finish a topic.

---

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 1 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)

---

Part 2 — Intermediate

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

Part 2 Mini Challenges:

• Mini Challenge 8 (CASE WHEN, Self Joins, Multiple Joins)
• Mini Challenge 9 (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)

Part 3 Mini Challenges:

• Mini Challenge 10 (Recursive CTEs, Date Functions, Views)
• Mini Challenge 11 (ROW_NUMBER, RANK, Transactions)

---

Completion Status

Topics Completed: 0 / 33 Mini Challenges Completed: 0 / 11

---

Tip: Update this file regularly. Seeing your progress builds momentum and confidence!