- 18 Sections
- 89 Lessons
- 32 Hours
Expand all sectionsCollapse all sections
- Persiapan2
- 1. INTRODUCTION AND ARCHITECTURAL OVERVIEW6
- 2. SYSTEM ARCHITECTURE3
- 3. POSTGRESQL INSTALLATION5
- 4. USER TOOLS - COMMAND LINE INTERFACES5
- 5. DATABASE CLUSTERS4
- 6. CONFIGURATION6
- 7. DATA DICTIONARY3
- 8. CREATING AND MANAGING DATABASES7
- 9. DATABASE SECURITY6
- 10. MONITORING AND ADMIN TOOLS6
- 11. SQL PRIMER12
- 13.111.1 Data Types
- 13.211.2 Structured Query Language
- 13.311.3 DDL, DML and DCL Statements
- 13.411.4 Transaction Control Statements
- 13.511.5 Tables and Constraints
- 13.611.6 Views and Materialized Views
- 13.711.7 Sequences
- 13.811.8 Domains
- 13.911.9 SQL Joins and Functions
- 13.1011.10 Explain Plans
- 13.1111.11 Quoting in PostgreSQL
- 13.1211.12 Indexes
- 12. BACKUP, RECOVERY AND PITR9
- 13. ROUTINE MAINTENANCE TASKS5
- 14. MOVING DATA USING COPY COMMAND4
- 15. POSTGRESQL INSTALLATION6
- Latihan Ujian6
- Penutupan2
Post Test
Prev