Courses by Category
Click on a category below to see a listing of courses.

This course is available for customized on-site delivery for groups of 3 or more students.
Contact us today at 877-258-8987 for more information or a quote.

Scroll down the page for a list of upcoming course dates in our public calendar.

Advanced PHP Programming with PostgreSQL & plPHP (5 days)

Designed for programmers looking to transition to using PHP, this course teaches students how to develop and deploy web applications using PHP and PostgreSQL.

This course covers advanced topics, such as XML_RPC, and PEAR MDB2, and pays special attention to developing applications for security and portability.

Additional focus is placed on advanced features of PostgreSQL, and teaches students how to create efficient applications by implementing business logic within the database itself using Stored Procedures and Triggers and plPHP.

This course covers cutting-edge topics related to PostgreSQL - such as developing and managing functions and triggers using the plPHP procedural programming language.

Advanced PHP Programming with PostgreSQL & plPHP Course Calendar (5 days)

Call for upcoming dates or on-site delivery.

1 Includes airfare from anywhere in the continental United States and some parts of Canada as well as accommodation and shuttle services.
2 Include course and course materials only.
3 Requires a broadband internet connection and microphone. Note that Virtual LIVE courses are led by an instructor, and as such start and end in local time (based on the course location), this my differ from your time zone.
For government and education pricing, please contact us.

Recommended Pre-requisites

Students taking this course should have programming experience (preferrably scripting) and knowledge of basic programming concepts.

An understanding of SQL is required for this course.

Note: This course moves at an advanced pace, and assumes an understanding of many basic programming concepts and constructs. Students without these pre-requisites may find that the course moves too rapidly for them.

Course Outline/Agenda

Below is a brief course outline, for a more detailed view of course contents, please view the Table of Contents from our Course Guide (link below)
  • PHP Fundamentals/Review
  • Object Oriented Programming and PHP 5
  • Debugging PHP Code
  • PHP Session Handling Features
  • Handling Date & Time in PHP
  • Leveraging existing code with PEAR and PECL
  • Building clint-server applications with XML_RPC
  • Installing and Managing PostgreSQL
  • Implementing Stored Procedures and Triggers with PostgreSQL using plPHP
    • Compiling & Installing plPHP in the database
    • Understanding plPHP limitations and restrictions
    • Creating plPHP functions
      • Single result functions
      • Accepting Polymorphic arguments
      • Accepting and returning arrays in plPHP
      • plPHP Composite type arguments
      • Working with set-returning functions
    • Understanding plPHP's $_TD array
    • Understanding the plPHP environment
    • Creating & working with PHP functions in plPHP
    • Creating & managing plPHP Triggers
  • Using the PostgreSQL Query Optimizer
  • Accessing Databases using PHP, PEAR::MDB2
  • Appendicies - SQL Primer/Language Reference

Class Size

This class is limited to a maximum of 12 students.

On-Site Delivery

This course is available for on-site delivery for groups of 3 or more students.

OTG offers discounted training for on-site courses of more than 3 students - call us at 877-258-8987 (or submit the form on the upper right side of this page) for more information.

Course Details
This course is delivered using our Course Guide (see Table of Contents), a PostgreSQL Reference Guide, and a PHP function reference. The course is delivered by one of our Subject Matter Experts, with experience in a wide range of database engines, including years of DBA and PHP experience.
Adobe PDF Logo View course guide table of contents
Requires Adobe Acrobat Reader

Enroll in this course

Activestate Logo

PostgreSQL Admin Training Logo

View upcoming course calendar