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 MySQL (5 days)

Designed for programmers looking to transition to using PHP, this advanced PHP training teaches students how to develop and deploy web applications using PHP and MySQL.

This advanced php course covers advanced topics, such as XML_RPC, and the ADODB database abstraction layer, and pays special attention to developing applications for security and portability.

Additional focus is placed on advanced features of MySQL, teaching students how to create efficient applications by implementing business logic within the database itself using Stored Procedures and Triggers, a feature introduced in MySQL 5.0.

Advanced PHP Programming with MySQL 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 advanced php course should have recent experience with either PHP or PERL (or some other scripting language) and knowledge of basic programming concepts.

A working knowledge of SQL is required for this course.

While this course includes a review of programming constructs and the basics of PHP, it is not intended as an "Introduction to Programming" course. Students should have a working knowledge of programming, and programming constructs (loops, conditionals, arrays, associative arrays, structures, etc.) prior to enrolling in this course.

Course Outline/Agenda

Below is a brief course outline for this advanced php training course, 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
    • PHP5 Objects
    • Class Inheritance
    • Autoloading Classes
    • Constructors and Destructors
    • Member and method visibility
    • The static keyword
    • Abstract Classes
    • Object Interfaces
    • Overloading
    • Class Members
  • Debugging PHP Code
    • PHP Error Handling
    • PHP Debugging Tools
      • Creating conditional debug code
    • Suppressing Errors
  • PHP Session Handling Features
    • Using PHP"s session handling features
    • Managing sessions across multiple servers
    • PHP Cookie handling
  • Handling Date & Time in PHP
  • Leveraging existing code with PEAR and PECL
  • Building client-server applications with XML_RPC
    • Client-Server programming models
    • Understanding XML-RPC
    • Creating an XML-RPC client
    • Sending XML-RPC messages and receiving responses
    • Creating an XML-RPC server
  • Installing and Managing MySQL (access control & overview)
    • Installing MySQL on the Windows platform
    • Installing MySQL on the Unix/Linux Platform
    • Starting and Stopping the MySQL server
    • Understanding MySQL Server security
      • MySQL Security
      • The MySQL Privilege System
      • MySQL default users
      • GRANT and REVOKE statements
      • Adding users to MySQL
      • Changing user passwords
      • Client access control
        • Disabling client access control
  • Understanding and using MySQL clients
    • Client overview
    • Using command-line clients
    • Using client option files
    • Using user variables
  • Implementing Stored Procedures and Triggers with MySQL
    • Understanding Stored Procedures
    • Creating Stored Procedures & Functions
    • Stored Procedure & Function characteristics
    • Execution blocks in Stored Procedures and functions
    • The DECLARE statement
    • Working with variables
    • MySQL Error codes
    • Conditions and handlers
      • Exit handlers
      • Continue handlers
      • Undo handlers
    • The IF statement
    • The CASE statement
    • The LOOP, WHILE, and REPEAT statements
    • Modifying Stored Procedures & Functions
    • Cursors in MySQL
    • Triggers in MySQL
    • Creating & using MySQL triggers
  • Using the MySQL Query Optimizer
    • Understanding MySQL Index types
    • MySQL Index usage
    • Using the MySQL Query Analyzer
    • Optimizing MySQL queries
    • Utilizing MySQL prepared statements
    • Using summary tables in MySQL
  • Accessing Databases using PHP and ADODB
    • Using the ADODB abstraction libraries
    • Reasons to use ADODB
    • Installing ADODB
    • Specifying Connection Properties
    • Constructing queries
    • Executing queries
    • Working with SELECT results
    • Handling ADODB errors
    • Improving ADODB performance
    • ADODB query debugging
    • ADODB single-step queries
  • PHP best practicies
  • 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

Students attending this advanced php training will develop an advanced network security application, that allows a central server to query remote systems (using XML_RPC) to retrieve information about files stored on those systems. It can then use a database to compare the structure of said systems with a reference system. Changes in the network cause triggers to fire, which in turn generate various logs.

This course is delivered using our Course Guide (see Table of Contents), a MySQL 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.

Our instructors are Zend PHP Certified Engineers, and MySQL Certified Professionals.

Instructional Materials
The following materials are used to deliver this course:
  • OTG Course Guide
Adobe PDF Logo View course guide table of contents
Requires Adobe Acrobat Reader

Enroll in this course

Activestate Logo

View upcoming course calendar