Mastering PostgreSQL 17

Coursera MOOC / Non-credit USD 49
Enroll now →
Mastering PostgreSQL 17

About this course

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

Skills you'll gain

Related courses

Course details are provided by the platform and may change — always confirm on the provider's site. Links may be affiliate links.