Menengah
MySQL
Pelajari MySQL dari CLI hingga desain skema. Dasar SQL, join, indeks, transaksi, stored procedure, EXPLAIN, dan operasi database.
13 pelajaran6.8h praktik11 bahasa
Mulai belajar gratisMySQL kursus13 pelajaran, berurutan
- 120 mnt
Apa itu MySQL
Relational databaseHistory and Oracle ownershipMariaDB forkMySQL vs Postgres trade-offsInnoDB default engine - 225 mnt
CLI mysql dan Perintah Pertama
Mysql clientConnecting with -u and -pSHOW DATABASESUSESHOW TABLESDESCRIBE+2 - 330 mnt
Membuat Database dan Tabel
CREATE DATABASECharacter sets and collationCREATE TABLEPRIMARY KEYAUTO_INCREMENTNOT NULL+3 - 430 mnt
Tipe Data
INT and BIGINTDECIMAL vs FLOATVARCHAR vs TEXTBOOLEAN as TINYINTDATE vs DATETIME vs TIMESTAMPENUM+1 - 530 mnt
SELECT dan WHERE
SELECT columnsWHEREAND and ORBETWEENINLIKE with % and _+3 - 635 mnt
Gabungan
INNER JOINLEFT JOINRIGHT JOINNo FULL OUTER JOINUNION workaroundSelf-join+1 - 730 mnt
Agregat dan Pengelompokan
COUNTSUMAVGMIN and MAXGROUP BYHAVING+2 - 830 mnt
Indeks
B-tree indexCREATE INDEXMulti-column index left-prefix ruleUNIQUE indexFULLTEXT indexIndexes hurt write performance - 935 mnt
Transaksi dan Mesin Penyimpanan
InnoDB vs MyISAMSTART TRANSACTIONCOMMITROLLBACKIsolation levelsREPEATABLE READ default+1 - 1035 mnt
Prosedur Tersimpan dan Pemicu
DELIMITERCREATE PROCEDUREIN and OUT parametersCALLCREATE TRIGGERBEFORE INSERT and AFTER UPDATE+1 - 1135 mnt
EXPLAIN dan Penyetelan Kueri
EXPLAINType column (ALL, ref, range, eq_ref, const)Key and rows columnsEXPLAIN ANALYZE (MySQL 8+)Adding a missing indexSlow query log - 1225 mnt
mysqldump dan Pemulihan
MysqldumpRedirecting to .sqlRestoring with mysql client--single-transaction for InnoDB--no-data for schema only--all-databases - 1350 mnt
Capstone: Rancang Skema Ecommerce
Foreign keysON DELETE behaviorIndexes on lookup columnsTransactional order creationEXPLAIN on a real query
Pelajari MySQL dalam bahasamu
Setiap pelajaran, kuis, dan balasan tutor tampil dalam bahasamu. Tutor AI menjawab dalam bahasa yang kamu pakai.