Course Description
This intensive 5-day course is designed to provide database administrators, system administrators, and developers with the knowledge and skills necessary to administer PostgreSQL databases effectively. The course covers essential topics such as installation, configuration, performance tuning, backup and recovery, security, and high availability. Hands-on labs and real-world case studies are incorporated to reinforce learning and provide practical experience in managing PostgreSQL environments.
Durasi
5 Days
Course Objectives
By the end of this course, participants will be able to :
- Install and configure PostgreSQL on various operating systems.
- Understand the PostgreSQL architecture and processes.
- Manage databases, roles, and permissions.
- Monitor and optimize database performance.
- Implement robust backup and recovery strategies.
- Secure PostgreSQL databases.
- Set up replication and high availability solutions.
- Automate routine administrative tasks.
Course Audience
- Database Administrators.
- System Administrators.
- DevOps Engineers.
- Developers managing PostgreSQL environments.
- Anyone preparing for PostgreSQL DBA responsibilities.
Course Prerequisites
- Basic knowledge of SQL.
- Familiarity with Linux/Unix command line.
- General understanding of database concept.