PHP DEVELOPEMENT COURSE – LEARN @ YOUR CONVENIENCE

PHP Introduction

1. Introduction PHP and MySQL
2. Benefits of using PHP MySQL
3. Setup of PHP Environment
4. Testing the Page
5. Troubleshooting Installation Errors

PHP Programming Concepts

1. Write your First PHP Program
2. Embed PHP in HTML / HTML in PHP
3. PHP Data Types
4. Variables in PHP
5. SuperGlobal Variables
6. Operators in PHP
7. Conditional Statements
8. Loops (For, While, Do While, Foreach)

PHP Functions

1. Using Functions in PHP
2. Userdefined Functions
3. Predefined Functions
4. Common Functions
5. String Functions
6. File Functions
7. Date Functions
8. Hash Functions
9. Mail Function

MySQL Database Training

1. What is Database ?
2. Understanding an RDBMS
3. Understanding Tables, Records, and Fields
4. SQL Language
5. Using the MySQL Command-Line Client

Working with MySQL Admin

1. Working with PHP MyAdmin
2. Creating Databases
3. Types of Databases
4. Creating Tables in Database
5. Specifying Field Data Types
6. Selecting the Most Appropriate Data Type
7. Adding Field Modifiers and Keys
8. Selecting a Table Type Altering Tables
9. Altering Table and Field Names
10. Altering Field Properties
11. Adding and Removing Fields and Keys
12. Altering Table Types
13. Backing Up and Restoring Databases and Tables
14. Backing Up Databases and Tables
15. Restoring Databases and Tables from Backup
16. Dropping Databases and Tables
17. Viewing Database, Table, and Field Information

SQL Queries

1. Inserting Records
2. Editing and Deleting Records
3. Performing Queries
4. Retrieving Specific Columns
5. Filtering Records with a WHERE Clause
6. Using Operators
7. Sorting Records and Eliminating Duplicates
8. Limiting Results
9. Using Built-In Functions
10. Grouping Records
11. Joining Tables
12. Using Subqueries
13. Using Table and Column Aliases

Arrays and Array Functions

1. Why use Arrays
2. Types of Arrays
3. Creating Arrays
4. Accessing Arrays
5. Array Functions
6. Using Array Functions