About This Course

Di video kali ini, saya akan bahas tentang belajar database MySQL, salah satu database relational yang paling populer di dunia. Di video ini kita akan banyak belajar tentang perintah SQL di MySQL dari pembuatan database, table dan manipulasi data di MySQL. Tak lupa kita juga akan belajar tentang relational, foreign key, join table, dan lain-lain. PREMIUM COURSE MYSQL : https://www.udemy.com/course/database... #mysql #mariadb #database Slide : https://docs.google.com/presentation/... Source Code : https://github.com/ProgrammerZamanNow... Materi Video : 00:00:00 - Pendahuluan 00:01:41 - Pengenalan Sistem Basis Data 00:12:05 - Pengenalan SQL 00:20:28 - Menginstall MySQL 00:37:07 - Database 00:45:47 - Tipe Data 00:49:10 - Tipe Data Number 00:55:31 - Tipe Data String 01:02:34 - Tipe Data Date dan Time 01:05:50 - Tipe Data Boolean 01:06:49 - Tipe Data Lainnya 01:08:22 - Table 01:33:08 - Insert Data 01:41:40 - Select Data 01:44:21 - Primary key 01:50:38 - Where Clause 01:54:14 - Update Data 02:02:05 - Delete Data 02:04:43 - Alias 02:08:57 - Where Operator 02:29:24 - Order By Clause 02:33:10 - Limit Clause 02:37:19 - Select Distinct Data 02:39:24 - Numeric Function 02:45:36 - Auto Increment 02:52:34 - String Function 02:55:29 - Date dan Time Function 02:58:21 - Flow Control Function 03:06:01 - Aggregate Function 03:10:31 - Grouping 03:16:45 - Constraint 03:28:17 - Index 03:42:15 - Full-Text Search 03:54:05 - Table Relationship 04:11:58 - Join 04:23:19 - One to One Relationship 04:31:42 - One to Many Relationship 04:40:54 - Many to Many Relationship 05:00:05 - Jenis-Jenis Join 05:14:40 - Subquery 05:20:20 - Set Operator 05:34:22 - Transaction 05:46:45 - Locking 06:12:01 - User Management 06:24:11 - Backup Database 06:28:50 - Restore Database 06:33:27 - Materi Selanjutnya Donasi : Saweria : https://saweria.co/ProgrammerZamanNow Social Media : Instagram : https://www.instagram.com/ProgrammerZ... Facebook : https://www.facebook.com/ProgrammerZa... Telegram : https://t.me/ProgrammerZamanNow Youtube : https://www.youtube.com/c/ProgrammerZ...