Course Outline
PostgreSQL Introduction
- Brief History of PostgreSQL
- Key Features
- Overview of Internals
- Limits and Terminology
Setup and Configuration
- Prerequisites
- Package-based Installation and Database Creation
- Installing from Source Code
- Client Setup
- Starting and Stopping the Database Server
- Configuring the Environment
SQL Language Fundamentals
- SQL Syntax
- Data Definition
- Data Manipulation
- Executing Queries
- Data Types
- JSON
- Functions and Operators
- Type Conversion
- Indexing
Transactions and Concurrency
- Transactions and Isolation Levels
- Multi-Version Concurrency Control
Client Interfaces
- Command Line Interface (psql)
- Graphical Interface (pgadmin4)
Server-Side Programming
- Extending SQL
- Triggers
- The Rule System
- Procedural Languages
- PL/pgSQL - SQL Procedural Language
- Managing Errors
- Using Cursors
Foreign Data Wrappers
- PostgreSQL Extensions
- Implementing FDWs in a Database
- postgres_fdw
- file_fdw
- Additional FDWs
SQL Performance Tuning
- Logging in PostgreSQL
- Analyzing Query Plans
- Query Optimization
- Statistics Management
- Planner Parameters
- Parallel Query Scans
- SQL Best Practices
- Indexing Strategies
- Table Partitioning
Requirements
Practical familiarity with SQL
Testimonials (7)
He was amazing at adapting the training session to our needs.
Anatoliy - Samsung Cambridge Solution Centre Ltd
Course - PostgreSQL for Developers
the training material
Ashwin - Samsung Cambridge Solution Centre Ltd
Course - PostgreSQL for Developers
Trainer Michał. He is well prepared. His knowledge is very wide and his way of teaching is also great.
Ireneusz - Inter Cars S.A.
Course - PostgreSQL for Developers
I liked the exercises
Luis - Verizon Connect
Course - PostgreSQL for Developers
I thoroughly enjoyed the training. He remained patient with all of the questions, making hands on learning incredibly enjoyable. I'd be thrilled to take another class with him.
Birdesha - Verizon Connect
Course - PostgreSQL for Developers
Covered a large amount of content, in a clear and concise manner.
Dan Bowyer - Verizon Connect
Course - PostgreSQL for Developers
The training was absolutely fantastic, thanks to Michal's exceptional expertise and engaging teaching style. His in-depth knowledge on PostgreSQL was evident throughout the sessions and was able to share many complex concepts in a clear and simple manner. He was well prepared and there was good balance between theory and practical demonstrations. I look forward to applying the knowledge gained from these sessions and thanks again Michal for an exceptional training experience.
