Software Engineering Done Right


3/F CJV Building
108 Aguirre Street, Legazpi Village,
Makati City, Philippines 1229

 
 

PostgreSQL Training

Duration: 1/2 day

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.

Audience:

Developers looking to understand and maximize the features of the PostgreSQL database, as well as avoid common pitfalls.

Prerequisites:

SQL Fundamentals

Coverage:

  • Overview
  • Using psql
  • Using pgAdmin
  • Creating & Restoring Databases
  • Analyzing Performance of SQL Statements
  • Basic Datatypes, Operators & Functions
  • Arrays
  • Range Types
  • Enumerated Types
  • Geometric Types
  • Text Search
  • XML
  • JSON
  • Reclaiming Storage
  • Gathering Statistics

Why choose O&B University

Our real-world experiences are applied to our training programs.

Corporate Training

We offer corporate or group training for organizations. Sessions can be done at a venue of your choice or at the O&B University training center.