Database Administration
PostgreSQL DBA Training
Become a proficient administrator of the world’s most advanced open-source database.
Overview
PostgreSQL DBA
PostgreSQL is a powerful open-source relational database known for its robustness, scalability and extensive feature set. It manages structured data efficiently while providing strong reliability and data integrity.
Companies of every size choose PostgreSQL, on premises and in managed cloud services like Amazon RDS, Azure Database for PostgreSQL and Cloud SQL.
About the course
This course takes you from installation to production operations: configuration, monitoring, backup and recovery, performance tuning, replication and high availability.
Course at a glance
- Track: Database Administration
- Level: No experience needed
- Format: Live instructor-led, online or on-site
- Includes: Hands-on labs and real-world projects
Curriculum
What you’ll learn
01
PostgreSQL architecture and installation
02
Configuration and server management
03
Roles, privileges and security
04
Backup and point-in-time recovery
05
Query optimization and indexing
06
Streaming replication and high availability
07
Monitoring, vacuuming and maintenance
08
Upgrades and migrations
What you need
- No prior IT experience required
- We teach everything from scratch, starting with the basics of Linux, SQL and networking
- A computer with a reliable internet connection
- Commitment to practice between sessions
Who should take this course?
- Aspiring or current DBAs specializing in PostgreSQL
- Database professionals expanding into open source
- System administrators and developers working with PostgreSQL
- IT managers evaluating PostgreSQL
Skills you’ll gain
- PostgreSQL administration
- Query optimization
- Backup and recovery
- Replication and high availability
- Security and access control
- Monitoring and performance tuning
- Migrations and upgrades
Benefits
- Enhanced career prospects and earning potential
- Hands-on experience with real-world scenarios
- Preparation for industry-recognized certifications
- Improved job performance from day one
- A competitive advantage in the job market
- Ongoing support from experienced instructors
More Database Administration courses
No experience needed
Microsoft SQL Server DBA
Master the administration, querying and tuning of one of the world’s most widely used relational databases.
Prepares for: Microsoft Azure Database Administrator Associate (DP-300) foundations
No experience needed
Azure SQL DBA
Deploy, manage and scale SQL Server databases in the Microsoft Azure cloud.
Prepares for: Microsoft Azure Database Administrator Associate (DP-300)
No experience needed
Oracle DBA
Administer, secure and tune Oracle Database for mission-critical enterprise workloads.
Prepares for: Oracle Database Administration Certified Professional
No experience needed
MySQL DBA
Run fast, reliable MySQL databases for web applications and cloud platforms.
Start your journey
Questions about schedules, pricing or corporate packages? Get in touch.