Developing Databases using PostgreSQL

Info Support B.V.

Learn how to develop your database with 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

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…