Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
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
14 Hours
Delivery Options
Private Group Training
Our identity is rooted in delivering exactly what our clients need.
- Pre-course call with your trainer
- Customisation of the learning experience to achieve your goals -
- Bespoke outlines
- Practical hands-on exercises containing data / scenarios recognisable to the learners
- Training scheduled on a date of your choice
- Delivered online, onsite/classroom or hybrid by experts sharing real world experience
Private Group Prices RRP from €4560 online delivery, based on a group of 2 delegates, €1440 per additional delegate (excludes any certification / exam costs). We recommend a maximum group size of 12 for most learning events.
Contact us for an exact quote and to hear our latest promotions
Public Training
Please see our public courses
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.
