PHP MySQL Training | Chicago

Fast Facts

Duration
3 days

Class Size
Max 8 students

Times
9.00am to 4.30pm

Computer
One per student

Training Manual
Included

Price
1495.00

Building PHP and MySQL Web Applications

Upcoming Classes
Course Outline
Instructors

Course Description

On this PHP MySQL course you will build a database driven website. You will learn the basics of PHP, SQL (a language used to query a database) and MySQL.

Students can opt to work of their own projects during this class. Therefore the class can be fully customized towards your desired outcome.

Target Audience

This course is aimed at intermediate and advanced Web designers looking to take the leap into building database driven websites.o knowledge of JavaScript is required however if you do know some JavaScript, that will make learning PHP a breeze, since the languages are similar.

Leaning Objectives

Upon successful completion of this PHP MySQL Training course students will be able to:

Install PHP and MySQL.
Publish MySQL Data on the Web.
Relational Database Design.
Build a Content Management System.
Content Formatting and Submission.
MySQL Administration.
Advanced SQL Queries.
Binary Data.
Cookies and Sessions in PHP.
Structured PHP programming.
MySQL Syntax.

Upcoming Classes

Chicago	Aug, 2008	Sep, 2008	Oct, 2008	Nov, 2008
Building PHP and MySQL Web Applications		Sep 17 - 19		Nov 5 - 7

Click here for directions

Course Outline

Installation

Windows Installation
Installing MySQL
Installing PHP
Linux Installation
Mac OS X Installation
Post-Installation Setup Tasks
If Your Web Host Provides PHP and MySQL
Your First PHP Script

Getting Started with MySQL

An Introduction to Databases
Logging On to MySQL
So what's SQL?
Creating a Database
Creating a Table
Inserting Data into a Table
Viewing Stored Data
Modifying Stored Data
Deleting Stored Data

Getting Started with PHP

Introducing PHP
Basic Syntax and Commands
Variables and Operators
Arrays
User Interaction and Forms
Control Structures
Multipurpose Pages

Publishing MySQL Data on the Web

A Look Back at First Principles
Connecting to MySQL with PHP
Sending SQL Queries with PHP
Handling SELECT Result Sets
Inserting Data into the Database
A Challenge

Relational Database Design

Giving Credit where Credit is Due
Rule of Thumb: Keep Things Separate
Dealing with Multiple Tables
Simple Data Relationships
Many-to-Many Relationships

A Content Management System

The Front Page
Managing Authors
Deleting Authors
Adding Authors
Editing Authors
Magic Quotes
Managing Categories
Managing Jokes
Searching for Jokes
Adding Jokes
Editing and Deleting Jokes

Content Formatting and Submission

Out with the Old
Regular Expressions
String Replacement with Regular Expressions
Boldface and Italic Text
Paragraphs
Hyperlinks
Matching Tags
Splitting Text into Pages
Putting it all Together
Automatic Content Submission

MySQL Administration

Backing up MySQL Databases
Standard Backups Aren't Enough
Database Backups using mysqldump
Incremental Backups using Update Logs
MySQL Access Control
Using GRANT
Using REVOKE
Access Control Tips
Locked Out?
Checking and Repairing MySQL Data Files

Advanced SQL

Sorting SELECT Query Results
Setting LIMITs
LOCKing TABLES
Column and Table Name Aliases
GROUPing SELECT Results
LEFT JOINs
Limiting Results with HAVING

Advanced PHP

Server-Side Includes with PHP
Increasing Security with Includes
Semi Dynamic Pages
Handling File Uploads
Assigning Unique File Names
Recording Uploaded Files in the Database
Email in PHP

Storing Binary Data in MySQL

Binary Column Types
Storing Files
Viewing Stored Files
The Complete Script
Advanced Considerations
MySQL Packet Size
PHP Script Timeout

Cookies and Sessions in PHP

Cookies
PHP Sessions
A Simple Shopping Cart

Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.

Meet the Instructors

Chris

CLOSE BIO

"This course is literally changing my life! The majority of my workday is spent updating my websites' HTML pages individually, page by page ... now I know not only how to automate my updates, but also how to more efficiently store data and make it accessible to customers and other employees. It will completely change the way I work and the way my company interacts with its customers. Chris was a fantastic instructor. His knowledge is expansive and his laid-back, accessible style was conducive to a very comfortable and productive learning environment. He answered our questions thoroughly to ensure our understanding of the material and offered plenty of real-world examples. I'd definitely take a class from him again -- and thanks to the "return within 6 months for free" policy, I probably will!

Peter Celauro - Blockmaster Electronics

"Chris is a very good instructor. He listens to your needs and implements them in the classroom assignments."

Tonisa Hutchinson - Illinois Workers' Compensation Commission

"This class was thorough, and challenging. The topic, PHP and MySQL, can be quite difficult to understand. However our instructor, Chris, did a great job of providing real world knowledge, and we catered the scope of the class to an actual PHP site we were considering building. I would recommend this class to anyone wishing to "get their feet wet" and provide a good foundation for further learning of the PHP and MySQL language."

Dan Uhle - School District 69

... view bioChris

Adobe Training

Web Development

Microsoft Office

Business Skills

QuickBooks