PostgreSQL for Developers - 3 days Online Classroom
1.950,00 EUR
- 3 days
Take your PostgreSQL skills beyond basic SQL and learn how to build high-performance, scalable database solutions for modern applications. This hands-on course is designed for developers who want to master advanced PostgreSQL features, including PL/pgSQL programming, functions, procedures, triggers, transactions, concurrency control, and query optimization.
Key Features
Language
Course material in English
Level
Intermediate level
3 days (8 hours/day) online instructor-led
40+ recommended study hours
Labs and exercises based on real-world tasks
Tips on writing high-performance SQL
Digital resources for continued learning
Training in PL/pgSQL routines and error handling
Ask for date confirmation!
Program completion certification included
Learning Outcomes
At the end of this program, you will be able to:
Advanced Transaction Management
Learn how PostgreSQL maintains data consistency through transactions, concurrency control, locking mechanisms, and deadlock prevention.
PostgreSQL Logging and Monitoring
Configure and analyze PostgreSQL logs to troubleshoot issues, monitor performance, and identify security or query-related problems.
Managing PostgreSQL Extensions
Install, configure, and manage PostgreSQL extensions to enhance monitoring, indexing, and database functionality.
High-Performance Data Loading
Optimize bulk data imports using COPY, indexing strategies, and performance tuning techniques for large-scale data migrations
Course timeline
Day 1
Session 1: Advanced SQL Language
- Advanced PostgreSQL data types
- Data type conversion techniques
Session 2: Enhanced Grouping Features
- Advanced aggregation and grouping
- ROLLUP, CUBE, GROUPING, and GROUPING SETS
Session 3: Analytical Queries
- Ranking and window functions
- Analytic aggregates and data analysis techniques
- LAG, LEAD, FIRST_VALUE, and LAST_VALUE
Session 4: Recursive Queries
- WITH clause and Common Table Expressions (CTEs)
- Recursive query development
Session 5: Regular Expression Support
- Pattern matching and regular expressions
- Text search, validation, and transformation
Session 6: Server Programming Basics
- Introduction to PL/pgSQL programming
- Variables, data types, and control structures
- Using SQL statements within procedural code
Day 2
Session 7: Program Logic
- Conditional statements and decision-making
- Loops and flow control
- Nested and labeled loops
Session 8: Cursors
- Cursor concepts and operations
- Explicit, implicit, and parameterized cursors
- Fetching and processing result sets
Session 9: Exception Handling
- Error handling and diagnostics
- System and custom exceptions
- Exception management in PL/pgSQL
Session 10: User-Defined Functions
- Creating and managing functions
- Function parameters and execution
- Function administration
Session 11: User-Defined Procedures
- Creating and executing procedures
- Procedure parameters and security contexts
- Procedure management and maintenance
Day 3
Session 12: Triggers
- Creating and managing triggers
- BEFORE, AFTER, and INSTEAD OF triggers
- DML, DDL, and event-driven automation
Session 13: Transactions and Concurrency
- Transaction control and MVCC
- Isolation levels and locking
- Deadlocks, contention, and concurrency management
Session 14: SQL Tuning
- Query optimization and execution plans
- Scan and join strategies
- Statistics collection and performance tuning
- Table partitioning fundamentals
Session 15: Loading and Unloading Data
- Data import and export with COPY
- Bulk data loading and migration techniques
Who Should Enroll in this Program?
PostgreSQL Developers
Backend Developers
Full-Stack Developers
Software Engineers
Database Developers
Application Developers
Prerequisites
- Good working knowledge of SQL
- Previous experience using PostgreSQL databases
- Familiarity with database design and relational database concepts
- Experience writing queries, joins, and subqueries
- Knowledge equivalent to a PostgreSQL SQL fundamentals course is recommended
Statements
Licensing and accreditation
The course is offered according to Partner Program Agreement and complies with the License Agreement requirements.
Equity Policy
Candidates are encouraged to reach out to AVC for guidance and support throughout the accommodation process.
Frequently Asked Question
Need corporate solutions or LMS integration?
Didn't find the course or program which would work for your business? Need LMS integration? Write us, we will solve everything!