Star Innovations

PHP and MySQL

 About this Course

This course is designed to provide sound grounding on PHP and emphasize its importance in web application development and enable the learner to understand the process for the development of any web application.

The learning artefacts are in the form of eBooks, Slides with Audio, Exercises in between and at the end of modules and Assessments at the end of each module to support online learning. Difficulties faced by participants with regards to the subject matter will be resolved through collaboration with peers and an expert who will mentor the online learning.

For classroom sessions,

  • Simple topics will start with recap of important points and discussion of concepts, followed by solving of exercises in the lab.
  • Moderately difficult topics will be explained in brief with example(s) and demonstration(s). Questions will be asked and discussed and if required, demonstration with more examples will be carried out, followed by solving of exercises in the lab.
  • Difficult topics will be explained in depth with example(s) and demonstration(s) for each concept. Learners will be asked to answer a set of questions and the responses will be taken up as group discussions in the class.

Course Syllabus

There are 10 modules, each comprising of an eBook and Slides with Audio, Exercises and end-of-module Assessments for online learning. Classroom delivery will consist of 15 classroom/lab sessions, each lasting for 2 hours.

01 MODULE
Introduction to PHP
Objectives:
Understanding of PHP working and its Installation
 Recommended Learning Duration:
 Week 1: Online Self Paced Learning 2.25 Hours, Assignments 1.25 Hours, Week 1: Classroom/Lab Theory 2 Hours, Lab 2 Hours
02 MODULE
Basics of PHP
Objectives:
Understanding operators and output constructs
 Recommended Learning Duration:
   Week 1: Online Self Paced Learning 1 Hour, Assignments 1 Hour, Week 1: Classroom/Lab Theory 1 Hour, Lab 1 Hour
03 MODULE
Arrays, Control Structures and File Inclusions
Objectives:
1) Understanding arrays and its function’s 2) Work using control statements and loops
 Recommended Learning Duration:
  Week 2: Online Self Paced Learning 1 Hour, Assignments 1.5 Hour, Week 2: Classroom/Lab Theory 1 Hour, Lab 1 Hour
04 MODULE
Functions, Function Scope and Variable Scope
Objectives:
1) Understanding function signature, syntax of defining and invoking 2) Understanding modes of calling functions like call by value, call by reference and different types of parameters
 Recommended Learning Duration:
 Week 2: Online Self Paced Learning 1 Hour, Assignments 1 Hour, Week 2: Classroom/Lab Theory 1 Hour, Lab 1 Hour
05 MODULE
Basic Object-Oriented Programming Concepts in PHP
Objectives:
1) Understanding OOPs concept and its implementation 2) Understanding pseudo-variable, its usage and different types of variables supported by PHP
 Recommended Learning Duration:
 Week 2: Online Self Paced Learning 1.5 Hour, Assignments 1 Hour, Week 2: Classroom/Lab Theory 1 Hour, Lab 1 Hour
06 MODULE
Advanced Object-Oriented Programming Concepts in PHP
Objectives:
1) Understanding implementation of Polymorphism, multilevel inheritance 2)Understanding abstract class and interface and also handling exception
 Recommended Learning Duration:
 Week 3: Online Self Paced Learning 2 Hours, Assignments 2 Hours, Week 3: Classroom/Lab Theory 1.5 Hours, Lab 2.5 Hours
07 MODULE
Developing Web Applications with PHP
Objectives:
Understanding ways to process the accepted user input, statemanagement, error handling and uploading files in PHP
 Recommended Learning Duration:
 Week 4: Online Self Paced Learning 2 Hours, Assignments 3 Hours, Week 4: Classroom/Lab Theory 2 Hours, Lab 2 Hours
08 MODULE
Basic Concepts of MySQL
Objectives:
Understanding configuration of MySQL and ways to execute SQL commands in MySQL
 Recommended Learning Duration:
 Week 4: Online Self Paced Learning 1.5 Hour, Assignments 1 Hour, Week 4: Classroom/Lab Theory 1 Hour, Lab 1 Hour
09 MODULE
Integrating PHP with MySQL Database
Objectives:
Understanding ways to perform CRUD operation and handling set retrieved using MySQL query
 Recommended Learning Duration:
 Week 5: Online Self Paced Learning 2 Hours, Assignments 2 Hours, Week 4: Classroom/Lab Theory 2 Hours, Lab 2 Hours
10 MODULE
Advanced CRUD Operations with PHP and MySQL
Objectives:
Understanding advance ways to perform CRUD operations and handling MySQL related errors
 Recommended Learning Duration:
  Week 5: Online Self Paced Learning 1.5 Hours, Assignments 3.5 Hours, Week 5: Classroom/Lab Theory 2 Hours, Lab 2 Hours
Final Exam- Online; Proctored
Final Evaluation of Learning
 Recommended Learning Duration:
 Week 6: Classroom/Lab Theory 1.5 Hours, Lab 3 Hours

More Info