14 hours (usually 2 days including breaks)
A working knowledge of SQL
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.
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
The training being interactive.
Michol did a really good job! he was engaging. He kept up with the pace of the class instead of the class needing to keep up with the instructor. he assisted and kept it at a level where everyone could understand even from various knowledge backgrounds
The pace was excellent. It seemed custom made for me ... loved it!
Varnie Karmo - Indiana Legislative Services Agency
great knowledge from the presenter
ANIXE Polska sp. z o.o.
Detailed knowledge and customer approach
Wojciech Polak - ANIXE Polska sp. z o.o.
ANIXE Polska sp. z o.o.
The in depth explaination of mechanisms working inside of psql instance and humour.
Łukasz Biel - ANIXE Polska sp. z o.o.
deep explanation about mechanisms how actually postgres is working underneath, experiments on database
Paweł Rynowiecki - ANIXE Polska sp. z o.o.
The openness, the way of the presentation
Marcin Szewczyk - ANIXE Polska sp. z o.o.
Well organized lectures and pacing was good.
Synetek Systems Pty Ltd
Basically all of it. The trainer has done a great job on his delivery of the course material. He came ready to teach and was able to answer all questions with clarity. Additionally, the in-class exercises furthered our understanding of PostgreSQL architecture, features, and commands.