DB-202
PostgreSQL Programming
Cost: $400
Duration: 2
Day
s
Skill Level: Intermediate
Course Overview
Efficient database management and optimization are crucial for performance and scalability. Programming on the database level allows you to execute logic and data manipulation tasks closer to the data, reducing latency, improving performance, and enhancing data integrity. This course focuses on stored procedures, functions, triggers, and error handling, to empower you with the tools needed to tackle complex data challenges.
Learning Outcomes
- Understand PostgreSQL architecture and basic SQL commands.
- Execute complex queries and optimize database performance.
- Maintain, secure, and back up PostgreSQL databases.
Suitable For
Anyone interested in software development, data engineering, data analysis, or database administration will find this suitable.
Course Outline
Overview
- Why program on the database?
- Functions vs. Stored Procedures
Functions with SQL
- Function Basics
- Returning Values
- Parameters
- Parameter Modes
- Default Values
- Returning Composite Types
- Returning Multiple Rows
- Returning a Table
- Function as a Table Source
- Function Parameter Modes
- Function Based on Views
PL/pgSQL Language
- Overview & Structure
- Declaring & Initializing Variables
- Copying Data Types
- Assigning Variables from a Query
- Returning Query Results
- Control Structures
- Returning Values, Tables & Rows
- Error and Exception Handling
Stored Procedures
- Transactions
- Returning Values
Triggers
- Overview
- Creating
- Binding a Function
- Event Trigger
Cursors
- Overview
- Creating
- Opening
- Using
- Updating
- Closing
- PL/PGSQL Cursors
- Parametric Cursor via Function
EXCLUSIVE TRAINING FOR YOU COMPANY
AT YOUR PREFERRED SCHEDULE
Tailored to the needs of your organization, we also offer cadetship
programs which include a series of our standardized O&B Academy courses.
Get a quote