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

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