PostgreSQL for Developers Training Course

Course Code

postgresdev

Duration

14 hours (usually 2 days including breaks)

Requirements

A working knowledge of SQL

Overview

This course provides programmatic interaction with PostgreSQL databases. Learn techniques, syntaxes and structures needed to develop quality applications using PostgreSQL backend. This training also covers SQL Tuning covering best practices for writing efficient SQL.

Target audience includes developers who want to use or extend PostgreSQL, as well as database architects.

Course Outline

Introduction to PostgreSQL

  • A Brief History of PostgreSQL
  • Features
  • Internals Summary
  • Limits and Terminology

Installation and Configuration

  • Pre-requisites
  • Installation from Packages and Creating Database
  • Installation from Source Code
  • Client Installation
  • Starting and Stopping a Database Server
  • Environment Setup

The SQL Language

  • SQL Syntax
  • Data Definition
  • Data Manipulation
  • Queries
  • Data Types
  • JSON
  • Functions and Operators
  • Type Conversion
  • Indexes

Transactions and Concurrency

  • Transactions and Isolation
  • Multi-Version Concurrency Control

Client Interfaces

  • Command Line Interface - psql
  • Graphical Interface - pgadmin4

Server Programming

  • Extending SQL
  • Triggers
  • The Rule System
  • Procedural Languages
  • PL/pgSQL - SQL Procedural Language
  • Error Handling
  • Cursors

Foreign Data Wrappers

  • Extension in PostgreSQL
  • Adding FDW in a Database
  • postgres_fdw
  • file_fdw
  • Other FDWs

SQL Tuning

  • Logging in PostgreSQL
  • Query Plans
  • Optimizing Queries
  • Statistics
  • Planner Parameters
  • Parallel Query Scans
  • SQL Best Practices
  • Indexes
  • Table Partitioning

Testimonials

★★★★★
★★★★★

Related Categories

Related Courses

Course Discounts

Course Discounts Newsletter

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

Some of our clients

is growing fast!

We are looking to expand our presence in the US!

As a Business Development Manager you will:

  • expand business in the US
  • recruit local talent (sales, agents, trainers, consultants)
  • recruit local trainers and consultants

We offer:

  • Artificial Intelligence and Big Data systems to support your local operation
  • high-tech automation
  • continuously upgraded course catalogue and content
  • good fun in international team

If you are interested in running a high-tech, high-quality training and consulting business.

Apply now!

This site in other countries/regions