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.
spacer
2 Include course and course materials only.
spacer
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.
spacer
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

PostgreSQL Admin Training Logo

Activestate Logo

View upcoming course calendar

Information Request
Complete the form below to have one of our enrollment specialists contact you.










(Upon submission this page will reload)

info@otg-nc.com
877-258-8987



PHP Logo PostgreSQL Logo SUSE Logo Debian Logo Novell Logo Django Logo
Python Logo GForge Logo MediaWiki Logo MapServer Logo PostGIS Logo

Site Map | LAMP Training | Linux Fundamentals | Linux Training | Learn MySQL Administration | MySQL Courses & MySQL Classes | MySQL Tuning & MySQL Training | Novell CLP & Novell Training | Novell Linux Training & Novell Classes | Open Source Training & OES Linux | PHP Instruction & PHP Courses | PHP Training & PHP MySQL Training | PostgreSQL | Open Source GIS | GForge CDE | MediaWiki | PostgreSQL Training & PostGIS Training | SLES Classes For SUSE Linux Administration | SUSE Training & SUSE Linux Fundamentals | Zend PHP | Advanced PHP | AJAX Training | Bash Training | GroupWise Training | Python Training