1) Introduction about programming language
- About PHP
- About MySQL
- About HTML, CSS and Javascript
- About static and dynamic website
2) PHP Basics and Conditional Logic
- PHP installation
- MySql installation
- Data types, Arrays
- Constants
- Strings
- Web concepts
- Loops
- Operators
- Practical examples
3) Functions and Error Handling
- PHP functions
- Exception Handling
- Error Handling & Debugging
- Mail function
- Date & Time methods
4) Object Oriented Programming
- Concept of OOPS
- Defining classes, Creating Objects, Member functions,
- Constructor and Destructor,
- Inheritance, Function overriding,
- Access Specifiers- private, public and protected members,
- Interfaces, Constants, Abstract Classes,
- Static keyword, Final keyword
5) MySQL Installation and Basics
- Installation of mysql
- MySQL connection with PHP
- Database creation
- Database Manipulations- Add, Edit, Retrieve and Delete.
- Table creation and table manipulations- Add Edit, Retrieve and Delete
6) Advance Queries and Data Manipulation using PHP
- LIKE clause, Sorting, Joins, Handling NULL Values,
- Transactions, ALTER Command, Indexes, Temporary Tables, Clone Tables, Database, Information
- Sequences, Handling Duplicates, SQL Injections, Select, insert, update and delete using PHP script
- Backup database
- Import .sql file