Developing Databases using PostgreSQL

Leer databases implementeren met PostgreSQL

Nog niet ingepland

- Geen locatie

3 dagen

2415 (ex BTW)

Beschrijving

Als database developer leer je een database inrichten met PostgreSQL.

-Design a (transactional) database.
+Create
-Create tables with appropriate constraints and data types.
+Create
-Write efficient SQL queries for complex data retrieval.
+Apply
-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

Voor bovenstaande leerdoelen gebruiken we de Taxonomie van Bloom

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
Writing Efficient SQL Queries
- 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

Lees meer

Onze opleidingsadviseurs denken graag met je mee om een persoonlijk advies te geven of een incompany training binnen jouw organisatie te vinden.

"Zeer prettige docent, gaf op een eigen manier een zeer goede invulling aan de cursus. Was prettig om zo de cursus te volgen."

Marieke