PostgreSQL for Developers
Duration: 2 days | Price: € 599.00 VAT excluded
20% discount for multiple people from the same company
Next course on 26 - 27 January 2026
Prerequisites:
Basic knowledge of SQL
Use of services and command-prompt in Windows
The examples presented during the course will be executed on a Windows 10 machine. The learner must be equipped with a Windows 10 laptop or a version of Ubuntu Linux.
Description
PostgreSQL is an advanced, enterprise-class, fully open-source ORDBMS (Object-Relational Database Management System). It is a relational database that supports both SQL (relational) queries and JSON (non-relational) queries.
PostgreSQL is the most advanced open-source database in the world! It supports numerous features including Multi-Version Concurrency Control (MVCC), point-in-time recovery, granular access controls, tablespaces, asynchronous replication, nested transactions, online/hot backups, a refined query optimizer and planner, and write-ahead logging. PostgreSQL is highly scalable both in terms of the amount of data it can manage and the number of concurrent users it can serve.
Contents
Introduction
Installation
Architectural Fundamentals
Creating and Accessing Databases with psql
The (Amazing) Level of SQL Support
Creating Tables and Populating Them with Data
Executing Simple Queries on Tables
Executing Joins Between Tables
Aggregation Functions
Advanced Features
Views
Foreign Keys
Transactions
Window Functions
Inheritance Between Tables
Defining the Data Model
Default Values
Auto-generated Columns
Constraints
System Columns
Modifying Table Structure
Privileges
Row-level Security Policies
Schemas
Inheritance
Table Partitioning
Data from External Sources
Dependency Tracking
Data Manipulation
Adding Data
Updating Data
Deleting Data
Returning Data from Modified Rows
Queries
Table Expressions
Select Lists
Ways to Combine 2 or More Queries
Ordering Rows
LIMIT and OFFSET
VALUES Lists
WITH Query with CTE (Common Table Expressions)
Recursive Queries with CTE
Main Data Types
Numeric, Monetary, Character
Binary
Date/Time
Boolean
Enumerated
Geometric
Bit String
Text Search
UUID Type
JSON Types
Arrays
Composite Types
Range Types
OID Types
Functions and Operators
Logical Operators
Pattern Matching Operators
Functions for Output Data Formatting
Functions for Date/Time Management
Geometric Functions and Operators
Full-Text Search Functions
Functions for Unique Identifiers
Functions and Operators for JSON
Functions for Sequence Management
Aggregation Functions
Window Functions
System Information Functions
System Administration Functions
Functions for Trigger Creation
Statistical Functions
Indexes
Index Types
Multi-column Indexes
Indexes and ORDER BY
Combining Multiple Indexes
Expression Indexes
Partial Indexes
Index-Only Scans and Covering Indexes
How an Index is Used
Concurrency Control
Transaction Isolation
Explicit Locking
Locking and Indexes
Introduction to Execution Plans
Using and Understanding EXPLAIN
Statistics Used by the Planner
Parallel Queries
How Parallel Queries Work
When to Use Parallel Queries
Client Authentication
The pg_hba.conf File
Authentication Types