PHP and MySQL Training

PHP and MySQL Training

4.8 out of 5 - Read Testimonials
Course Length: 5 days
Delivery Methods: Available as private class only
Course Overview

In this PHP training course, students will learn to create database-driven websites using PHP and MySQL or the database of their choice. The class also covers SQL basics. It is taught at a much faster pace than our Introduction to PHP course, because it covers more content. Some of the exercises may be converted to demos, so students might get less hands-on time to make sure all the content can be covered.

If you have the time and resources, taking our 2-day Introduction to SQL with MySQL course followed by our Introduction to PHP course would be a better option.

Course Benefits
  • Learn how PHP works.
  • Learn the basic syntax of PHP.
  • Learn to create dynamic interactive pages with PHP.
  • Learn to manipulate files with PHP.
  • Learn to work with arrays in PHP.
  • Learn to validate forms with PHP.
  • Learn to write functions in PHP.
  • Learn to manipulate and manage database data with PHP.
  • Learn to authenticate users with PHP.
  • Learn to manage sessions with PHP.
  • Learn to work with the MDB2 package.
  • Learn advanced form validation with regular expressions.
  • Learn to send email with PHP.
  • Understand how MySQL works.
  • Learn to use SQL to output reports with MySQL.
  • Learn to modify MySQL data with SQL.
Course Outline
  1. Relational Database Basics
    1. Brief History of SQL
    2. Relational Databases
    3. Tables
      1. Rows
      2. Columns
      3. Relationships
      4. Datatypes
      5. Primary Keys
      6. Foreign Keys
      7. Relational Database Management System
    4. Popular Databases
      1. Commercial Databases
      2. Popular Open Source Databases
    5. SQL Statements
      1. Database Manipulation Language (DML)
      2. Database Definition Language (DDL)
      3. Database Control Language (DCL)
  2. Simple SELECTs
    1. Introduction to the Northwind Database
    2. Some Basics
      1. Comments
      2. Whitespace and Semi-colons
      3. Case Sensitivity
    3. SELECTing All Columns in All Rows
    4. SELECTing Specific Columns
    5. Sorting Records
      1. Sorting by a Single Column
      2. Sorting By Multiple Columns
    6. Ascending and Descending Sorts
    7. The WHERE Clause and Logical Operator Symbols
      1. Checking for Equality
      2. Checking for Inequality
    8. Checking for Greater or Less Than
    9. Checking for NULL
    10. WHERE and ORDER BY
    11. Checking Multiple Conditions with Boolean Operators
      1. AND
      2. OR
      3. Order of Evaluation
    12. The WHERE Clause and Logical Operator Keywords
      1. The BETWEEN Operator
      2. The IN Operator
      3. The LIKE Operator
      4. The NOT Operator
  3. Advanced SELECTs
    1. Calculated Fields
      1. Concatenation
      2. Mathematical Calculations
      3. Aliases
    2. Aggregate Functions and Grouping
      1. Aggregate Functions
      2. Grouping Data
    3. Selecting Distinct Records
    4. Built-in Data Manipulation Functions
      1. Common Math Functions
      2. Common String Functions
      3. Common Date Functions
  4. Subqueries, Joins and Unions
    1. Subqueries
    2. Joins
      1. Table Aliases
      2. Multi-table Joins
    3. Outer Joins
    4. Unions
      1. UNION ALL
      2. UNION Rules
  5. PHP Basics
    1. Welcome to the Server-side
    2. Adding PHP Files to VS Code Workspace
    3. Google Chrome DevTools: Network Tab
    4. Review of DevTools Network Tab
    5. How PHP Works
    6. PHP Functions
    7. php.net
    8. Using php.net
    9. Variables
    10. Preparing to Write Your First PHP Code - Part 1
    11. Preparing to Write Your First PHP Code - Part 2
    12. Preparing to Write Your First PHP Code - Part 3
    13. First PHP Script
    14. Variable Scope
    15. Single Quotes vs. Double Quotes
    16. Concatenation
    17. Passing Variables on the URL
    18. User-defined Functions (UDFs)
    19. Local and Global Variables
    20. Passing Arguments by Value vs. by Reference
    21. Introduction to the Poet Tree Club
    22. Including Files
    23. Using Header and Footer Includes
    24. Constants
    25. Error Reporting
    26. Displaying Errors
    27. Including a Secure Configuration File
    28. Comments
    29. PHP Statements and Whitespace
  6. PHP Conditionals
    1. if / if - else / if - elseif - else
    2. Introduction to Conditionals
    3. False Equivalents: Falsy Values
    4. Testing for Variable Existence
    5. switch/case
    6. Ternary Operator
    7. The Ternary Operator
    8. Null Coalescing Operator
  7. Arithmetic Operators and Loops
    1. Arithmetic Operators
    2. The Modulus Operator
    3. Loops
    4. Modulus and Loops
  8. Arrays
    1. Indexed Arrays
    2. Working with Indexed Arrays
    3. Associative Arrays
    4. Superglobal Arrays
    5. Multi-dimensional Arrays
    6. Array Manipulation Functions
    7. in_array() Function
  9. Working with Databases
    1. Objects
    2. Attributes / Properties
    3. Behaviors / Methods
    4. Classes vs. Objects
    5. Connecting to a Database with PDO
    6. Introducing the Poetree Database
    7. phpMyAdmin
    8. Querying Records with PHP
    9. Queries Returning Multiple Rows
    10. Adding Pagination
    11. Sorting
    12. Anticipating Foul Play
    13. Filtering
  10. Exception Handling
    1. Uncaught Exceptions
    2. Throwing Your Own Exceptions
    3. Catching Exceptions
    4. Exceptions
    5. Division Form
    6. PDOExceptions
    7. Logging Errors
    8. The dbConnect() Function
    9. When Queries Fail to Execute
    10. Preparing for the Catching Errors Exercise
    11. Catching Errors in the PHP Poetry Website
  11. PHP and HTML Forms
    1. Form Submissions
    2. Sanitizing Form Data
    3. Validating Form Data
    4. Processing Form Input: Trimming
    5. Processing Form Input: Filtering
    6. Processing Form Input: Validating Fields
    7. Processing Form Input: Submission Response
    8. Processing Form Input: Remembering Form Entries
  12. Sending Email with PHP
    1. mail()
    2. Setting Up PHPMailer
    3. Mail Server
    4. Including a Mail Configuration File
    5. Sending Email with PHPMailer
    6. PHPMailer Methods and Properties
    7. Creating a Contact Form
  13. Authentication with PHP and SQL
    1. The Registration Process
    2. Passwords and Pass Phrases
    3. Registration with Tokens
    4. Creating a Registration Form
    5. Sessions
    6. Cookies
    7. Logging In and Out
    8. $_REQUEST Variables
    9. Resetting the Pass Phrase Introduction
  14. LAB: Inserting, Updating, and Deleting Poems
    1. Submitting a New Poem
    2. Showing All User’s Poems in on the Poems Page
    3. Editing an Existing Poem
    4. Deleting a Poem
  15. Uploading Files
    1. Enabling File Info Functions on Windows
    2. Uploading Images via an HTML Form
    3. Resizing Images
    4. Uploading a Profile Picture
    5. Uploading Files
  16. Admin Site
    1. Adding the Admin Pages
    2. Creating the isAdmin() Function
    3. Completing the Admin Home Page
    4. Completing the Admin Poems Page
    5. Approving, Editing, and Deleting Poems
    6. Completing the Admin Users Page
    7. Make the My Account Page Spoofable
Class Materials

Each student will receive a comprehensive set of materials, including course notes and all the class examples.

Class Prerequisites

Experience in the following is required for this PHP class:

  • HTML

Experience in the following would be useful for this PHP class:

  • CSS
  • Basic Programming
  • XML
Request a Private Class
  • Private Class for your Team
  • Online or On-location
  • Customizable
  • Expert Instructors
Request Pricing