Skip to content
Learn Netverks

Track

mysql

MySQL

36 lessons: InnoDB, utf8mb4, EXPLAIN—mysql client practice + MCQs.

Mode
sql_sandbox
Practice
SQL sandbox
Lessons
36 units

Before you start

MySQL-specific SQL dialect, indexing, storage engines, and operational habits.

Extremely common in LAMP stacks, WordPress, and managed cloud databases.

Web apps on shared hosting, ecommerce, and many startups’ first production DB.

SQL sandbox lessons highlighting MySQL syntax and EXPLAIN-oriented debugging.

After core SQL—when your stack or job standardizes on MySQL/MariaDB.

Lesson order

Sequential — follow top to bottom

36 lessons are live in this track. Start from step 01 for the smoothest path.

  1. 01 intro Introduction to MySQL

    beginner

    Open →
  2. 02 what-is-mysql What is MySQL?

    beginner

    Open →
  3. 03 mysql-vs-postgresql-preview MySQL vs PostgreSQL preview

    beginner

    Open →
  4. 04 mysql-ecosystem-preview MySQL ecosystem preview

    beginner

    Open →
  5. 05 mysql-workflow MySQL workflow

    beginner

    Open →
  6. 06 mysql-client-basics mysql client basics

    beginner

    Open →
  7. 07 data-types-mysql MySQL data types

    beginner

    Open →
  8. 08 auto-increment-keys AUTO_INCREMENT keys

    beginner

    Open →
  9. 09 charset-collation-utf8mb4 Character set and utf8mb4

    beginner

    Open →
  10. 10 insert-select-mysql-basics INSERT and SELECT basics

    beginner

    Open →
  11. 11 on-duplicate-key ON DUPLICATE KEY UPDATE

    intermediate

    Open →
  12. 12 create-table-mysql CREATE TABLE in MySQL

    beginner

    Open →
  13. 13 engines-innodb-myisam Storage engines: InnoDB and MyISAM

    intermediate

    Open →
  14. 14 constraints-mysql Constraints in MySQL

    intermediate

    Open →
  15. 15 indexes-mysql Indexes in MySQL

    intermediate

    Open →
  16. 16 foreign-keys-mysql Foreign keys

    intermediate

    Open →
  17. 17 views-stored-procedures-preview Views and stored procedures preview

    intermediate

    Open →
  18. 18 select-mysql-dialect SELECT and MySQL dialect

    intermediate

    Open →
  19. 19 joins-mysql JOINs in MySQL

    intermediate

    Open →
  20. 20 aggregates-mysql Aggregates and GROUP BY

    intermediate

    Open →
  21. 21 subqueries-mysql Subqueries in MySQL

    intermediate

    Open →
  22. 22 window-functions-mysql Window functions (MySQL 8.0+)

    advanced

    Open →
  23. 23 json-type-mysql JSON type in MySQL

    intermediate

    Open →
  24. 24 transactions-innodb InnoDB transactions

    advanced

    Open →
  25. 25 isolation-levels-mysql Isolation levels

    advanced

    Open →
  26. 26 explain-mysql EXPLAIN and query tuning

    advanced

    Open →
  27. 27 replication-preview-mysql Replication preview

    advanced

    Open →
  28. 28 users-privileges-mysql Users and privileges

    advanced

    Open →
  29. 29 backup-restore-mysql Backup and restore

    advanced

    Open →
  30. 30 connection-pooling-mysql Connection pooling

    intermediate

    Open →
  31. 31 mysql-with-laravel MySQL with Laravel

    intermediate

    Open →
  32. 32 mysql-with-php MySQL with PHP (PDO)

    intermediate

    Open →
  33. 33 performance-schema-preview Performance Schema preview

    advanced

    Open →
  34. 34 mariadb-compatibility-notes MariaDB compatibility notes

    intermediate

    Open →
  35. 35 interview-essentials-mysql MySQL interview essentials

    intermediate

    Open →
  36. 36 production-checklist-mysql MySQL production checklist

    beginner

    Open →