PHP

• Why PHP and MySQL?
• Server-Side Scripting Overview
• Getting Started with PHP
• Exploring PHP Syntax and Variables
• Understanding PHP Control Structures and Functions
• Passing Information with PHP
• Learning PHP String Handling
• Knowing Arrays
• Learning PHP Number Handling
• Advanced Array Functions
• Examining Regular Expressions
• Working with the File System
• Working with Cookies and Sessions
• Learning PHP Types
• Performing Math with PHP
• PHP Troubleshooting

Advance PHP

• Introducing Object-Oriented PHP
• Object Oriented PHP
• Securing PHP
• Learning PHP Configuration
• Handing Exceptions with PHP
• Debugging PHP Programs
• Learning PHP Style
• Using Log Files to Improve Your Site

Part IV - Connections

• Sending E-Mail with PHP
• Integrating PHP and JavaScript
• Integrating PHP and AJAX

Part V - Object Oriented PHP and PHP Framework

• Advanced OOP - how to plan and structure your code for OOP
• Implementing MySQL CRUD in Object Oriented PHP
• Common PHP Frameworks - an overview
• CodeIgniter
• Tests & Projects on PHP Framework

Connection PHP & MySql

• Introducing Database and MySQL
• Installing MySQL
• Learning Structured Query Language (SQL)
• Learning Database Administration and Design
• Integrating PHP and MySQL
• Performing Database Queries
• Integrating Web Forms and Databases
• Improving Database Efficiency
• PDO or PHP Data Object
• MySQL Troubleshooting

MYSQL

• Database Basics
• What is RDBMS
• SQL Basics
• Showing Databases
• Using Databases
• What is the Role of Tables, Rows, and Fields
• Showing Tables, Columns
• Creating a Database and Table
• Column Types-String and Numeric
• Search Criteria for Retrieving Data from a Table
• Updating an Existing Data
• Altering a Table completely
• Keys and Indexes in MySQL
• Operators in MySQL
• Arithmetic Operators
• Numeric Comparison Operators
• String Comparison Operators
• Logical Operators
• Regular Expressions

Practical with MySQL Database

• Querying your data
• Sorting, Grouping and Arranging Retrieved Data
• Limiting Numbers of Results
• Joining Tables (Inner Join, Left Join, Right Join, Join etc.)
• More on Joining Tables
• Data Aggregation- sum(), avg(), max(), min(), count(), first(), last(), ucase(), lcase(), mid(), len(), round(), format() etc.

Live Projects

• Web Hosting Basics
• Types of Hosting Packages
• Registering domains
• Defining Name Servers
• Using Control Panel
• Creating Emails in Cpanel
• Using FTP Client
• Maintaining a Website

• Clients Requirement Analysis
• Planning the Website
• Creating the HTML/CSS Structure
• Creating project using Bootstrap
• Integration of Features using JS and jQuery
• Project Testing