Postgresql Developer Training

PostgreSQL Developer Training Course

This PostgreSQL developer training course is ideal for those looking to migrate to PostgreSQL or use Postgresql in their applications. 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 developer training

Description Days Price(exc vat)
Postgres Developer Training Course 2 ZAR USD
R12,000 $950

Please contact us if you are looking to book a training sessions for Postgresql Dev Training.

  • *Includes lunch, tea and training material.
  • *Start time is 9:00am for 9:30am

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 functions with PL/pgSQL

  • 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 optimiser

    • Analyzing & optimizing queries

    • Viewing execution plans with EXPLAIN

    • Understanding PostgreSQL query operators

  • Improving query performance

  • Foreign Data Wrappers

Description Days Price(exc vat)
Postgres Developer Training Course 2 ZAR USD
R12,000 $950

Please contact us if you are looking to book a training sessions for Postgresql Developer Training.