Course Content

Unit 1: 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

Unit 2: Debugging PHP Code

• PHP Error Handling
• PHP Debugging Tools
• Creating conditional debug code
• Suppressing Errors

Unit 3: 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

Unit 4: 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

Unit 5: 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