Comprehensive PostgreSQL Administration

Classroom Training in Bangalore - attend training on site at a convenient location

About the course: This open enrollment class is intended for DBAs and IT Professionals who are responsible for administration and maintenance of PostgreSQL, and want to increase proficiency and learn best practices.

Comprehensive PostgreSQL Administration teaches the essential skills required by PostgreSQL DBAs to be successful. This course will present the PostgreSQL database architecture and core administrative tasks including configuration, maintenance, monitoring, backups, recovery, and moving data.

Advanced topics are also covered including: replication to safeguard data, clustering for high availability, partitioning for performance and maintainability, and security for privacy and protection.

Upon course completion, you will be prepared to manage large, highly available databases and their security requirements with confidence. 

Course Outline:

      Essentials

  • PostgreSQL System Architecture
  • Installation
  • Configuration
  • Creating and Managing Databases
  • Introduction to PSQL
  • pgAdmin III
  • Security Basics
  • SQL Primer
  • Backup and Recovery
  • Point-in Time Recovery
  • Routine Maintenance
  • Postgres Data Dictionary
  • Moving Data

      Advanced Topics

  • Transactions and Concurrency
  • Performance Tuning
  • Table Partitioning
  • High Availability & Replication
  • Monitoring
  • Extension Modules

 

 

 

 

 

 

Pre-requisites: Basic experience in database administration. No prior knowledge of PostgreSQL is required.

Certification: Includes one complimentary attempt at the PostgreSQL Associate Certification exam

Includes:

  • Hands-on lab exercises
  • Printed course materials
  • Food and beverages will also be provided

We encourage you to bring your laptop with the most current version of PostgreSQL installed

Location: 55A, Hosur Main Rd, Electronics City Phase 1, Electronics City, Bangalore, Karnataka​

Price: INR 38000 + tax (as applicable)

Special Group Discounts are Available for this class

Please contact us or call for discount information and to learn more!

Shopping cart

View your shopping cart.

On-Demand Training

Training Login Help

If you have registered for a training class which is scheduled for today and need urgent help with the login information, please use the contacts below and we will provide assistance as soon as possible.

Call Support at +1-732-331-1320 or

Email: training@enterprisedb.com 

Note: These contacts are for critical assistance only related to last minute login issues for any training class.