-
Instalasi MySQL Server Full Package
-
Show, Create, Delete, dan Use Database
-
Show, Create, dan Delete Table
-
Insert Data ke Tabel
-
Null dan Not Null
-
Default Value pada Insert Data
-
Warning pada Insert Data
-
Primary Key pada Table Bagian A
-
Primary Key pada Table Bagian B
-
Select Data Table Bagian A
-
Select Data Table Bagian B
-
Where Clause pada SQL
-
Aliases pada SQL
-
Update Data Table
-
Delete Data Table
-
Fungsi String – SubSTR
-
Fungsi String – Replace
-
Fungsi String – Reverse
-
Fungsi String – Char_Length
-
Fungsi String – Case Upper dan Lower
-
Select with Distinct
-
Select with Order By
-
Select with Limit
-
Select with Like Bagian A
-
Select with Like Bagian B
-
Fungsi Agregate – Count
-
Fungsi Agregate – Group By
-
Fungsi Agregate – Sum
-
Fungsi Agregate – Average
-
Type Data Char dan Varchar
-
Type Data Decimal
-
Type Data Float dan Double
-
Type Data Date, Time, dan DateTime
-
Type Data Current Date, Time dan Now
-
Formating DateTime Bagian A
-
Formating DateTime Bagian B
-
Type Data Date Math
-
Type Data TimeStamp
-
Operator Logik – Not Equal dan Not Like
-
Operator Logik – Greater dan Less Than
-
Operator Logik – And, Or, dan Between Bagian A
-
Operator Logik – And, Or, dan Between Bagian B
-
Operator Logik – In dan Not In
-
Operator Logik – Case Statement
-
Relation Data – Persiapan Foreign Key Bagian A
-
Relation Data – Persiapan Foreign Key Bagian B
-
Relation Data – Cross dan Inner Join
-
Relation Data – Left Join
-
Relation Data – Right Join
-
Relation Data – Many to Many Bagian A
-
Relation Data – Many to Many Bagian B
-
Study Case Instagram – Clone Comments Likes
-
Study Case Instagram – Clone Follows Tags
-
Study Case Instagram – Insert Data Bagian A
-
Study Case Instagram – Insert Data Bagian B
-
Node JS – Instalasi Node JS
-
Node JS – Cara Menggunakan Node JS dan Faker Bagian A
-
Node JS – Cara Menggunakan Node JS dan Faker Bagian B
-
Node JS – Koneksi Node JS dengan MySQL Bagian A
-
Node JS – Koneksi Node JS dengan MySQL Bagian B
-
Node JS – Create dan Select
-
Node JS – Insert Data Random Bagian A
-
Node JS – Insert Data Random Bagian B
-
Node JS – App Simple
-
Node JS – App dan Route Bagian A
-
Node JS – App dan Route Bagian B
-
Node JS – MySQL Web Konek Part 2 Bagian A
-
Node JS – MySQL Web Konek Part 2 Bagian B
-
Trigger pada Database Part 1
-
Trigger pada Database Part 2 Bagian A
-
Trigger pada Database Part 2 Bagian B