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.

Prerequisites

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

Course duration

3 Days

Course outline

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