Certificate Authentication

PostgreSQL Performance Tuning Certificate for Andrew Kerr

Add to LinkedIn

Certificate ID: 
738023
Authentication Code: 
4e0b1
Certified Person Name: 
Andrew Kerr
Trainer Name: 
Michał Kuna
Duration Days: 
2
Duration Hours: 
14
Course Name: 
PostgreSQL Performance Tuning
Course Date: 
28 September 2023 09:30 to 29 September 2023 16:30
Course Outline: 
  • Introduction
  • Query Tuning
    • Logging in PostgreSQL
    • Query Plans
    • Statistics
    • SQL Best Practices
    • Indexes
    • Table Partitioning
  • Performance Tuning
    • Operating System Best Practices
    • Server Parameter Tuning
    • Extension – pg_stat_statements
    • Demo and Labs
  • Benchmarking
    • Database Benchmarking
    • Pgbench
    • Reading the Results
    • Demo and Labs