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 5 different EDB Certified PostgreSQL Training courses – choose the most relevant one, based on your expertise and need:

1. PostgreSQL Developer Fundamentals

Postgres Developer Fundamentals is a 2-day online instructor-led training that gives you the essential skills for database development in Postgres. Learn about Postgres data types, database objects, indexes, transactions, and working with connectors and drivers, with basic installation.

Target Audience: For experienced Database Developers who are new to Postgres and want to gain the essential skills required to effectively design and implement Postgres databases for applications while incorporating Postgres features.

PostgreSQL Introduction:

  • Introduction to PostgreSQL
  • Describe the sample tables used in the course

Installation:

  • Installation Options
  • Postgres Installation
  • PostgreSQL Source Code
  • Database Clusters
  • Start and Stop Postgres

pgAdmin III:

  • PgAdmin3
  • PEM Client
  • Registering a server
  • Viewing and Editing Data
  • Query Tool
  • Databases
  • Languages
  • Schemas
  • Database Objects
  • Maintenance
  • Tablespaces
  • Roles
  • Command Line Tool: PSQL
  • Command Line Tool: EDB*Plus

Transactions and Concurrency:

  • Transaction Definition
  • Effects of Concurrency on Transactions
  • Transaction Isolation Levels
  • Sharing Data Snapshots
  • Locking Modes
  • Multi-Version Concurrency Control Overview (MVCC)
  • Internal Identifiers

PostgreSQL Connectors and Extensions:

  • JDBC
  • Installing JDBC Connectors
  • Connecting Java Applications to PostgreSQL
  • .NET Connectors
  • Extensions

Database Design:

  • Object Hierarchy
  • Creating Databases
  • Users
  • Access Control
  • Creating Schemas
  • Schema Search Path

Data Types:

  • Numeric Types
  • Character Types
  • Date and Time
  • Arrays
  • JSON and JSONB
  • Other Data Types

SQL Primer:

  • Tables
  • Constraints
  • Table Inheritance
  • Viewing Data Using SELECT
  • SQL Queries: DML
  • Quoting in PostgreSQL

Other Database Objects:

  • Views
  • Materialized Views
  • Sequences
  • Domains

Indexes:

  • Types of Indexes
  • Creating an Index
  • Index on Expression
  • Unique Indexes
  • Partial Indexes
  • Removing Indexes
  • Viewing Index Usage
  • Re-indexing

SQL Functions:

  • Operators
  • String Functions
  • Date Functions
  • Numeric Function
  • JSON Functions
  • XML Functions
  • Aggregate Functions
  • Data Type Conversion

Large Objects:

  • Data Types for large data
  • Adding lo extenstion
  • Using Java File Stream for inserting
  • image in postgres

Large Objects:

  • Introduction to PLPGSQL
  • PL/PGSQL
  • Creating Functions using PL/PGSQL

2. PostgreSQL Developer Advanced

Postgres Developer Advanced covers the advanced skills needed by Postgres database developers in a 2-day online instructor-led training. You will learn about using data adapters to interact with additional data sources, a multi-step plan for SQL tuning, and approaches for data security and localization. This is the second class in the Postgres Developers Track and follows Postgres Developer Fundamentals.

Target Audience: For experienced Database Developers who are working with Postgres and need to gain the advanced skills required to effectively design and implement Postgres databases for applications while incorporating Postgres features.

Procedural Languages

  • What is a Procedural Langauge
  • Introduction to PL/pgSQL
  • Working of PL/pgSQL
  • How to Create PL/pgSQL Functions
  • How to use Control Statements
  • How to Handle Exceptions in PL/pgSQL
  • Declaring and Using Cursors

Rules and Triggers

  • How to define Rules
  • Write Database Trigger Procedures
  • Create Triggers in PostgreSQL
  • Add Triggers on Views

SQL Tuning

  • Statement Processing
  • Common Query Performance Issues
  • SQL Tuning Goals
  • SQL Tuning Steps
    • ‒ Identify slow queries
    • ‒ Review the query execution plan
    • ‒ Optimizer statistics and behaviour
    • ‒ Restructure SQL statements
    • ‒ Indexes

Background Worker Processes

  • What is Background Worker
  • How to Setup Background Worker
  • Examples of Pre-built Background Worker Processes

Localization

  • PostgreSQL Locale Support
  • Working with different Locales
  • PostgreSQL Character Sets
  • Changing Server and Client Encoding

Foreign Data Wrappers

  • What are Postgres
  • Foreign Data Wrappers
  • How to Setup FDWs
  • Example – postgres_fdw
  • Example – file_fdw

Full Text Searching

  • What is Full-Text Search
  • How to store and query Full Text Search data in Postgres

Data Encryption

  • What is Database Security
  • PostgreSQL options for Eata Encryption and Security
  • What is Host Based Access Control
  • How to implement Row level Security
  • Introduction to pg_crypto Extension

Working with Geo Data: Postgis

  • What is PostGIS
  • Installation of PostGIS
  • Creation of spatial database
  • Load and retrieve data in a spatial database

3. 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.

4. 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.

5. 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.

Enroll for our EDB Certified Training courses

Book a Seat