Course Outline
Introduction to PostgreSQL
- Historical Overview of PostgreSQL
- Core Capabilities and Features
- Architectural Summary
- Operational Constraints and Terminology
Deployment and Configuration
- System Requirements
- Installation via Package Managers and Database Initialization
- Installation from Source Code
- Client-Side Implementation
- Database Server Lifecycle Management
- Environment Configuration
SQL Language Fundamentals
- SQL Syntax Standards
- Data Definition Statements
- Data Manipulation Operations
- Query Formulation
- Data Type Specifications
- JSON Handling
- Functions and Operators
- Type Conversion Mechanisms
- Indexing Strategies
Transactions and Concurrency Management
- Transaction Integrity and Isolation Levels
- Multi-Version Concurrency Control (MVCC)
Client Interface Options
- Command Line Interface via psql
- Graphical Interface via pgAdmin4
Server-Side Programming
- Extending SQL Functionality
- Trigger Implementation
- The Rule System Framework
- Procedural Language Integration
- PL/pgSQL: SQL Procedural Language
- Error Management Protocols
- Cursor Utilization
Foreign Data Wrappers
- Extension Framework in PostgreSQL
- Integrating FDW into Databases
- postgres_fdw Implementation
- file_fdw Implementation
- Alternative FDW Solutions
SQL Performance Tuning
- Logging Mechanisms in PostgreSQL
- Analysis of Query Plans
- Query Optimization Techniques
- Statistical Data Usage
- Planner Parameter Configuration
- Parallel Query Scanning
- SQL Best Practices for Government Systems
- Index Optimization
- Table Partitioning Strategies
Requirements
Demonstrated 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.