Opleiding: Developing Databases using PostgreSQL

Learn how to develop your database with PostgreSQL

You will learn how to use PostgreSQL.
- 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]

- 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…