About This Course
This 3-day intermediate training program is designed for participants with basic database knowledge who want to advance their practical skills in MySQL and PHP.
The course is structured into six modules covering: advanced SQL queries, relational database design, working with JSON data, database administration and security, PHP integration, and a final project to develop a fully functional database-driven application.
Through hands-on labs and real-world exercises, participants will strengthen their ability to write efficient queries, manage users and access privileges, handle backup and restore operations, and integrate MySQL with PHP to build practical applications.
Learning Outcomes
By the end of this course, participants will be able to:
● Execute advanced SQL queries including JOINs, subqueries, and aggregations (GROUP BY, HAVING) for real-world scenarios.
● Design and manage relational databases with complex relationships (One-to-One, One-to-Many, Many-to-Many).
● Work with JSON data in MySQL to handle modern data formats efficiently.
● Perform database administration tasks, including managing users, assigning privileges, and implementing role-based access control.
● Execute database backup and restore operations to ensure data reliability.
● Integrate MySQL with PHP (mysqli/PDO) to develop functional database-driven applications.
● Apply best practices in database management and application development through a practical final project.
Prerequisites
Participants are expected to have basic computer literacy and programming skills
Course Outline
Advanced SQL Queries
● JOINs (INNER, LEFT, RIGHT)
● Subqueries and derived tables
● Aggregation functions: COUNT, SUM, AVG, MIN, MAX
● GROUP BY & HAVING clauses
Designing Relational Databases
● Database relationships: One-to-One, One-to-Many, Many-to-Many
● Advanced schema design in MySQL Workbench
● Lab: Writing complex queries & creating relational schemas
Working with JSON in MySQL
● Storing and querying JSON data
● JSON functions: JSON_EXTRACT, JSON_ARRAY, etc.
● Lab: Hands-on practice with JSON
Database Administration & Security
● User management: GRANT, REVOKE, role-based access
● Backup and restore using mysqldump
● Lab: Implementing access control, backup & restore operations
PHP & MySQL Integration
● Connecting PHP to MySQL using mysqli/PDO
● CRUD operations via PHP
● Lab: Developing queries and simple PHP scripts
Final Project – Application Development
● Build a fully functional database-driven application
● Implement backup & restore in the application
● Review, Q&A, and closing
Upcoming Sessions
There are currently no scheduled sessions for this course.
We'll notify you when new sessions are scheduled
Your Instructor
Intermediate Database Development with MySQL & PHP
This 3-day intermediate training program is designed for participants with basic database knowledge who want to advance their practical skills in MySQL and PHP.
The course is structured into six modules covering: advanced SQL queries, relational database design, working with JSON data, database administration and security, PHP integration, and a final project to develop a fully functional database-driven application.
Through hands-on labs and real-world exercises, participants will strengthen their ability to write efficient queries, manage users and access privileges, handle backup and restore operations, and integrate MySQL with PHP to build practical applications.
Learning Outcomes
By the end of this course, participants will be able to:
● Execute advanced SQL queries including JOINs, subqueries, and aggregations (GROUP BY, HAVING) for real-world scenarios.
● Design and manage relational databases with complex relationships (One-to-One, One-to-Many, Many-to-Many).
● Work with JSON data in MySQL to handle modern data formats efficiently.
● Perform database administration tasks, including managing users, assigning privileges, and implementing role-based access control.
● Execute database backup and restore operations to ensure data reliability.
● Integrate MySQL with PHP (mysqli/PDO) to develop functional database-driven applications.
● Apply best practices in database management and application development through a practical final project.
Prerequisites
Participants are expected to have basic computer literacy and programming skills
Course Outline
Advanced SQL Queries
● JOINs (INNER, LEFT, RIGHT)
● Subqueries and derived tables
● Aggregation functions: COUNT, SUM, AVG, MIN, MAX
● GROUP BY & HAVING clauses
Designing Relational Databases
● Database relationships: One-to-One, One-to-Many, Many-to-Many
● Advanced schema design in MySQL Workbench
● Lab: Writing complex queries & creating relational schemas
Working with JSON in MySQL
● Storing and querying JSON data
● JSON functions: JSON_EXTRACT, JSON_ARRAY, etc.
● Lab: Hands-on practice with JSON
Database Administration & Security
● User management: GRANT, REVOKE, role-based access
● Backup and restore using mysqldump
● Lab: Implementing access control, backup & restore operations
PHP & MySQL Integration
● Connecting PHP to MySQL using mysqli/PDO
● CRUD operations via PHP
● Lab: Developing queries and simple PHP scripts
Final Project – Application Development
● Build a fully functional database-driven application
● Implement backup & restore in the application
● Review, Q&A, and closing
Upcoming Sessions
There are currently no scheduled sessions for this course.
We'll notify you when new sessions are scheduled
Course Information
Your Instructor
Khairil-Iszuddin bin Ismail
Professional Experience