- 12 Sections
- 76 Lessons
- 32 Hours
Expand all sectionsCollapse all sections
- A. Persiapan3
- 1. ADVANCED STATEMENTS11
- 2.11.1. Exploring the Select Statement
- 2.21.2. Using the Like Clause
- 2.31.3. Using Ilike
- 2.41.4. Using Distinct
- 2.51.5. Using Limit and Offset
- 2.61.6. Using Subqueries
- 2.71.7. Learning About Joins
- 2.81.8. Aggregate Functions
- 2.91.9. Learning the Returning clause for Insert
- 2.101.10. Exploring CTES
- 2.111.11. CTE in PostgreSQL Since Version 12
- 2. WINDOW FUNCTIONS3
- 3. QUERY TUNING, INDEXES, AND PERFORMANCE OPTIMIZATION6
- 4. LOGGING AND AUDITING3
- 5. BACKUP AND RESTORE4
- 6. PHYSICAL REPLICATION2
- 7. LOGICAL REPLICATION3
- 8. MONITORING AND DIAGNOSIS19
- 9.18.1. Cloud-Native Monitoring
- 9.28.2. Providing PostgreSQL Information to Monitoring Tools
- 9.38.3. Real-Time Viewing using pgAdmin
- 9.48.4. Monitoring the PostgreSQL Message Log
- 9.58.5. Checking Whether a User is Connected
- 9.68.6. Checking Whether a Computer is Connected
- 9.78.7. Repeatedly Executing a Query in psql
- 9.88.8. Checking which Queries are Running
- 9.98.9. Monitoring the Progress of Commands
- 9.108.10. Checking which Queries are Active or Blocked
- 9.118.11. Knowing who is Blocking a Query
- 9.128.12. Killing a Specific Session
- 9.138.13. Knowing Whether Anybody is Using a Specific Table
- 9.148.14. Knowing when a Table was Last Used
- 9.158.15. Monitoring I/O Statistics
- 9.168.16. Usage of Disk Space by Temporary Data
- 9.178.17. Understanding Why Queries Slow Down
- 9.188.18. Analyzing the Real-time Performance of Your Queries
- 9.198.19. Tracking Important Metrics Over Time
- 9. REGULAR MAINTENANCE10
- 10.19.1. Controlling Automatic Database Maintenance
- 10.29.2. Avoiding Auto-Freezing
- 10.39.3. Removing Issues that Cause Bloat
- 10.49.4. Actions for Heavy Users of Temporary Tables
- 10.59.5. Identifying and Fixing Bloated Tables and Indexes
- 10.69.6. Monitoring and Tuning a Vacuum
- 10.79.7. Maintaining Indexes
- 10.89.8. Finding Unused Indexes
- 10.99.9. Carefully Removing Unwanted Indexes
- 10.109.10. Planning Maintenance
- 10. PERFORMANCE AND CONCURRENCY12
- 11.110.1. Finding Slow SQL Statements
- 11.210.2. Finding Out What Makes SQL Slow
- 11.310.3. Reducing the Number of Rows Returned
- 11.410.4. Simplifying Complex SQL Queries
- 11.510.5. Speeding Up Queries without Rewriting Them
- 11.610.6. Discovering Why a Query is Not Using an Index
- 11.710.7. Forcing a Query to Use an Index
- 11.810.8. Using Parallel Query
- 11.910.9. Using Just-In-Time (JIT) Compilation
- 11.1010.10. Creating Time-Series Tables Using Partitioning
- 11.1110.11. Using Optimistic Locking to Avoid Long Lock Waits
- 11.1210.12. Reporting Performance Problems
- C. Penutupan dan Pengisian Kuesioner2
Post-test PostgreSQL Advanced
Prev