Database PostgreSQL untuk Pemula sampai Mahir
Di kelas ini kita akan belajar database PostgreSQL. Salah satu database populer untuk di perusahaan besar
Daftar Materi
Available in
days
days
after you enroll
- Slide dan Source Code
- 01-Pendahuluan (1:23)
- 02-Pengenalan-Sistem-Basis-Data (7:27)
- 03-Pengenalan-PostgreSQL (4:11)
- 04-Menginstall-PostgreSQL (18:37)
- 05-Database (9:30)
- 06-Tipe-Data (2:08)
- 07-Tipe-Data-Number (4:01)
- 08-Tipe-Data-String (5:35)
- 09-Tipe-Data-Date-dan-Time (2:58)
- 10-Tipe-Data-Boolean (0:52)
- 11-Tipe-Data-Enum (1:43)
- 12-TIpe-Data-Lainnya (1:35)
- 13-Table (15:31)
- 14-Insert-Data (8:39)
- 15-Select-Data (2:36)
- 16-Primary-Key (3:17)
- 17-Where-Clause (2:31)
- 18-Update-Data (8:26)
- 19-Delete-Data (3:05)
- 20-Alias (5:45)
- 21-Where-Operator (26:25)
- 22-Order-By-Clause (2:35)
- 23-Limit-Clause (4:39)
- 24-Select-Distinct-Data (1:43)
- 25-Numeric-Function (6:33)
- 26-Auto-Increment (6:53)
- 27-Sequence (6:18)
- 28-String-Function (2:36)
- 29-Date-dan-Time-Function (3:02)
- 30-Flow-Control-Function (7:55)
- 31-Aggregate-Function (3:15)
- 32-Grouping (7:41)
- 33-Constraint (11:30)
- 34-Index (15:20)
- 35-Full-Text-Search (13:13)
- 36-Table-Relationship (13:31)
- 37-Join (9:08)
- 38-One-to-One-Relationship (6:24)
- 39-One-to-Many-Relationship (7:35)
- 40-Many-to-Many-Relationship (15:03)
- 41-Jenis-Jenis-Join (9:10)
- 42-Subqueries (4:41)
- 43-Set-Operator (10:43)
- 44-Transaction (10:54)
- 45-Locking (14:19)
- 46-Schema (10:49)
- 47-User-Management (12:30)
- 48-Backup-Database (5:22)
- 49-Restore-Database (4:34)
- 50-Materi-Selanjutnya (2:02)