Building PHP and MySQL Web Applications
Class timetable | Course outline
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. View past student's video testimonials.
Target Audience
This course is aimed at intermediate and advanced Web designers looking to take the leap into building database driven websites. No 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:
PHP Class Timetable
| Chicago | Jun 17 - 19 ! | Register |
| Los Angeles | Jul 1 - 3 ! | Register |
| Los Angeles | Aug 19 - 21 | Register |
| Chicago | Aug 21 - 23 | Register |
| Los Angeles | Oct 7 - 9 | Register |
| Chicago | Oct 7 - 9 | Register |
* Class almost full ! Class guaranteed to run Ŧ Class is full
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
What's included
PHP Training Manual
Certificate of Course Completion
6 Months FREE Repeat Policy
2 AMC Movie Vouchers
PHP MySQL Training Testimonial
"For anyone looking to advance their knowledge in web development, Training Connection is the place to start. I wanted to supplement my web design knowledge with PHP/mysql training. Chris, the instructor, took the class step-by-step through the process of a data-based driven website. There was no rushing material, overloading, or pressure of retention of data. I've had some programming in C and java and this course filled in the gaps. Fast connecting computers made sorting back and forth through files a breeze. I can't wait to start my CSS class to continue my path of knowledge with Training Connection."
Stephen Thomas - Ocean Blue Designs
PHP MySQL Training Testimonial
"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
PHP MySQL Training Testimonial
"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
PHP MySQL Training Testimonial
"My professional background is graphic/web design with little exposure to programming. My PHP and MySQL instructor, Chris, was very helpful and knowledgeable. After 3 days of instruction I have a good foundation for building upon my programming skills and I also have the confidence that I can take the skills I learned back to my work place! I am VERY pleased with Training Connection and would HIGHLY recommend it to anyone!"
Andrea Swanson - American College of Chest Physicians
