Adobe Training
Acrobat Training
Captivate Training
Dreamweaver Training
Flash Training
Flex Training
Illustrator Training
InDesign Training
Photoshop Training
Web Development
AJAX Training
CSS Training
HTML Training
JavaScript Training
PHP MySQL Training
Ruby on Rails Training
XML Training
Microsoft Office
Access Training
Excel Training
Outlook Training
PowerPoint Training
Project Training
Visio Training
Word Training
Business Skills
Anger Management Class
Business Communication
Business Etiquette Training
Business Writing Class
Change Management
Customer Service Training
Project Management Training
Sales Training
Supervisor Training
Time Management Training
QuickBooks
QuickBooks Training

PHP MySQL Training | Chicago
Building PHP and MySQL Web Applications
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 |
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
Meet the Instructors

Chris
"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

















