Non-Certification Course

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.

RM 3,899.00

per person

Level

Advanced

Duration

3 Days

Training Delivery Format

Face-to-face / Virtual Class

RM 3,899.00

per person

Level

Advanced

Duration

3 Days

Training Delivery Format

Face-to-face (F2F) / Virtual Class

Class types

Public Class

Private Class

In-House Training

Bespoke

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.

UNIX and Windows Users, Web Developers and Programmers wishing to create web based systems utilizing PHP and MySQL.

Attendance on the PHP Programming course or equivalent experience.

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
HRD Corp Claimable Course

At this time, this course is available for private class and in-house training only. Please contact us for any inquiries. 

Contact form

Get the Project Charter Guide now!

Just enter your email address to access the FREE Project Charter guide and template.