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 : www.udemy.com/course/database...
#mysql #mariadb #database
Slide : docs.google.com/presentation/...
Source Code : 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 : saweria.co/ProgrammerZamanNow
Social Media :
Instagram : / programmerzamannow
Facebook : / programmerzamannow
Telegram : t.me/ProgrammerZamanNow
KZfaq : / programmerzamannow