course
Developing Databases using PostgreSQL
Learn how to develop your database with PostgreSQL
Not yet scheduled
- No location
-
Description
You will learn how to use PostgreSQL.
Learning Goals
 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 |
For the above learning goals we use Bloom's Taxonomy
Prior Knowledge
- Basic knowledge of SQL
Subjects
- 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)
Read more
Schedule
All courses can also be conducted within your organization as customized or incompany training.
Our training advisors are happy to help you provide personal advice or find Incompany training within your organization.
"Extremely good teacher"Sander
-
Hoge waardering
-
Praktijkgerichte trainingen
-
Gecertificeerde trainers
-
Eigen docenten