Computer and Business Skills training

Home / PHP

PHP Training

Chicago, Los Angeles

PHP is a widely-used open source scripting language used to build database driven websites.


No minimum class size - all classes guaranteed to run!


We specialize in face-to-face instructor-led PHP training. Our instructors are experienced Web developers.


Onsite training available countrywide.

Course summary

PHP Web Development

On this hands-on PHP course you will learn to build a database driven website. You will learn the basics of PHP, SQL (a language used to query a database) and MySQL.

3 Days | $1495.00

Book this course

View class timetable View past student reviews

What's Included

Certificate of Course Completion
Training Manual
FREE Class Repeat

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 Principle
    • 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 Database
    • 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.

Timetable

Chicago

230 W Monroe St
#610
Chicago
IL 60606View Map

Guaranteed to Run Limited Seats Left

Class times: 9.00am to 4.30pm

Servicing Arlington Heights, Aurora, Bollingbrook, Chicago Loop,
Deerfield, Des Plaines, Evanston, Highland Park, Joliet, Naperville,
Schaumburg, Skokie, South Chicago and surrounding areas.

Other Cities

Request onsite training quote

Los Angeles

915 Wilshire Blvd
#1800
Los Angeles
CA 90017View Map

Guaranteed to Run Limited Seats Left

Class times: 9.00am to 4.30pm

Servicing Anaheim, Burbank, Covina, Downtown, Fullerton,
Irvine, Long Beach, Northridge, Pasadena, San Bernardino,
Santa Monica, Van Nuys, Ventura and surrounding areas.

Choosing the right class

Recent student feedback

5.0 stars Chris was able to take a project that I am working on and use it as the model for teaching the entire class, while at the same time hitting on all of the appropriate course material. It was an awesome experience.
4.9 stars 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
5.0 stars 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!
4.6 stars 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.

How to Register

Register here

Why train with us?

4.7 / 5

based on 170 reviews

Need Group training quotation? Fresh Starbucks brewed every day FREE Class Repeat with each course
# # # # # # # # # # # # # # # # #