MySQL

1. 1

   What is MySQL

   Relational databaseHistory and Oracle ownershipMariaDB forkMySQL vs Postgres trade-offsInnoDB default engine
   20 min
2. 2

   The mysql CLI and First Commands

   Mysql clientConnecting with -u and -pSHOW DATABASESUSESHOW TABLESDESCRIBE+2
   25 min
3. 3

   Creating Databases and Tables

   CREATE DATABASECharacter sets and collationCREATE TABLEPRIMARY KEYAUTO_INCREMENTNOT NULL+3
   30 min
4. 4

   Data Types

   INT and BIGINTDECIMAL vs FLOATVARCHAR vs TEXTBOOLEAN as TINYINTDATE vs DATETIME vs TIMESTAMPENUM+1
   30 min
5. 5

   SELECT and WHERE

   SELECT columnsWHEREAND and ORBETWEENINLIKE with % and _+3
   30 min
6. 6

   Joins

   INNER JOINLEFT JOINRIGHT JOINNo FULL OUTER JOINUNION workaroundSelf-join+1
   35 min
7. 7

   Aggregates and Grouping

   COUNTSUMAVGMIN and MAXGROUP BYHAVING+2
   30 min
8. 8

   Indexes

   B-tree indexCREATE INDEXMulti-column index left-prefix ruleUNIQUE indexFULLTEXT indexIndexes hurt write performance
   30 min
9. 9

   Transactions and Storage Engines

   InnoDB vs MyISAMSTART TRANSACTIONCOMMITROLLBACKIsolation levelsREPEATABLE READ default+1
   35 min
10. 10

    Stored Procedures and Triggers

    DELIMITERCREATE PROCEDUREIN and OUT parametersCALLCREATE TRIGGERBEFORE INSERT and AFTER UPDATE+1
    35 min
11. 11

    EXPLAIN and Query Tuning

    EXPLAINType column (ALL, ref, range, eq_ref, const)Key and rows columnsEXPLAIN ANALYZE (MySQL 8+)Adding a missing indexSlow query log
    35 min
12. 12

    mysqldump and Restore

    MysqldumpRedirecting to .sqlRestoring with mysql client--single-transaction for InnoDB--no-data for schema only--all-databases
    25 min
13. 13

    Capstone: Design an Ecommerce Schema

    Foreign keysON DELETE behaviorIndexes on lookup columnsTransactional order creationEXPLAIN on a real query
    50 min

Every lesson, quiz, and tutor reply renders in your language. The AI tutor matches the language you ask in.