PHP / MySQL Outline

Basic PHP (24 hrs)

Introduction to Web Development with PHP
The Architecture of a Web Application
How to Edit and Test a PHP Application
How to use NetBeans to develop a PHP

How to code a PHP application
Basic PHP skills
How to get data from a request
How to work with data
How to code control statements
How to use the PHP documentation

Introduction to relational databases with MySQL
An introduction to relational databases
The SQL statements for data manipulation
An introduction to MySQL
How to use XAMMP/phpMyAdmin

How to use PHP with a MySQL database
PHP for working with MySQL
How to get data from a result set

How to use the MVC pattern to organize your code
How to use the MVC pattern
The MVC application

How to test and debug a PHP application
Introduction to testing and debugging
How to debug with xDebug and NetBeans

How to work with form data
How to get data from a form
How to display data on a web page

How to code control statements
How to code conditional expressions
How to code the selection structures
How to code the iteration structures

How to work with strings and numbers
How to work with strings
How to work with numbers
Other skills for working with strings and numbers

How to work with dates
How to use timestamps to work with dates
How to use objects to work with dates

How to create and use arrays
How to create and use an array
How to create and use an associative array
How to use functions to work with arrays
How to work with arrays of arrays

How to work with cookies and sessions
How to work with cookies
How to work with sessions

How to create and use functions
Basic skills for working with functions
How to create and use library of functions
Advanced skills for working with functions

How to create and use objects
How to create and use classes
How to code class constants, properties, and methods
Additional skills for working with objects
How to work with inheritance

How to use regular expressions, handle exceptions, and validate data
How to use regular expressions
How to handle exceptions


ADVANCED PHP and MySQL (Master MySQL programming) (36 hrs)

How to design a database
How to design a data structure
How to normalize a data structure
A database design tool

How to use SQL to create a MySQL database
How to work with databases
How to work with tables
How to work with indexes
How to work with users and privileges
Other skills for creating a database
 

How to use SQL to work with a MySQL database
How to select data from a single table
How to select data from multiple tables
How to code summary queries
How to code subqueries
How to update, insert and delete rows

Professional PHP for working with MySQL
Three ways to use PHP to work with MySQL
How to work with PHP Data Objects (PDO)
How to work with mysqli

A database-driven web site
How to work with large text columns
The include files
Shopping cart applications

Master the advanced skills for building web sites (Securing your web sites)
How to use a secure connection
How to use authentication
How to work with encrypted data

How to send email and access other web sites
How to send email
How to get data from other servers
The YouTube Search application

How to work with files, uploads, and images
How to work with files
How upload a file
How to work with images
The Image Upload application

An eCommerce web site
An introduction to the web site
The user interface for end users
The user interface for administrators