Developing Databases using PostgreSQL

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