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.

-Understand the fundamentals of database design.
+Understand
-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 basic indexing strategies for query optimization.
+Apply
-Write time-based queries using date ranges.
+Apply
-Apply transactions and ensure data consistency with concurrency control.
+Apply

Voor bovenstaande leerdoelen gebruiken we de Taxonomie van Bloom

Fundamentals of PostgreSQL Database Design
- Principles, pros and cons of database normalization
- Entity-Relationship (ER) modeling
- Developer Experience (Connecting / 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
- Querying JSON data using PostgreSQL JSON functions and operators
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
Basic Indexing and Optimization
- Understanding different types of indexes
- Creating and managing indexes
Time-based Querying (Date Ranges)
- Working with date and time data types
- Querying date ranges and intervals
Transactions and Concurrency Control
- Understanding ACID properties
- Using transaction control commands (COMMIT, ROLLBACK)

Lees meer

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

"Ontzettend goede leraar."

Sander