PHP & MySQL

Not required

Basic PHP
Why and Scope of PHP
PHP as Open source Technology
PHP for Web Based Application
PHP Variables
PHP Echo,Print_r()
PHP Logical and Arithmatic Operators
PHP Concatenation
PHP Comments
PHP Strings
PHP Arrays
PHP Inbuilt Functions
PHP Methods - $_GET,$_POST,$_REQUEST
PHP Functions - include(),reuire(),include_once(),reuire_once()
PHP Pagination
IF Loop , While Loop , Do-While Loop , Swich Case , Nested IF , For Loop , For Each
PHP Login Aunthentication - Session , Cookies
PHP Mail
PHP File Handling and File Uploading
PHP - MySQL Connection
PHP - Object Oriented Basics
PHP Classes
PHP Class Objects
PHP Encryption
PHP Function Overriding and Overloading
PHP OOPS Framework Overview
Basic MySQL
Why and Scope of MySQL
MySQL as Open source Technology
MySQL for Web Based Application
MySQL Create Database
MySQL Create Table
MySQL Table Fields
MySQL Primary Key
MySQL Foreign Key
MySQL Where clause
MySQL Alias
MySQL AND & OR
MySQL Like
MySQL Between
MySQL Order By
MySQL Group By
MySQL Having
MySQL Sub Query
Import and Export through Command line
Import and Export through PHPMYADMIN Tool
MySQL Functions - AVG(),MIN(),MAX(),COUNT(),SUM()ROUND(),CONCAT(),LCASE(),UCASE()
MySQL Joins - Left Join , Right Join , Inner Join
MySQL Query Optimization Concept
MySQL Functions - repeat(), strlen(), substr(), strpos(), sqrt(), power(), abs(), concat_ws()
MySQL Functions - curdate(), curtime(), datediff(), minute(), hour(), second(), day(), month()