PHP MySQL Training | Chicago and LA
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. View past student's video testimonials.
Students can opt to work on 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. 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:
- 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 |
Mar, 2010 | Apr, 2010 | May, 2010 | Jun, 2010 |
| Building PHP and MySQL Web Applications | Mar 8 - 10 ! | Apr 12 - 14 ! | Jun 2 - 4 ! |
Los Angeles |
Mar, 2010 | Apr, 2010 | May, 2010 | Jun, 2010 |
| Building PHP and MySQL Web Applications | Apr 5 - 7 ! | May 24 - 26 ! |
* Class almost full ! Class guaranteed to run † Class is full
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
"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
"I have attended other training facilities and was far more impressed by the cohesive package and presentation of materials, office space and work environment. The staff was super friendly and helpful. I was also impressed by my instructor, he definitely demonstrated his expertise in the field."
Rebecca Adolf - INT
"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
... view bioChris
PHP MySQL Training Testimonial
"I have attended other training facilities and was far more impressed by the cohesive package and presentation of materials, office space and work environment. The staff was super friendly and helpful. I was also impressed by my instructor, he definitely demonstrated his expertise in the field."
Rebecca Adolf - INT
PHP MySQL Training Testimonial
"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
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
"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
