Adobe Training
Acrobat Connect Training
Acrobat Training
Captivate Training
Dreamweaver Training
Flash Training
Flex Training
Illustrator Training
InDesign Training
Photoshop Training
VMware
VMware 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
Fast Facts
Duration
3 days
3 days
Class Size
Max 8 students
Max 8 students
Times
9.00am to 4.30pm
9.00am to 4.30pm
Computer
One per student
One per student
Training Manual
Included
Included
Price
1495.00
1495.00
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.
Learning 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 |
Jan, 2009 | Feb, 2009 | Mar, 2009 | Apr, 2009 |
| Building PHP and MySQL Web Applications | Jan 14 - 16 | Feb 25 - 27 |
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
"The class was exceptional in that each student was allowed to work on his own unique project instead of a generic project. The instructor became familiar with each project, and thus served as a adviser for each student/project. I will highly recommend this class to others."
Dennis Kmetz - Individual
"Great class. I feel I'm taking away a lot of useful information. I have an added level of confidence in using PHP and MySQL now. Thank you!"
Brandon Downing - Putman Media
"Chris is a very good instructor. He listens to your needs and implements them in the classroom assignments."
Tonisa Hutchinson - Illinois Workers' Compensation Commission
... view bioChris
