Announcement: Mindasys is now Skillet! Check out our new website.

Key points about this course

Duration : 3 Days
Course Fee : RM 3,5990.00

HRD Corp Claimable Course

PHP & MySQL (Advanced)

Virtual Class

Public Class

In House Training

Private Class

Course Overview

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.

Course 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

  • PHP and MySQL (Advanced)

  • Ask For