Courses by Category
Click on a category below to see a listing of courses.

This course is available for customized on-site delivery for groups of 3 or more students.
Contact us today at 877-258-8987 for more information or a quote.

Scroll down the page for a list of upcoming course dates in our public calendar.

PostgreSQL for Developers (3 days)

This PostgreSQL training course is ideal for those looking to migrate to PostgreSQL This PostgreSQL training course was designed for specifically for developers with SQL knowledge and experience and focuses on the features and functionality that are specific to PostgreSQL. Attendees will learn how to apply their SQL knowledge and experience to the PostgreSQL platform.

PostgreSQL for Developers Course Calendar (3 days)


Call for upcoming dates or on-site delivery.
¹ Includes airfare from anywhere in the continental United States and some parts of Canada as well as accommodation and shuttle services. ² Include course and course materials only. ³ Requires a broadband internet connection and microphone. Note that Virtual LIVE courses are led by an instructor, and as such start and end in local time (based on the course location), this my differ from your time zone. For government and education pricing, please contact us.

Recommended Pre-requisites

Students attending classes should have experience with SQL - including DDL, DML, and writing effective SQL queries before attending this PostgreSQL training class.

Course Outline/Agenda

Designed for developers looking to migrate to PostgreSQL, this training course does not cover SQL, the SQL language, DML, or DDL - these are pre-requisites.

This Postgresql course does cover the following topics:

Installing & managing PostgreSQL
Overview of PostgreSQL database
Using the psql client
Understanding PostgreSQL data types
- Numeric data types
  - Integer data types
  - Floating point types
  - Serial types
- Character types
- Binary data types
- Date & time values
- Boolean values
- Array types
- Other data types
Understanding sequences
Creating & managing indexes
- Understanding PostgreSQL indexes
- Partial indexes
- Indexes on expressions
Using COPY to load data
Working with Array Values
Advanced SQL Functions
- Using Common Table Expressions (CTE)
- Using Window Functions
- Using Regular Expressions
- Using Recursive Queries
Writing triggers & stored procedures with PL/pgSQL
- Variables in procedures
- Performing loop operations
- The PERFORM and EXECUTE statements
- Triggers in PostgreSQL
Using the PostgreSQL query optimizer
- Analyzing & optimizing queries
- Viewing execution plans with EXPLAIN
- Understanding PostgreSQL query operators
Improving query performance

Class Size

This class is limited to a maximum of 12 students.

On-Site Delivery

This course is available for on-site delivery for groups of 3 or more students.

OTG offers discounted training for on-site courses of more than 3 students - call us at 877-258-8987 (or submit the form on the upper right side of this page) for more information.

Course Details

This course is taught by one of our in-house PostgreSQL instructors, with over a decade of experiences with relation databases, and several database-related industry certifications. Our instructors have a thorough knowledge and understanding of PostgreSQL, along with practical experience. This allows them to pass on both their knowledge and experience in the classroom.

Instructional Materials

The following materials are used to deliver this course:

OTG Course Guide

View course guide table of contents
Requires Adobe Acrobat Reader

Enroll in this course

PostgreSQL Admin Training Logo

View upcoming course calendar

info@otg-nc.com
877-258-8987