PostgreSQL DBA Hands-on Training & Certification

Course Outline :-

DAY 1 :

• Introduction
• System Architecture
• Installation and Database Clusters
• Creating and Managing Databases
• Configuration
• Tablespaces

DAY TWO:

• Security
• Monitoring
• User Tools - CUI and GUI
• Backup, Recovery and PITR
• Streaming Replication

DAY THREE:

• Routine Maintenance Tasks
• Performance Tuning
• Loading and Moving Data
• Data Dictionary
• Table Partitioning
• Upgrading Best Practices

DAY FOUR:

• Connection Pooling using PGPOOL
• Implementing Failback with Streaming Replication
• Setting up BART
• Many more advance topics
• Certification Exam prep

Prerequisite knowledge

This course requires students to have an understanding of Linux fundamentals as well as SQL.

To visit and register https://certfirst.com/Courses/?id=146 OR CALL: 630-684-0355 | Email: Training@CertFirst.com

Posted by CertFirst (training@certfirst.com).

Note: The PostgreSQL Global Development Group does not endorse any events run by third parties. No guarantee of the quality of events is offered whatsoever.