Centre for Virtual Learning

The College of Information and Communication Technologies

Univeristy of Dar es Salaam

PHP & MySQL Up and Running

 This PHP and MySQL course will provide you with the skills and knowledge beyond basics necessary to build powerful database-driven websites using PHP programming advanced tips and techniques.


This PHP and MySQL course is practical oriented which includes demonstrations and hands-on exercises.You’ll able to establish database connection and perfom useful SQL command like fetch, insert, update, delete, and search records. You’ll get familiarize with phpMyAdmin on how to create databases and tables, as well as data types and indexes. You'll know how to work with forms, validate and sanitize form input for security, understand how sessions and cookies works.

Course Outline

  • PHP understanding the Basics
  • PHP Expressions, Controls and Functions
  • PHP Object-Oriented Programming
  • PHP Forms Working with User Inputs and Files
  • PHP Forms Upload Files
  • PHP Debugging Techniques
  • MySQL understanding the Basics
  • MySQL Tables & Relationships
  • MySQL Databases Accessing using PDO
  • MySQL Querying,Indexing and Optimization
  • MySQL Backup and Restore
  • Build Database Driven Web Site Project
  • Style Web Project with CSS and JavaScript
  • Finalize Project

What you should do before attending this course

  • Come with your own Laptop computer
  • Make sure you installed your favorate Web-Server i.e. WAMP or MAMP e.t.c
  • Familiarize yourself with either PhpMyAdmin or MySQL Workbench

Who Should Attend This Course?

  • Anyone who wants to learn PHP programming and develop a dynamic website easily.
  • Anyone who wants to build a powerful dynamic database-driven website.
  • Anyone who wants to convert a static website to dynamic one.
  • Anyone who wants use the MVC pattern to organize code.

How to make Payment

There is two options how you can make your payment:

  • Using Mobile Money ( M-Pesa or Tigo Pesa) send direct to 0754677873 or 0715677873 , the numbers are registered with a name Oscar Mashauri.
  • Make Deposit at Bank: The fees Paid by cash should be deposited to NBC Bank, Account Name: Centre for Virtual Learning, Account Number: 040103002088 and by Cheque should be made payable to the Director, Centre for Virtual Learning (CVL), University of Dar es Salaam. Come with deposit(s) slip.
Sat 08 Jul 2017 - Sun 09 Jul 2017
10:00 AM. - 16:30 PM.
Kijitonyama Campus

Office Contact

Centre for Virtual Learning
University of Dar es Salaam
P.O. Box 33335
Kijitonyama Campus

Phone: (+255)-22-2700766
Fax: (+255)-22-2700766
Email: cvl@udsm.ac.tz