course
Developing Databases using PostgreSQL
Learn how to develop your database with PostgreSQL
Description
You will learn how to use PostgreSQL.
Learning Goals
 Design a (transactional) database. | Create  |
| Create tables with appropriate constraints and data types. | Create |
| Understand query execution plans. | Understand  |
| Create and manage views and materialized views. | Create |
| Develop stored procedures and functions to encapsulate logic. | Create |
| Implement triggers and event-driven programming. | Apply  |
| Use indexing strategies for query optimization. | Apply |
| Apply transactions | Apply |
| Apply concurrency control to ensure consistency and integrity. | Apply |
For the above learning goals we use Bloom's Taxonomy
Prior Knowledge
- Basic knowledge of SQL
Subjects
- Fundamentals of PostgreSQL Database Design
- Principles, pros and cons of database normalization
- Developer Experience (ORM)
- Tables, Constraints, and Data Types
- Creating and modifying tables
- Defining primary and foreign keys
- Working with complex data types: JSON and JSONB
- Understanding query execution plans
- Optimizing joins and subqueries
- Working with Views and Materialized Views
- Creating and using views
- Creating and refreshing materialized views
- Stored Procedures and Functions
- Writing and executing stored procedures
- Creating user-defined functions (UDFs)
- Writing stored procedures and functions to handle JSON data
- Triggers and Events
- Creating and managing triggers
- Best practices for trigger performance
- Indexing and Optimization
- Understanding different types of indexes
- Creating and managing indexes
- Transactions
- Understanding ACID properties
- Using transaction control commands (COMMIT, ROLLBACK)
- Concurrency Control
- Isolation levels
Read more
Schedule
| Start date | Duration | Location | |
|---|---|---|---|
July 20, 2026July 21, 2026July 22, 2026 | 3 days | Veenendaal / Remote This is a hybrid training and can be followed remotely. More information Veenendaal / Remote This is a hybrid training and can be followed remotely. More information Veenendaal / Remote This is a hybrid training and can be followed remotely. More information | Sign up |
All courses can also be conducted within your organization as customized or incompany training.
Our training advisors are happy to help you provide personal advice or find Incompany training within your organization.
Trainers
"Extremely good teacher"Sander
-
Hoge waardering
-
Praktijkgerichte trainingen
-
Gecertificeerde trainers
-
Eigen docenten