PHP Training

• Introduction to PHP
• A First PHP Web Page
• Variables, Operators and Expressions in PHP
• Control Statements in PHP
• Functions in PHP
• Arrays in PHP
• String Handling in PHP
• Input / Output in PHP
• HTML Web Page Data Handling in PHP
• Using MySQL Databases in PHP Pages
• Shopping Cart Application in PHP
• Designing PHP-Based Solutions: Best Practice in PHP
• Security in PHP

 Advanced PHP Training

PHP Overview in PHP

• What is PHP?
• Installation overview

First Steps in PHP

• Viewing PHP configuration information
• Embedding PHP
• ”Hello World!”
• The operational trail in PHP
• Inserting comments in PHP

Exploring Data Types in PHP

• Variables in PHP
• Strings in PHP
• String functions in PHP
• Numbers in PHP
• Arrays in PHP
• Booleans and NULL in PHP
• Type switching and casting in PHP
• Constants in PHP

Control Structures in PHP

• If statements in PHP
• Else and elseif statements in PHP
• Logical operators in PHP
• Switch statements in PHP
• Loops in PHP
• While loops in PHP
• For loops in PHP
• Foreach loops in PHP
• Continue in PHP
• Break in PHP
• Understanding array pointers in PHP

User-Defined Functions in PHP

• Defining functions in PHP
• Using functions in PHP
• Returning values from a function in PHP
• Setting global variables in PHP
• Setting default values in PHP

Debugging in PHP

• Debugging and troubleshooting in PHP

Building Web Pages in PHP

• Links and URLs in PHP
• Using GET values in PHP
• Encoding GET values in PHP
• Encoding for HTML in PHP
• Building forms in PHP
• Setting cookies in PHP
• Establishing sessions in PHP
• Headers and page redirection in PHP
• Including and requiring pages in PHP

MySQL Training

Relational Database Basics

• Brief History of SQL
• Relational Databases
• Popular Databases
• SQL Statements

Simple SELECTs with MySQL

• Introduction to the Northwind Database
• Some Basics
• SELECTing All Columns in All Rows
• Exploring the Tables
• SELECTing Specific Columns
• Sorting Records
• The WHERE Clause and Operator Symbols
• The WHERE Clause and Operator Words
• Checking Multiple Conditions
• Writing SELECTs with Multiple Conditions

Advanced SELECTs with MySQL

• Calculated Fields
• Aggregate Functions and Grouping
• Built-in Data Manipulation Functions

Subqueries, Joins, and Unions with MySQL

• Subqueries
• Joins
• Outer Joins
• Unions

Inserting, Updating and Deleting Records with MySQL

• INSERT
• UPDATE
• DELETE

Creating and Modifying Tables with MySQL

• Creating Tables
• Datatypes
• Altering Tables
• Renaming Tables
• Dropping Tables

Views and Stored Procedures

• Creating Views with MySQL
• Dropping Views
• Creating Stored Procedures
• Benefits of Stored Procedures

Check out our references or contact us for more information.