University of Colombo School of Computing (UCSC) conducts a Training Course on “Dynamic Web Application Development with PHP & MySQL”


Course Contents :

Data Management

  • The value of Data Management
  • Introduction to databases
  • Database Terminology
  • File Systems vs. Database Systems
  • Phases of database design

Operational Systems

  • Conceptual Database Design
    • Entity-Relationship (ER) Models
    • Enhanced E-R Diagrams

Relational Database Design

  • SQL – Data Definition Language (DDL)
  • SQL – Data Manipulation Language (DML)
  • Database Programming (Stored Procedures, Functions, Triggers)

Introduction to PHP

  • Server Configuration
  • PHP Basics
  • Data Types
  • Flow Control (use of loops)
  • String Manipulation
  • Use of Array

Object Orientation with PHP

  • Understanding Classes and Objects
  • Using Constructors and Destructors
  • Extending Classes through Inheritance
  • Controlling the Visibility of Properties and Methods
  • Static Properties and Methods
  • PHP Magic Constants
  • PHP Exception Handling

File Manipulation

  • Directory Manipulation
  • File Uploading

MySQL with PHP

  • PHP Connect to MySQL Server
  • Connecting to MySQL Database Server
  • Creating MySQL Database Using PHP
  • Creating Tables inside MySQL Database Using PHP
  • Inserting Data into a MySQL Database Table
  • Insert Data into a Database from an HTML Form
  • PHP MySQL Prepared Statements
  • Selecting Data From Database Tables
  • Filtering the Records
  • Updating Database Table Data
Duration: 08 Sundays (8.30am to 5.30pm)
Note:  Places are limited and will be filled strictly on the first-come-first-served basis


10 Saturdays (8.30 am – 5.30 pm)

Course Fee:

Rs. 32,000/=