MySQL and PHP – Developing Dynamic Web Applications

DKV logo


Preference Timing Location
17 – 21 January 2016
Weekly 9:00AM – 5:00PM Dubai Knowledge Village



5 Days

Participation Fees

$2,000 USD per participant

Course Description

PHP is a widely used, free, powerful server side scripting language for developing dynamic and interactive Web pages quickly. MySQL is the most popular Database Management System used for manipulating database. This course will help you develop skills to combine the powers of PHP and MySQL database management techniques to create efficient, dynamic and secure web applications.

Download Detailed Course Description


  • Anyone who is interested in web development and wants to create dynamic websites using PHP.


  • Knowledge of HTML is beneficial but not compulsory.

Recommended next course

Course Objectives

  • Setting up the environment
  • Getting Started with PHP
  • Working with PHP variables, controls, functions
  • Setting up and processing Forms
  • Introducing Object-Oriented programming
  • Introduction to MySQL
  • Creating connection to Database
  • Creating tables and making updates to the table data

Course Outline

Unit 1 – Getting started with PHP

  • Installing XAMPP
  • Installing your Editor and configuring your workspace
  • Adding your first PHP code to your Web Page
  • Picking a formatting style
  • Learning PHP syntax
  • Introduction to PHP variables
  • Working with String functions
  • Understanding different types of numbers
  • Debugging techniques

Unit 2 – Working with Complex Data

  • Working with Arrays
  • Working with Logical variables
  • Working with Constants
  • Working with Dates
  • Working with built-in functions

Unit 3 – Working with PHP controls

  • If/Else Statements
  • Logical Operators
  • Switch Statements
  • Repeating program steps using various loops

Unit 4 – Reusing Code with functions

  • Defining Functions
  • Passing Parameters
  • Getting values from functions
  • Using functions

Unit 5 – Creating Forms

  • Setting up Forms
  • Processing Forms

Unit 6 – Objects and Classes

  • Introducing Object Oriented Programming
  • Defining Classes
  • Creating Objects

Unit 7 – Introducing MySQL Database

  • What is a Database
  • Gathering information to define a database
  • Designing Your Tables
  • Setting up Relationships between Tables
  • Normalizing the Tables
  • Using phpMyAdmin interface

Unit 8 – Connecting to Database

  • Connecting with the Database
  • Creating a Database
  • Understanding Data Types
  • Understanding defaults
  • Creating tables in phpMyAdmin
  • Using .sql script files
  • Adding MySQL Tables to PHP

Unit 9 – Handling Data

  • Understanding INSERT command
  • Executing MySQL commands in PHP
  • Processing Data Entry Forms in PHP
  • Using SELECT command
  • Using WHERE clause
  • Selecting Data in PHP
  • Using UPDATE command
  • Updating Data in PHP
  • Using Prepared Statements
  • Using DELETE command
  • Deleting Data in PHP

Unit 10 – Joins

  • What is a Join
  • Using Sub Queries

Unit 11 – Creating User Logins

  • Understanding Access Control
  • Protecting Passwords
  • Using Cookies and Sessions

Unit 12 – Conclusion

  • Course Overview
  • Course Evaluation


Share Button
Skip to toolbar