PHP & MySQL (Advanced)
Our PHP and MySQL Advanced course is designed to teach you how to develop and deploy web applications using these powerful technologies. With a focus on Object Oriented Programming and advanced features of MySQL, you'll learn how to create efficient applications by implementing business logic within the database itself. Whether you prefer public class training in Kuala Lumpur or In-House training at your own venue throughout Malaysia, we've got you covered.
per person
Level
Duration
Training Delivery Format
Face-to-face / Virtual Class
per person
Level
Duration
Training Delivery Format
Face-to-face (F2F) / Virtual Class
Class types
Public Class
Private Class
In-House Training
Bespoke
About this course
This PHP and MySQL advanced course is for programmers who are looking to transition to using PHP. This PHP & MySQL training teaches students how to develop and deploy web applications using PHP and MySQL.
Begin with Object Oriented Programming, and focus on advanced features of MySQL, teaching students how to create efficient applications by implementing business logic within the database itself using MySQL.
This PHP & MySQL course is available on our public class training in Kuala Lumpur or also available if you want to conduct In-House training at your venue, throughout Malaysia.
Who should attend?
UNIX and Windows Users, Web Developers and Programmers wishing to create web based systems utilizing PHP and MySQL.
Prerequisites
Attendance on the PHP Programming course or equivalent experience.
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
At this time, this course is available for private class and in-house training only. Please contact us for any inquiries.