Login / Register


MySQL™ and PHP are two of the most popular open source technologies to emerge during the past decade. PHP is a powerful language for writing server-side Web applications. MySQL is the world’s most popular open source... Show More
Course Prerequisites:
Computer Literacy and Windows 7 or 8.
Request a Quote

Instructor-Led Training (ILT)

Attend training in a classroom environment at a campus near you. Instructor-led training is still the number one delivery method of choice because it allows you to interact and discuss the training material, either individually or in a group setting, and you gain access to expert knowledge from certified instructors. This form of guided learning is impactful and produces positive learning outcomes. Day, evening and Saturday classes are offered.

4 Days

Course Schedule

Upcoming dates for MySQL and PHP

Course Content

Getting started
Introducing PHP & MySQL
Understanding the cloud
Installing Abyss Web Server
Installing the PHP engine
Configuring Abyss for PHP
Embedding PHP script
Installing the MySQL Server
Employing the MySQL Client
Creating MySQL users
Connecting MySQL with PHP

Performing operations
Creating variables
Managing strings
Producing arrays
Sorting arrays
Describing dimensions
Doing arithmetic
Comparing values
Assessing logic
Defining constants

Controlling progress
Branching alternatives
Switching branches
Performing loops
Looping while true
Breaking from loops
Creating functions
Passing arguments
Returning values

Producing forms
Performing actions
Checking set values
Validating form data
Sending hidden data
Handling submissions
Making sticky forms
Surrounding forms
Appending link data
Moving location

Assembling tables
Introducing tables
Creating tables
Defining data types
Adding modifiers
Setting primary keys
Altering tables

Handling data
Inserting data
Updating columns
Updating fields
Deleting data
Selecting data
Retrieving columns
Retrieving rows
Sorting data
Setting direction
Making comparisons

Connecting databases
Making connection
Executing queries
Retrieving results
Applying changes
Counting records
Updating records
Validating results
Ensuring security
Handling errors

Registering users
Creating a user’s database
Providing a register page
Processing registrations
Providing a login page
Supplying login tools
Processing login attempts
Confirming login success

Providing forums
Creating a forum database
Providing a forum page
Supplying a message form
Processing posted messages
Confirming post success

Processing shops
Creating a shop database
Creating an orders database
Providing a shop page
Confirming cart additions
Processing shopping carts
Checking out orders
Confirming logout success

CTU Training Solutions , Updated: July 7th, 2017

Share with friends

Request a Quote

Your Name
Your Surname
Contact Number
Your Email
Which campus would you like to study at?
Your job title
Will your training be sponsored?
The course information above is subject to change without notification due to market trends in the industry, legislation and/or programme version updates. Terms and Conditions

Join the CTU community

Join the CTU Community Portal and gain access to superior resources.

Join for Free