PHP
PHP Basics – Syntax, Data Types, Variables, Constants, Operates and Expressions, Control Structures – Functions – Returning Values, Variable Scope – Arrays – Operations, Iteration, Sorting Array – Security – Formatting and Manipulating Strings with PHP – Web Programming – Forms and URLs, HTTP Headers, Sessions – Session Security – Using Date and Time Function – Working with Forms.
MySQL
Client/Server Concepts – Relational Model – Data Definition Using SQL – Modify Tables – Using Alter Table Queries, Add a column, Add an Index, Add a Primary Key – Insert and Delete Queries – Update Queries – Using Select Queries – Select, Where, Limit, Order by, Group By, Join – Constraints and Indexes – Views – Expressions – Grouping – Using Functions – Math Functions, Compare String Values, Work with Dates – Join and Subqueries – Advanced MySql query Processing – Database Management, Stored Procedures, Triggers, etc. Using MySQL with PHP
PROJECT
Student will develop web based applications like online reservation, online share trading, live website, etc.