PHP 201 – PHP-Advanced PHP and MYSQL

Class Description
This 2-day hands-on training class is designed to cover the more advanced PHP and MySQL features that will enable Participants to build powerful database-driven Web applications.  Participants learn how to connect PHP to a MySQL database, and gain experience developing a complete web application with site navigation, form validation, and a password-protected admin area.

Course Benefits

  • Connecting to MySQL
  • SQL Select – Subqueries, Joins, and Unions
  • Inserting, Updating, and Deleting Records
  • Regular Expressions
  • Session Control and Cookies
  • Sending Email and File System Management

Suggested Prerequisites
Knowledge of your operating system and basic computer navigation is required for all classes.

Course Outline

  • Introduction to the Northwind Database
  • The WHERE Clause and Operator Symbols
  • Inserting, Updating, and Deleting Records
  • Subqueries, Joins and Unions
  • Table Aliases
  • mysqli Methods and Properties
  • Inserting, Updating and Deleting Records
  • Perl-compatible Regular Expression
  • Configuring Sessions
  • File System Management

Related Classes

Our goal is to make sure your class meets your objectives, not ours. Therefore, all of our outlines are treated as guides to help steer the workshop. This outline does not guarantee that all the topics listed will be covered in the time allowed. The amount of material covered is based on the skill level of the student audience. We may change or alter course topics to best suit the classroom situation.