Developing Databases using PostgreSQL

Leer databases implementeren met PostgreSQL

Beschrijving

Als database developer leer je een database inrichten met PostgreSQL.

Leerdoelen

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

Onderwerpen

• 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 and functions to handle JSON data
• Triggers and Events
  • Creating and managing triggers
  • Best practices for trigger performance
• Indexing and Optimization
  • Understanding different types of indexes
  • Creating and managing indexes
• Transactions
  • Understanding ACID properties
  • Using transaction control commands (COMMIT, ROLLBACK)
• Concurrency Control
  • Isolation levels