Developing Databases using PostgreSQL

Info Support B.V.

Leer databases implementeren met PostgreSQL

Prijs

vanaf € 2.415

Niveau

Bachelor

Soort

Training

Thema

Automatisering en ICT, Internet en media

Meer informatie en aanmelden bij Info Support B.V.

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