Web Development PHP

PHP:

1.    Set Up Personal Web Server
2.    PHP Syntax
3.    Declaring PHP Variable
4.    Show Output in PHP
5.    PHP Data types
6.    PHP Strings
7.    PHP Constants
8.    PHP Operators
9.    Conditional Statement
10.    Switch Statement
11.    For Loop
12.    While Loop
13.    Do While Loop
14.    Foreach Loop
15.    Function
16.    Array
17.    Sorting Array
18.    Variable Scope
19.    Superglobals
20.    Form Handling
21.    Form Validation
22.    Form Required
23.    Form URL/Email Validation
24.    Date and Time
25.    Include and Require
26.    File Handling
27.    File Open/Read
28.    File Create/Write
29.    File Upload
30.    Session
31.    Cookie
32.    Filters
33.    Filters Advanced
34.    Error Reporting
35.    Exception
36.    Explode & Implode Function
37.    Case Change
38.    Strip Whitespace/Characters
39.    Require or Require Once
40.    PHP Array Functions

MySQL:

1.    What is Database?
2.    Create & Drop Database
3.    Create Table
4.    Insert, Update, Delete Data
5.    Alter Table
6.    Select Data
7.    Operator Overview
8.    Select Distinct Statement
9.    Where Clause
10.    ORDER BY Keyword
11.    AND, OR, NOT, BETWEEN, LIKE, IN Operator
12.    Wildcard Operator
13.    SQL TOP, LIMIT, ROWNUM Clause
14.    MIN, MAX, COUNT, AVG, SUM Function
15.    Group By Statement
16.    HAVING Clause
17.    EXIST Operator
18.    ANY, ALL Operator
19.    CASE Statement
20.    Relationship & Foreign Keys
21.    Join (Inner, Left, Right, Self, Full)
22.    Union Operator
23.    Union All
24.    Join Multiple Table
25.    Subquery in Select, Insert, Update and Delete
26.    Index
27.    Unique
28.    Truncate Table
29.    Aliases for Column
30.    Aliases for Table
31.    Aggregate Function         
32.    Create View
33.    Insert Data into a View
34.    With Check Option
35.    Update, Delete, Drop View
36.    UCASE and LCASE Function
37.    MID, LENGTH, ROUND Function
38.    NOW Function
39.    GUI Mode Operation
40.    Database Backup

OBJECT ORIENTED PHP:

1.    Class, Method and Object
2.    Work with Method and Object
3.    Constructor & Destructor
4.    Class Constant
5.    Static Method and Properties
6.    Inheritance
7.    Preventing from Extending and Overriding
8.    Access Modifiers
9.    Polymorphism
10.    Interface
11.    Abstract Class
12.    Magic Method
13.    Class & Method Existence
14.    Autoloading Classes
15.    PHP Method Chaining
16.    Type Hinting
17.    Object Iteration
18.    Using Trait
19.    _Class_ and get_class
20.    Late Static Binding
21.    Object Cloning
22.    Magic Method _clone
23.    PHP Array Object
24.    Standard PHP Library SPL
25.    PHP Object Serialization
26.    PHP Namespaces
27.    Strategy Design Pattern
28.    Factory Design Pattern
29.    Abstract Factory Design Pattern
30.    Singleton Design Pattern
31.    Iterator Design Pattern
32.    Observer Design Pattern
33.    Decorator Design Pattern
34.    Façade Design Pattern
35.    MySQL connection OOP Way
36.    Select/Update Data
37.    Basic Prepared Statement
38.    Prepared Statement with Variable
39.    BLOB With Prepared Statements
40.    PDO - PHP Data Objects
41.    Prepared Statements with PDO
42.    bindValue() and bindParam()
43.    Select Data With PDO
44.    Update, Delete Data With PDO
45.    CRUD Operation With PDO