Course Outline
Introduction to PostgreSQL
- An Overview of PostgreSQL's History
- Key Features
- Summary of Internal Mechanics
- System Limits and Technical Terminology
Installation and Configuration
- Prerequisites
- Installing via Packages and Database Creation
- Compiling from Source Code
- Setting Up Client Tools
- Managing Database Server Startup and Shutdown
- Configuring the Development Environment
The SQL Language
- SQL Syntax Guidelines
- Data Definition Concepts
- Data Manipulation Techniques
- Constructing Queries
- Handling Data Types
- Working with JSON
- Utilizing Functions and Operators
- Performing Type Conversions
- Creating and Using Indexes
Transactions and Concurrency
- Managing Transactions and Isolation Levels
- Understanding Multi-Version Concurrency Control
Client Interfaces
- Command Line Interface - psql
- Graphical User Interface - pgadmin4
Server Programming
- Extending SQL Capabilities
- Implementing Triggers
- Working with the Rule System
- Using Procedural Languages
- PL/pgSQL - The SQL Procedural Language
- Error Handling Strategies
- Managing Cursors
Foreign Data Wrappers
- Extending PostgreSQL
- Integrating FDWs into a Database
- Utilizing postgres_fdw
- Working with file_fdw
- Exploring Other FDW Options
SQL Tuning
- Implementing Logging in PostgreSQL
- Analyzing Query Plans
- Optimizing Query Performance
- Leveraging Statistics
- Adjusting Planner Parameters
- Executing Parallel Query Scans
- Adhering to SQL Best Practices
- Optimizing Indexes
- Implementing Table Partitioning
Requirements
Functional proficiency in 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.
