Developing Databases using PostgreSQL

Info Support B.V.

Leer databases implementeren met PostgreSQL

Price

from €2,415

Level

Bachelor

Kind

Training

Subject

Automation and IT, Internet and media

More information and registration at Info Support B.V.

Description

Als database developer leer je een database inrichten met 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 (U…