Designed for DBAs, Architects, Application Developers, and IT Professionals, our training courses are created and delivered by experienced PostgreSQL experts who will show you how to quickly manage your database responsibilities with ease.
We offer training in 2 convenient formats:
- Classroom – scheduled, open-enrolment public training batch at a specified city or location
- On-Site – delivered on-premise at your company location for your team
HANDS-ON EXPERIENCE
Relevant and up-to date material and labs enable you to quickly put your new skills into practice in your own environment. All training includes modularized lessons, lecture, presentation copy, and real hands-on lab exercises.
PostgreSQL Developer Fundamentals is a 2-day instructor-led training that gives you the essential skills for database development in PostgreSQL. Learn about PostgreSQL data types, database objects, indexes, transactions, and working with connectors and drivers, with basic installation.
- 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
- 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
- Rules and Triggers:
- How to define Rules
- Write Database Trigger Procedures
- Create Triggers in PostgreSQL
- Add Triggers on Views
- 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
- Background Worker Processes:
- What is Background Worker
- How to Setup Background Worker
- Examples of Pre-built Background Worker Processes
- 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
Developer Advanced Training covers advanced skills needed by PostgreSQL database developers in another 2-day 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 part in the PostgreSQL Developers Track and follows PostgreSQL Developer Fundamentals.
- Installation:
- Installation Options
- PostgreSQL Installation
- PostgreSQL Source Code
- Database Clusters
- Start and Stop Postgres
- PostgreSQL Introduction:
- Introduction to PostgreSQL
- Describe the sample tables used in the course
- pgAdmin III:
- PgAdmin3
- PEM Client
- Registering a server
- Viewing and Editing Data
- Query Tool
- Databases
- Languages
- Schemas
- 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
- 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
- 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
- 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
Training 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.
Delivery Approach
- Training includes lessons, hands-on labs and follow-up exercises to teach you how to use Postgres
- All attendees must attend this class in person. There is no remote access to the training
The above courses are to be attended together
Target Audience: For experienced Database Developers who are new to PostgreSQL and want to gain the essential skills required to effectively design and implement PostgreSQL databases for applications while incorporating PostgreSQL features.
Grab your seat! Fill the form to know course fees and details!
Other Training Courses
Virtual Training
Coming Soon
Designed for DBAs, Solution Architects, Application Developers, and IT Professionals; the Postgres Training Courses are…
Virtual Training
Coming Soon
Learn the essential details of PostgreSQL Administration including architecture, configuration, maintenance, monitoring, backup…
Virtual Training
Coming Soon
EDB PostgreSQL Advanced Server Database Administration – Essentials is a five-day course that focuses on teaching…
Virtual Training
Coming Soon
This training course takes the database administrator beyond the basics covered in the Essentials class. You will learn how to best…
Virtual Training
Coming Soon
This 2-day course covers the suite of EDB tools designed for large scale and mission critical enterprise performance, availability…