CERTIFICATE IN WEB DEVELOPMENT WITH PHP & MYSQL ( M-N-WD05 )

WEB DEVELOPMENT WITH PHP & MYSQL COURSE SYLLABUS

COURSE DURATION : 6 MONTHS

COURSE MODE : ONLINE/OFFLINE

TOTAL COURSE FEE : 7800

ADMISSION FEE : 1200

MONTHLY FEE : 1000

EXAM FEE : 600

Module 1

Introduction to PHP

• Basics of websites and web development.
• Introduction to dynamic websites.
• Getting starting with PHP programming.
• Understanding scope of PHP language.
• XAMPP and WAMP installation.

Module 2

PHP Programming Basics

• Syntax of PHP.
• Embedding PHP in HTML.
• Embedding HTML in PHP.
• Understanding PHP Variables.
• Understanding Data Types.
• Learning how to use Operators.
• Writing Statements and Comments.
• Using Conditional Statements.
• If( ), else if( ) and else if condition statement.
• Switch( ) Statements.
• Using the while( ) Loop.
• Using the for( ) Loop.

Module 3

PHP Functions

• Introduction to PHP Functions.
• Creating Arrays.
• Modifying Array Elements.
• Processing Arrays with Loops.
• Grouping Form selections with Arrays.
• Using Array Functions.
• Using Pre-Defined PHP Functions.
• Creating User-Defined Functions.

Module 4

PHP Advanced Concepts

• Reading and writing files.
• Reading data from a file.
• Managing Sessions and using Session Variables.
• Creating a Session & registering Session Variables.
• Destroying a Session.
• Storing data in cookies.
• Setting cookies.
• Dealing with Date and Time.
• Executing external programs.

Module 5

Introduction to Database

• What is database?
• What is MySQL?
• Database Queries.
• Basics of MySQL.

Module 6

Working with MySQL Database & Tables

• Creating MySQL Database.
• Creating database tables.
• Choosing the most appropriate Data Type.
• Adding Field Modifiers and Keys.
• Selecting a Table Type.
• Understanding Database Normalization.
• Altering Table and Field Names.
• Backing Up and Restoring Databases and Tables.
• Dropping Databases and Table Viewing Database, Table, and Field Information.