PHP - MySQL Programming for Web Applications

Category: Syllabus of all Courses Published: Sunday, 23 October 2016
No. Module Name
Module 1 Fundamentals :
Basic syntax, Data types, Variables, Constants, Expressions, Operators, Control Structures, Loops
Module 2 Arrays :
Enumerated Arrays, Associative Arrays Array Iteration, Multi-Dimensional Arrays, Array Functions
Module 3 Functions :
Functions, Syntax, Arguments, Variables, References, Pass by Value & Pass by references, Return Values, Variable Scope, include(), require()
Module 4 Forms :
Form handling, GET, POST, Form Validation, Form Sanitization
Module 5 Cookies & Sessions :
Cookie handling, Session Handling,Login Session, Managing user ACL
Module 6 Strings Handling Strings and Patterns, Matching:
Extracting, Searching Replacing, Formatting, PCRE
Module 7 MySQL :
Basic MySQL introduction, Simple Queries Database basics, Indexes, PHP MyAdmin,Connect & Pconnect, Create, Insert, Select, Update, Delete, Truncate, Drop
Module 8 Advanced MySQL :
Query Building WHERE condintion, Order By, Group By, Having, LIKE, AND OR operators
Module 9 Joins and Functions Create Index :
INNER Join, LEFT Joins, RIGHT Joins, Complex Queries, Using functions AVG, COUNT, SUM, MIN, MAX, LCASE, UCASE
Module 10 HTTP Handling :
HTTP headers, page redirect, file uploading and file downloading
Module 11 Live project, Case studies & Practical assignments
Module 12 Internship with certifications