Training CoursesComputer TrainingTraining Course ScheduleOnsite Computer TrainingComputer Training classroom for rentAbout Training ConnectionContact Training Connection
PHP Training Chicago and Los Angeles

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.

PHP training facts

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.

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

Book PHP Training
 
Detailed 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.
 

What's included

PHP Training Manual
Certificate of Course Completion
6 Months FREE Repeat Policy
2 AMC Movie Vouchers

Register for PHP training
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
# # # # # # # # # # # # # # # # # #
Computer and Business Skills Training

Adobe Training

Acrobat Training
After Effects Training
Captivate Training
Dreamweaver Training
Flash Training
Flash Builder Training
Illustrator Training
InDesign Training
Photoshop Training
Premiere Pro Training

Microsoft Office

Access Training
Excel Training
Outlook Training
PowerPoint Training
Project Training
Visio Training
Word Training

Web Development

AJAX Training
CSS Training
HTML Training
JavaScript Training
jQuery Training
Mobile Development Training
PHP MySQL Training

Business Skills

Business Communication
Business Etiquette Training
Business Writing Class
Customer Service Training
Project Management Training
Time Management Training
 
 
  • HOME
  • TRAINING
  • TIMETABLE
  • ONSITE TRAINING
  • ROOM HIRE
  • ABOUT US
  • CONTACT US

  • SITE MAP
  • TERMS
  • COPYRIGHT 2007 - 2013