MySQL

1. 1

   Apa itu MySQL

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

   CLI mysql dan Perintah Pertama

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

   Membuat Database dan Tabel

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

   Tipe Data

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

   SELECT dan WHERE

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

   Join

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

   Aggregate dan Pengelompokan

   COUNTSUMAVGMIN and MAXGROUP BYHAVING+2
   30 mnt
8. 8

   Index

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

   Transaksi dan Storage Engine

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

    Stored Procedures dan Triggers

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

    EXPLAIN dan Query Tuning

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

    mysqldump dan Pemulihan

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

    Capstone: Rancang Skema Ecommerce

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

Setiap pelajaran, kuis, dan balasan tutor tampil dalam bahasamu. Tutor AI menjawab dalam bahasa yang kamu pakai.

See how hiring teams interview engineers on MySQL, in production-like environments.