PostgreSQL Database Administrator
At DataFocus, our PostgreSQL Database Administrator course is designed to provide comprehensive, hands-on training to help you master PostgreSQL database management. Whether you’re a beginner or an experienced professional, this course will equip you with the skills necessary to manage, optimize, and secure PostgreSQL databases effectively.
Course Content
Introduction to PostgreSQL
Overview of PostgreSQL Database
Installing and Configuring PostgreSQL
PostgreSQL Architecture and Components
Database Design and Management
- Database Schema Design
Tables, Indexes, and Constraints
Data Types and Functions
SQL and Query Optimization
- Writing and Optimizing SQL Queries
- Query Execution Plans
- Performance Tuning
Backup and Recovery
- Backup Strategies and Methods
- Point-in-time Recovery
- Using pg_dump, pg_restore, and WAL
User and Security Management
- Creating and Managing Roles and Permissions
- Data Encryption and Auditing
- Secure Database Access
Monitoring and Maintenance
- PostgreSQL Logging and Monitoring
- Automating Routine Maintenance Tasks
- Troubleshooting and Performance Monitoring
Replication and High Availability
- Setting up Replication (Streaming Replication, Logical Replication)
- Failover and High Availability Solutions
- Clustering and Load Balancing
PostgreSQL Advanced Topics
- Partitioning and Sharding
- Full-Text Search and JSONB
- Extensions (e.g., PostGIS, pg_partman)