PostgreSQL Training

Ashnik offers EnterpriseDB certified PostgreSQL courses designed for DBAs and application developers. These courses are delivered by certified PostgreSQL experts, enabling you to swiftly learn everything about managing your database responsibilities. Relevant material and labs provided by our training experts help you put your new skills into practice in your own work environment. The completion of this training entitles you to enroll for Postgres Certification exam by EnterpriseDB and become a certified Postgres Professional. In addition, each course entitles you to a Certificate of Participation from EnterpriseDB.

What’s more, all our training sessions include modularized lessons, lectures, presentation copies, discussions, Q & A sessions, and real hands-on lab exercises guided by a PostgreSQL expert.

PostgreSQL modules

A) Introduction to PostgreSQL Administration – This course includes essential details of PostgreSQL Administration enabling the learner to perform their duties as a PostgreSQL DBA, and is a foundation for the Advanced and Performance courses that follow in the DBA track. This course covers topics tested in the PostgreSQL Associate certification exam. It is recommended to have knowledge of Sql and Linux for effective learning.

Course consists of following topics (Duration – 3 days):
  • Introduction
  • PostgreSQL System Architecture
  • Installation
  • Configuration
  • Creating and Managing Databases
  • Introduction to PSQL
  • pg Admin III
  • Security basics
  • SQL
  • Backup and Recovery
  • Point-in Time Recovery
  • Routine Maintenance
  • Postgres Data Dictionary
  • Moving Data

B) Advanced PostgreSQL Training – This course prepares DBAs to manage large, highly available databases and their related security requirements with confidence. Requires participants to be proficient in regular Postgres DBA functions. It is highly recommended to undergo ‘Introduction to PostgreSQL Administration’ course prior to taking up Advanced training.

Course covers following topics in depth (Duration – 2 days):
  • PostgreSQL System Architecture
  • Transactions and Concurrency Transaction Definition
  • Performance Tuning
  • Table Partitioning
  • High Availability & Replication
  • Connection Pooling
  • Monitoring
  • Procedural Languages
  • Add on Utilities – Contrib

 

Training

  • Corporate Training Program

      • Focus more on topics which are of higher relevance to you.
      • Option to conduct the training at your location, making it a convenient choice.
      • Flexibility to add topics which are not a part of the packaged course e.g. SQL Tuning, Complex SQLs and Query Tips, Migration Tips etc.

  • Scheduled Training Program

      • Sessions do not exceed 12 seats per session.
      • Learn from real implementation experiences.
      • Network and share with other attendees in the sessions.
      • To know the scheduled classes, email us at success@ashnik.com

Learn more about: