Introduction to PostgreSQL
- A Brief History of PostgreSQL
- Internals Summary
- Limits and Terminology
Installation and Configuration
- 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
- Data Types
- Functions and Operators
- Type Conversion
Transactions and Concurrency
- Transactions and Isolation
- Multi-Version Concurrency Control
- Command Line Interface - psql
- Graphical Interface - pgadmin4
- Extending SQL
- The Rule System
- Procedural Languages
- PL/pgSQL - SQL Procedural Language
- Error Handling
Foreign Data Wrappers
- Extension in PostgreSQL
- Adding FDW in a Database
- Other FDWs
- Logging in PostgreSQL
- Query Plans
- Optimizing Queries
- Planner Parameters
- Parallel Query Scans
- SQL Best Practices
- Table Partitioning
A working knowledge of SQL
I liked the trainer Michal a lot - he had a good clear voice - which made it easier to understand the complicated subject matter.
The thing I liked most was the audience engagement, getting the participants to work through the examples whilst everyone else follows along.
Learning new things that I didn't know before
Nicholas Johnson - Services Australia
Michal was really helpful when people had problems and no one was left behind in the exercises.
Elvin Kennedy - Services Australia
Learning new topics
There was no one thing that stood out, it was all pretty good. The occasional non-English word appearing in the slides - I assume that the original was in Polish - I found amusing.
Training was well paced, engaging, and informative.
Matthew Sohar - Services Australia
Optimizing queries and foreign data wrapping.
Sebastian Khor - Services Australia
Well organized lectures and pacing was good.
Synetek Systems Pty Ltd
The pace was excellent. It seemed custom made for me ... loved it!