Developing Databases using PostgreSQL

Info Support B.V.

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

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…