- Learning Path Libraries: This path is only available in the libraries listed. To access this path, purchase a license for the corresponding library.
- Core Tech
PostgreSQL Administration
2 Labs
2 Hours
Skill IQ
This learning path is designed for a database administrator to transition their skills to the PostgreSQL ecosystem. You will progress from core operational maintenance to advanced topics in performance tuning, security, high availability, and scalability. Upon completion, you will be equipped to manage, secure, and scale a PostgreSQL server in a production environment.
Content in this path
PostgreSQL Administration
PostgreSQL Administration path is designed for experienced database administrators to transition their core operational skills to the PostgreSQL ecosystem.
Try this learning path for free
Access this learning path and other
top-rated tech content with a free
trial.
What You'll Learn
- ###What you will learn:
- Successfully install, configure, and manage a PostgreSQL server in a production environment.
- Design and execute a robust backup and recovery strategy, including Point-in-Time Recovery (PITR).
- Diagnose and resolve performance bottlenecks through both hardware and software tuning.
- Harden a PostgreSQL server against common security threats and apply best practices.
- Implement a high-availability solution using native replication and third-party cluster management tools.
- Apply advanced scaling techniques to handle growing data and user workloads.
Prerequisites
- ###The learner will need experience with:
- Writing queries, including data extraction, joins, and aggregations.
- Understanding data structures and table relationships.
- Knowledge of relational database principles and familiarity with concepts like schemas, tables, indexes, and views.
- Comfort with command-line interfaces, including the ability to navigate file systems and execute commands in a Linux/UNIX environment.
- Basic experience with Linux/UNIX and Windows, including knowledge of file systems and user account management.
Related topics
- Database Administration
- Relational Databases
- System Administration
- PostgreSQL
Not sure where to start?
With over 500 assessments to choose from, you can see where your skills
stand and receive adaptive learning recommendations to fill knowledge gaps in as little as 10 minutes.