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.
Learning Outcomes
By the end of this course, you will be able to apply both basic and advanced features of the PostgreSQL database and avoid its common pitfalls.
Course Outline
PostgreSQL Fundamentals
- Command Line Administration with 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
PostgreSQL Programming (2 days)
Overview
- Why program on the database?
- Functions vs. Stored Procedures
Functions with SQL
- Function Basics
- Returning Values
- Parameters (Parameter Modes and 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 and Structures
- Declaring and Initializing Variables
- Copying Data Types
- Assigning Variables from a Query
- Returning Query Results
- Control Structures
- Returning Values, Tables and 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
Skill Level
Beginner
Suitable For
Anyone who is new to SQL, needing to develop practical database skills relevant to the PostgreSQL platform.
Prerequisites
- SQL-101 — SQL Fundamentals
Duration
3.5
day
s
Related Topics
Enquire Now
Skill Level
Beginner
Suitable For
Anyone who is new to SQL, needing to develop practical database skills relevant to the PostgreSQL platform.
Duration
3.5
day
s
Related Topics
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.
Learning Outcomes
By the end of this course, you will be able to apply both basic and advanced features of the PostgreSQL database and avoid its common pitfalls.
Course Outline
PostgreSQL Fundamentals
- Command Line Administration with 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
PostgreSQL Programming (2 days)
Overview
- Why program on the database?
- Functions vs. Stored Procedures
Functions with SQL
- Function Basics
- Returning Values
- Parameters (Parameter Modes and 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 and Structures
- Declaring and Initializing Variables
- Copying Data Types
- Assigning Variables from a Query
- Returning Query Results
- Control Structures
- Returning Values, Tables and 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