This specialization provides an in-depth journey through PostgreSQL 17, covering core concepts, advanced SQL techniques, performance optimization, security, high availability, and more. The first course focuses on the foundational aspects of PostgreSQL 17, exploring its new features, transaction handling, and advanced SQL capabilities. In the second course, learners delve into performance tuning, query optimization, stored procedures, and secure database management practices. The third course builds on this foundation, focusing on high availability, backups, recovery, and troubleshooting, preparing learners to manage complex PostgreSQL installations. By the end of the specialization, you will be equipped to administer PostgreSQL databases at an advanced level, optimizing them for performance and ensuring they remain secure and available.
What you'll learn
understand core concepts of PostgreSQL 17
apply advanced SQL techniques
perform database performance optimization
implement security best practices
manage high availability setups
execute backups and recovery strategies
Course objectives
equip learners with advanced PostgreSQL administration skills
prepare learners to optimize databases for performance and security
enable effective management of complex PostgreSQL installations