Course Outline
Introduction to PostgreSQL
- A concise history of PostgreSQL
- Key features
- Overview of internal architecture
- Limits and terminology
Installation and Configuration
- Prerequisites
- Installing from packages and initial database creation
- Installation from source code
- Setting up clients
- Managing the database server (start and stop)
- Configuring the environment
The SQL Language
- SQL syntax
- Data definition
- Data manipulation
- Querying data
- Data types
- JSON support
- Functions and operators
- Type conversion
- Indexing
Transactions and Concurrency
- Transactions and isolation levels
- Multi-Version Concurrency Control (MVCC)
Client Interfaces
- Command Line Interface - psql
- Graphical Interface - pgadmin4
Server Programming
- Extending SQL capabilities
- Triggers
- The Rule System
- Procedural Languages
- PL/pgSQL - SQL Procedural Language
- Error handling mechanisms
- Using cursors
Foreign Data Wrappers
- Extensions in PostgreSQL
- Adding a Foreign Data Wrapper to a database
- postgres_fdw
- file_fdw
- Other available FDWs
SQL Tuning
- Logging within PostgreSQL
- Analyzing query plans
- Optimizing queries
- Managing statistics
- Planner parameters
- Parallel query scans
- SQL best practices
- Index optimization
- Table partitioning
Requirements
A practical understanding of SQL
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customised Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from £3200 + VAT*
Contact us for an exact quote and to hear our latest promotions
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.