php and mysql online training course

Receive your login ID to take the training courses online, as many times as you wish, for 1 year. Click here for group orders.

Buy this entire online training course with one easy payment of $67

Benefits

Unlimited access for 1 year
Learn anytime, anywhere
You control the pace
Start & stop wherever you want
No books to read
No software needed
Value Packs include Free online tech support
Double guarantee

100% Money back guarantee
One time payment No monthly fee
Use the course index for review anytime
Answer course questions with at least 70% accuracy and print your own certificates of completion to prove that you have mastered each training course.
Free status reports for company managers

Requirements

All you need is a PC with Windows, the Microsoft Internet Explorer (browser) and an Internet connection.
Note: The online computer training is designed to work only with Internet Explorer. Prices shown are per user.

What You will Learn

This series teaches learners to create dynamic Web sites. Learners will be able to apply their knowledge to the creation of dynamic Web applications such as content management, user registration, and e commerce.

Installing Required Software

To install and configure MySQL
To install and configure Apache with PHP
To test PHP and MySQL installations

To create MySQL users and grant privileges
To configure PHP

PHP Basics

Identify basic PHP syntax
Create basic PHP scripts
Send data to the Web browser

Apply variables, strings, and constants to a PHP a script

Programming with PHP

Handle HTML forms using PHP scripts
Validate form data

Manage arrays using various types of loops
Work with magic quotes

Creating Dynamic Web Sites

Create PHP scripts using multiple files
Display and handle HTML forms within a single PHP script
Create and call functions

Create functions that take arguments and return values
Set and alter variable scope
Send email from a PHP script

SQL and MySQL

Choose column types and other column properties
Create databases and tables

Insert records, select, update and delete data
Use conditionals and functions

Advanced SQL and MySQL

Normalize a database into First, Second and Third Normal Forms
Create and populate a database in MySQL
Change the search engine type of a table

Search a database using joins, groupings, and FULLTEXT searches
Create indexes to improve the ability to search a database

Error Handling and Debugging

Identify error types
View, log, and debug errors

Adjust PHP's error reporting
Create custom error handlers

Using PHP with MySQL

Describe how arguments and PHP functions relate to the database
Differentiate between simple and complex functions depending on execution results
Update database records using PHP scripts

Modify specific scripts to allow for secure data transmission
Understand the importance of associative and indexed arrays

Developing Web Applications

Adjust behavior for server settings
Pass variables and values to a script
Edit existing records

Paginate query results
Make sortable displays
Use HTTP headers

Cookies and Sessions

Use cookies
Use sessions

Improve session security
Manage the relationship between cookies and sessions

Web Application Security

Prevent forms from being submitted multiple times
Define patterns and both match and replace them

Validate form data
Manage database encryption and decryption techniques

Extended Topics

Upload a file in PHP
Develop JavaScript using PHP
Utilize output buffering

Identify Improved MySQL Extension functions
Describe the purpose of PEAR

Content Management Example

Create the advanced PHP scripts needed for a content management site
Update and add information with a database

Download files through PHP scripts and database interactions
Manage files through PHP scripts and database interactions

User Registration Example

Handle user registration
Activate accounts

Create login and logout scripts
Apply password management

E Commerce Example

Create a database for an e commerce site
Create pages for a customer to browse the inventory and place orders from an e commerce site

Create the administrative pages for an e commerce site
Create and manage an online shopping cart for your e commerce site

PHP and MySQL Join over 1 million people who learn online, with these complete interactive computer training courses.

PHP and MySQL
Join over 1 million people who learn online, with these complete interactive computer training courses.