PostgreSQL Administration

In PostgreSQL Administration - Essentials training course, delegates will learn the PostgreSQL architecture, configuration, maintenance, monitoring, backups, recovery, and moving data.

Beyond the regular maintenance and administration of PostgreSql databases, exist organizational needs for advanced solutions including replication to safe guard data, clustering for High Availability, partitioning for performance and maintainability, and security for privacy and protection. PostgreSQL Administration -Advanced training course covers these inter-related topics in detail.

The PostgreSql Administration - Advanced workshop prepares DBA's to manage large, highly available databases and their related security requirements with confidence.

For PostgreSQL Administration - Essentials: workshop, delegates should have some experience in database administration of any database. Knowledge of PostgreSQL is not required.

For PostgreSQL Administration -Advanced: delegates should be proficient in regular PostgreSql DBA functions.


PostgreSQL Administration - Essentials
(Duration : 4 Days)


Introduction to PostgreSQL Administration

  • Introduction
  • PostgreSQL System Architecture
  • Installation
  • Configuration
  • Creating and Managing Databases
  • Introduction to PSQL
  • pgAdmin III
  • Security basics
  • SQL
  • Backup and Recovery
  • Routine Maintenance
  • Postgres Data Dictionary
  • Moving Data

Advanced PostgreSQL Administration

  • PostgreSQL System Architecture
  • Transactions and Concurrency Transaction Definition
  • Performance Tuning
  • Table Partitioning
  • High Availability & Replication
  • Connection Pooling
  • Monitoring
  • Procedural Languages
  • Add on Utilities - Contrib
PostgreSQL Administration - Advanced
(Duration : 2 Days)


PostgreSQL System Architecture


Transactions and Concurrency Transaction Definition


Performance Tuning


Table Partitioning


High Availability & Replication




Procedural Languages


Add on Utilities - Contrib

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 4,000 Modules on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.