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()