Course Outline
Introduction to PostgreSQL
- A Brief History of PostgreSQL
- Features
- Internals Summary
- Limits and Terminology
Installation and Configuration
- Pre-requisites
- 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
- Queries
- Data Types
- JSON
- Functions and Operators
- Type Conversion
- Indexes
Transactions and Concurrency
- Transactions and Isolation
- Multi-Version Concurrency Control
Client Interfaces
- Command Line Interface - psql
- Graphical Interface - pgadmin4
Server Programming
- Extending SQL
- Triggers
- The Rule System
- Procedural Languages
- PL/pgSQL - SQL Procedural Language
- Error Handling
- Cursors
Foreign Data Wrappers
- Extension in PostgreSQL
- Adding FDW in a Database
- postgres_fdw
- file_fdw
- Other FDWs
SQL Tuning
- Logging in PostgreSQL
- Query Plans
- Optimizing Queries
- Statistics
- Planner Parameters
- Parallel Query Scans
- SQL Best Practices
- Indexes
- Table Partitioning
Requirements
A working knowledge of SQL
Testimonials (10)
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.
Ranil Kumar - Verizon Connect
Course - PostgreSQL for Developers
Very good classes with a lot of interaction and it has adapted very well to the public. In class there were various levels of knowledge and it has been entertaining for everyone.
Rubén - Verizon Connect
Course - PostgreSQL for Developers
Perfect explanations mixing theory and examples, by increasing the difficulty of the cases. Perfect pace with the required breaks. Perfect pronunciation (for non native English speaker is nice to have it). Polite, kind, respectful and other soft skills.
Javier Manresa - Verizon Connect
Course - PostgreSQL for Developers
The practical examples and exercises, the suggestion on best practices from the trainer.
Bruno - Verizon Connect
Course - PostgreSQL for Developers
Highly interactive training
Ajinish - Verizon Connect
Course - PostgreSQL for Developers
As mentioned, the practical exercises pertaining to programming.
david murphy - Verizon Connect
Course - PostgreSQL for Developers
The practical sessions & the various interactions with the trainer when explaining deeper aspects of the material.