PHP with MySQL

PHP with MySQL

Course Code:

PHP01

Course Duration:

100 hours

Course Delivery:

70 hours

Workshop:

08 hours

Project Work:

22 hours

Overview

This course provides the knowledge necessary to design and develop dynamic, database-driven web pages using PHP that powers many websites. It originally started out as a way to make dynamic websites by generating html. Because of its roots, it is very easy to insert bits and pieces of PHP inside of standard HTML/XHTML code. Participants will be using MySQL which is a popular relational database management system. It is the standard database system available on web hosting sites. Although it works with many different programming languages, it is frequently paired with PHP.

Pre-requisite Knowledge/Skills

  • Basic Programming knowledge and Logical skills and
  • Basic SQL knowledge.

Course Objective

Upon successful completion of the course, participants should be able to:

  • List the major elements of the PHP & MySQL work and explain why PHP is good for web development
  • Learn how to take a static website and turn it into a dynamic website run from a database using PHP and MySQL.
  • Analyze the basic structure of a PHP web application and be able to install and maintain the web server, compile, and run a simple web application.
  • Learn how databases work and how to design one, as well as how to use php MyAdmin to work with MySQL.
  • Learn different ways of connecting to MySQL through PHP, and how to create tables, enter data, select data, change data, and delete data. Connect to SQL Server and other data sources.

Course Outline

The contents of this course are designed to support the course objectives. The following focus areas are included in this course:

  • Module 1: Introduction to MYSQL
  • Module 2: MySQL with PHP
  • Module 3: Introduction to PHP
  • Module 4: PHP programming
  • Module 5: PHP Arrays
  • Module 6: PHP Functions
  • Module 7: PHP Forms and User Input
  • Module 8: PHP Cookies and Sessions
  • Module 9: PHP Exception Handling

Project Work

Participants are required to do a project work as a part of the program. Project work should be in accordance with the project specifications provided by ICT Academy of Tamil Nadu in consultation with the industry. The project work should be done in groups, with 4 or 5 participants in a group.

Course Deliverables

For Faculty

  • Course Material
  • Course Slides
  • Facilitator Guide
  • Student Exercises
  • Case Studies
  • Certification from ICT Academy of Tamil Nadu

For Student

  • Course Material
  • Orientation session by ICT Academy of Tamil Nadu / Industry Experts
  • Exercises
  • Case Studies
  • Online Assessment
  • Certification from ICT Academy of Tamil Nadu