DB-102

PostgreSQL Fundamentals

Cost: $400
Duration: 2
 Day
s
 Skill Level: Intermediate
Download PDF
Course Inquiry

How We Conduct Training :

Online :
Google Meet or Zoom
In-Person :

O&B Headquarters (3F Carlos J. Valdes Building, 108 Aguirre, Legazpi Village, Makati City)
Client's premises (Private sessions available with a minimum number of participants)

Course Overview

PostgreSQL is one of the few open source databases that are well-accepted in corporate environments. It is prized for its stability and performance.

However, most developers only use its basic features, not realizing its many features available for improving performance and reducing the complexity of applications.

This course allows the developer to maximize usage of the PostgreSQL database, as well as avoid common pitfalls. This training course was developed and is taught by some of the Philippines’ well-known and respected web developers, and uses the format trusted by some of the best companies in the Philippines.

Prerequisite Courses

DB-101 — Relational Databases and SQL

Learning Outcomes

  • Maximize utilization of unique and advanced features of PostgreSQL
  • Improve performance of PostgreSQL databases
  • Improve data integrity of PostgreSQL databases
  • Improve maintainability of PostgreSQL databases
  • Avoid common pitfalls in the use of PostgreSQL

Suitable For

Anyone with basic knowledge of SQL, needing to develop practical database skills relevant to the PostgreSQL platform.

Course Outline

Course Outline

PostgreSQL Administration and Advanced Usage

  • Command Line Administration w/ psql
  • GUI Administration with pgAdmin
  • Performance Monitoring with pg_top
  • Backup and Restore
  • Analyzing Performance of SQL Statements
  • Reclaiming Storage
  • Gathering Statistics
  • Basic Data Types, Operators and Functions
  • Arrays
  • Range Types
  • Enumerated Types
  • Test Search
  • XML
  • JSON

Procedural SQL and Automation

  • Writing and Using Functions
  • Introduction to PL/pgSQL
  • Creating and Managing Stored Procedures
  • Implementing Triggers and Cursors
  • Hands-on Exercises

Software and Hardware Requirements

Software

  • PostgreSQL version 18 or higher, including:
    • pgAdmin 4 (for GUI administration)
    • psql (for command-line operations)
Download PDF
Course Inquiry

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