EDB Certified PostgreSQL Training

Certified Training

Ashnik brings EDB endorsed PostgreSQL training in South East Asia. Designed for DBAs, IT Professionals, and Application Developers – EnterpriseDB training courses are created and delivered by experienced PostgreSQL and Postgres Plus Advanced Server experts who will coachyou how to promptlymanage your database responsibilities. EnterpriseDB certification program sets the global standard for Postgres professionals, and is definitive proof of your Postgres skills. Employers trust EDB certifications as industry-acknowledgement of Postgres proficiency and the ability to perform effectively. Currently, these courses are available only in countries of South East Asia.

We offer 4 different EDB Certified PostgreSQL Training courses – choose the most relevant one, based on your expertise and need:

1. Comprehensive PostgreSQL Administration training

This is a comprehensive course that includes the basics of PostgreSQL Administration and some key advanced concepts. Taking up this training will help the learner prepare for day-to-day Administrative and Management tasks to be performed as a PostgreSQL DBA and slowly scale up to manage large and highly available databases, with ease and confidence. This 5-day PostgreSQL course is designed for people with experience in database administration but who are new to PostgreSQL.

If you are interested in learning, improving, developing your Postgres Skills, have a running Postgres project or if you look for alternatives to take up database systems, this would be your best bet for getting your team up to speed.

Course covers following topics in-depth (Duration – 5 days):

  • Introduction and Architectural Overview
  • PostgreSQL System Architecture
  • Installation
  • PPAS Installation
  • Database Clusters
  • Configuration
  • Creating and Managing Databases
  • User Tools: Command Line Interfaces
  • GUI Tools
  • Security
  • SQL Primer
  • Backup and Recovery & Point-in Time Recovery
  • Routine Maintenance
  • Data Dictionary
  • Moving Data
  • Transaction and Concurrency
  • Performance Tuning
  • Table Partitioning
  • High Availability and Replication
  • Extension Module

 

Recommended for: IT Professionals who want to administer and maintain PostgreSQL. No prior knowledge of PostgreSQL is required to attend this class.

Pre-requisites: Basic experience in database administration and understanding of Relational Database concepts will be helpful. Understanding of Linux environment and basic commands will help in better understanding of the hands-on lab sessions.

2. Foundations of Postgres Administration

This course includes essential details of PostgreSQL Administration enabling the learner to perform duties as a PostgreSQL DBA, and is a foundation for the Advanced and Performance courses that follows 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
  • System Architecture
  • Installation and Database Clusters
  • Configuration
  • Creating and Managing Databases
  • User Tools – Command Line Interface and Graphical User Interface
  • Security
  • SQL Primer
  • Backup, Recovery and PITR
  • Routine Maintenance Tasks
  • Data Dictionary
  • Loading and Moving Data

 

Recommended for: IT Professionals who want to administer and maintain PostgreSQL. No prior knowledge of PostgreSQL is required to attend this class.

Pre-requisites: Basic experience in database administration and understanding of Relational Database concepts will be helpful. Understanding of Linux environment and basic commands will help in better understanding of the hands-on lab sessions.

3. Advanced PostgreSQL Administration

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 ‘Foundations of Postgres Administration’ course prior to taking up Advanced Training.

Course covers following topics in depth (Duration – 2 days):

  • Introduction & Architecture
  • Transactions and Concurrency
  • Performance Tuning
  • Replication & Failover
  • Hot Standby
  • Table Partitioning
  • PGPool-II
  • Pgbouncer
  • Monitoring
  • Procedural Languages
  • Add on Utilities – Extension

 

Recommended for: IT Professionals who want to enhance their Postgres administration skills to the next level.

Pre-requisites: Participants need to be proficient in regular Postgres DBA functions. It is recommended to attend the Foundations of Postgres Administration training prior to this class. It is beneficial to complete the PostgreSQL Associate Certification prior to attending this training. Understanding of Linux environment and basic commands will help in better understanding of the hands-on lab sessions.

4. PostgreSQL For Developers and Architects

In this course, you will learn the Postgres Architecture, how to design and develop applications with Postgres, intricacies of JDBC and object relation mappers (ORMs) with Postgres, how to troubleshoot and tune Postgres queries and how to write backend server code in Java and PL/pgSQL.

Some of the course curriculum overlaps with ‘Foundations of Postgres Administration’. The course focuses on PostgreSQL Community Edition.

Course consists of following topics (Duration – 3 days):

  • PostgreSQL Introduction
  • Source Code and Installation
  • Transactions
  • PostgreSQL Connectors
  • PSQL
  • Creating and Managing Databases
  • pgAdmin III
  • SQL Primer
  • SQL Functions
  • Large Objects
  • Procedural Languages
  • SQL Tuning

 

Recommended for: Developers who want to develop applications that deliver content from PostgreSQL. This course will also teach you Postgres Source Code Installation on Linux platform.

Pre-requisites: Familiarity with programming languages and concepts of SQL. Familiarity with Linux platform and commands will be helpful in better understanding of lab sessions.

Enrol for our EDB Certified Training courses

Book a Seat