Get in Touch
 Duration 14 hours

Course Outline

Introduction to PostgreSQL

  • A concise history of PostgreSQL
  • Key features
  • Overview of internal architecture
  • Limits and terminology

Installation and Configuration

  • Prerequisites
  • Installing from packages and initial database creation
  • Installation from source code
  • Setting up clients
  • Managing the database server (start and stop)
  • Configuring the environment

The SQL Language

  • SQL syntax
  • Data definition
  • Data manipulation
  • Querying data
  • Data types
  • JSON support
  • Functions and operators
  • Type conversion
  • Indexing

Transactions and Concurrency

  • Transactions and isolation levels
  • Multi-Version Concurrency Control (MVCC)

Client Interfaces

  • Command Line Interface - psql
  • Graphical Interface - pgadmin4

Server Programming

  • Extending SQL capabilities
  • Triggers
  • The Rule System
  • Procedural Languages
  • PL/pgSQL - SQL Procedural Language
  • Error handling mechanisms
  • Using cursors

Foreign Data Wrappers

  • Extensions in PostgreSQL
  • Adding a Foreign Data Wrapper to a database
  • postgres_fdw
  • file_fdw
  • Other available FDWs

SQL Tuning

  • Logging within PostgreSQL
  • Analyzing query plans
  • Optimizing queries
  • Managing statistics
  • Planner parameters
  • Parallel query scans
  • SQL best practices
  • Index optimization
  • Table partitioning

Requirements

A practical understanding of SQL

Custom Corporate Training

Training solutions designed exclusively for businesses.

  • Customised Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
  • Flexible Schedule: Dates and times adapted to your team's agenda.
  • Format: Online (live), In-company (at your offices), or Hybrid.
Investment

Price per private group, online live training, starting from £3200 + VAT*

Contact us for an exact quote and to hear our latest promotions

Testimonials (7)

Provisional Upcoming Courses (Contact Us For More Information)

Related Categories