email: info@maxxindia.com
Address: Plot No. 63, Preeti Society
Om Nagar, Nara Road, Near Hanuman Mandir, Nagpur.
Mobile: 9370874422

PHP/ MYSQL

Course Duration:- 3 months
Batches:- Morning: 10:30am - 12:00noon, 12:00noon - 1:30pm

Course Content

Title Topics
Introduction Introduction to www, History
Understanding client/server roles
Apache, HTML, PHP, MySQL, JS, HTML & CSS
HTML HTML Tags, HTML Tag Elements, Tag Attributes, HTML Images, Lists, Links, Images, Tables, Forms
CSS CSS Styling, CSS Properties, Span, Div Tags, Meta Tags, Table Layouts, CSS Grouping, CSS Nesting, CSS based template handling

Assignment 1: Static Website using HTML, CSS

JavaScript Basics JavaScript Syntax, Variables, Conditional Loops, Variables, Operators, Conditional Statements, Loops
JavaScript DOM Handling HTML DOM Object, using DOM functions
JavaScript Form validations JavaScript events handling , RegExp, Form Validations using RegExp

Assignment 2: - Javascript Form Validation

PHP Fundamentals PHP Basic syntax, PHP data Types, PHP Variables, PHP Constants, PHP Expressions, PHP Operators, PHP Control Structures, PHP Loops
PHP Arrays PHP Enumerated Arrays, PHP Associative Arrays, Array Iteration, PHP Multi-Dimensional Arrays, Array Functions
PHP Functions PHP Functions, Syntax, Arguments, Variables, References, Pass by Value & Pass by references, Return Values, Variable Scope, PHP include(), PHP require()
PHP Forms PHP Form handling, PHP GET, PHP POST, PHP Form Validation, PHP Form Sanitization
PHP Cookies & PHP Sessions PHP Cookie handling, PHP Session Handling, PHP Login Session
PHP Strings Handling Strings and Patterns, Matching, Extracting, Searching Replacing, Formatting, PCRE
OOPS Object Oriented Basics, Modifiers, Inheritance, PHP Classes, Class Object, PHP Function Overriding and Overloading.
Basic MySQL, Simple SQL Queries Database basics, Indexes, PHP MyAdmin Connect, MySQL Create, MySQL Insert, MySQL Select, MySQL Update, MySQL Delete, MySQL Truncate, MySQL Drop
Advanced SQL Query Building WHERE condition, Order By, Group By, Having, LIKE, AND OR operators
MySQL Joins and SQL Functions Create Index, MySQL INNER Join, MySQL LEFT Joins, MySQL RIGHT Joins, Complex SQL Queries, Using SQL functions AVG, COUNT, SUM, MIN, MAX, LCASE, UCASE
HTTP Handling HTTP Headers, Page Redirect, File Uploading and File Downloading
AJAX Ajax with Get & Post, AJAX HTML output

Projects: Creating a dynamic website using PHP, MySQL

Copyright © 2021 maxxindia.com. All rights reserved.