| Slogan | Learn how to develop your database with PostgreSQL |
|---|---|
| Description | You will learn how to use PostgreSQL. |
| Subjects | - 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 |
| Prior Knowledge | - Basic knowledge of SQL |
| Goal | Level |
|---|---|
| **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 |