This course combines engaging instructor-led presentations and useful demonstrations with valuable hands-on labs and engaging group activities.   

Working in a hands-on learning environment led by our expert facilitator you will: 

• Gain expertise in managing and maintaining PostgreSQL server architecture, including optimizing performance parameters, memory and disk management, and implementing security best practices. 
• Build proficiency in creating, configuring, and securing user accounts by managing roles, privileges, and authentication methods tailored to an administrator's perspective. 
• Develop the ability to efficiently monitor database activity, identify performance bottlenecks, and analyze resource usage to ensure optimal database performance. 
• Acquire skills in routine database maintenance, such as index and table management, vacuuming and analyzing, and handling bloat, to keep the PostgreSQL environment healthy and efficient. 
• Master backup and restore procedures, including implementing physical and logical backups, point-in-time recovery, and developing disaster recovery plans to ensure data integrity and availability. 

If your team requires different topics, additional skills or a custom approach, our team can collaborate with you to further adjust the course to focus on your specific learning objectives and goals. 

The ideal audience for this course includes database administrators, system administrators, IT managers, and DevOps professionals who are responsible for managing and maintaining PostgreSQL database systems. The course is also suitable for individuals transitioning into these roles or seeking to deepen their understanding of PostgreSQL administration, ensuring they are equipped with the necessary skills and knowledge to excel in their careers. 

Please note that this list of topics is based on our standard course offering, evolved from typical industry uses and trends. We'll work with you to tune this course and level of coverage to target the skills you need most. Topics, agenda and labs are subject to change, and may adjust during live delivery based on audience skill level, interests and participation. 

Server Architecture 

• Understanding PostgreSQL layers 
• Process and memory model 
• Storage subsystem overview 
• Transaction and locking 

User Accounts 

• Creating user accounts 
• Managing roles and privileges 
• Authentication methods 
• Securing user access 

Server Startup and Shutdown 

• PostgreSQL startup process 
• Graceful shutdown techniques 
• Crash recovery mechanisms 
• Identifying common issues 

Server Configuration 

• Essential configuration files 
• Tuning performance parameters 
• Memory and disk management 
• Security best practices 

Connections and Authorization 

• Connection types and methods 
• Managing connection limits 
• Role-based access control 
• Implementing SSL/TLS 

Database Reporting 

• Query performance analysis 
• Identifying slow queries 
• Using EXPLAIN and ANALYZE 
• Index usage statistics 

Logs 

• Configuring log output 
• Analyzing log data 
• Log rotation and retention 
• Troubleshooting common errors  

Statistics 

• PostgreSQL statistics collector 
• Interpreting statistics views 
• Monitoring performance metrics 
• Detecting anomalies 

Managing Databases 

• Creating and dropping databases 
• Managing tablespaces 
• Schema management 
• Handling large objects 

Routine Database Maintenance 

• Index and table maintenance 
• Vacuuming and analyzing 
• Managing dead rows 
• Handling bloat 

Backup and Restore 

• Physical and logical backups 
• Point-in-time recovery 
• Backup strategies 
• Disaster recovery planning  

Monitoring Database Activity 

• Active session monitoring 
• Lock contention analysis 
• Identifying long-running queries 
• Resource usage tracking 

Monitoring Disk Usage 

• Disk space allocation 
• Table and index sizing 
• Identifying disk bottlenecks 
• Capacity planning 

Information Schema 

• Navigating information schema 
• Querying metadata 
• Understanding system catalogs 
• Exploring object dependencies 

Wrap Up & Additional Resources 

• Recap of key concepts 
• PostgreSQL community resources 
• Advanced topics exploration 
• Continuous practice and learning opportunities