PHP MySQL Training Course

PHP MySQL Training: Course Description

Maryland, Virginia, Washington DC, Virtually Online Live & On-Site

Course Overview:

This PHP MySQL training course provides you with hands-on practice using PHP with MySQL scripting language for web developers. Web developers will learn the fundamentals of PHP, its data types, control structure, operators and arrays.
• Programming best practices and strategies for development in PHP/MySQL
• Techniques to develop in the PHP language and syntax
• Design and plan relational databases for implementing and managing production
• Interaction with MySQL, SQL and other relational databases
• Learn how PHP sessions and cookies are used to develop web applications
• Understand steps for re-using code utilizing ‘functions’ and ‘includes’
• Acquire an understanding of PHP’s operability for building secure, efficient databases to include best practices on the use of references, global variables and range of projects.

Locations for PHP MySQL:

In Person at ThinkB!G’s Office in Columbia, MD (next to the Columbia Mall)
Online Live from Anywhere
Private Custom Training On Site or at Your Location
Project Based Training On Site or at Your Location

Times for PHP MySQL:

In Person & Online Live: 8:30AM-3:00PM ET / 5:30AM-12:00PM PT (30 Minute Lunch)
Private Custom & Project Based Training: Your preference
*Please click the Dates To Register tab above to see all dates & times available.*

Prerequisites for Attending PHP MySQL Training Course:

We recommended that students have a working understanding of coding in HTML, web form layout, SQL and relational database programming. Students must have a good working knowledge of computers, operating systems, using a mouse, keyboard, standard menus and commands. Students must be able to open, save, and close applications, files, as well as navigate to other folders.

Job Roles That Use PHP MySQL:

Web Developers
PHP Developers

Projects That Use PHP MySQL:

Designing Applications
Creating Dynamic Web pages

 

PHP MySQL Training Includes:

Hands-On Training Led by Certified Instructors
Print and/or Digital Courseware
Certificate of Completion
Continental Breakfast Every Day (In Person Only)
Catered Gourmet Deli Lunch Every Day (In Person Only)
Unlimited Snacks and Refreshments (In Person Only)
Notebook & Pen (In Person Only)
Free Parking (In Person Only)

Software Versions:

ThinkB!G open enrollment classes are taught on the most current version of software whenever possible. To request a specific version, please Contact Us or call us at 301-362-2250.

Related Training and Certification Courses:

 

PHP MySQL Training: Course Outline

1. Introduction to PHP
Basic Syntax
Sending Data to the Web Browser
Writing Comments
What Are Variables?
Introducing Strings
Concatenating Strings
Introducing Numbers
Introducing Constants
Single vs. Double Quotation Marks
Basic Debugging Steps
Review and Pursue

2. Programming with PHP
Creating an HTML Form
Handling an HTML Form
Conditionals and Operators
Validating Form Data
Introducing Arrays
For and While Loops
Review and Pursue

3. Creating Dynamic Web Sites
Including Multiple Files
Handling HTML Forms, Revisited
Making Sticky Forms
Creating Your Own Functions
Review and Pursue

4. Introduction to MySQL
Naming Database Elements
Choosing Your Column Types
Choosing Other Column Properties
Accessing MySQL
Review and Pursue

5. Introduction to SQL
Creating Databases and Tables
Inserting Records
Selecting Data
Using Conditionals
Using LIKE and NOT LIKE
Sorting Query Results
Limiting Query Results
Updating Data
Deleting Data
Using Functions
Review and Pursue

6. Database Design
Normalization
Creating Indexes
Using Different Table Types
Languages and MySQL
Time Zones and MySQL
Foreign Key Constraints
Review and Pursue

7. Advanced SQL and MySQL
Performing Joins
Grouping Selected Results
Advanced Selections
Performing FULLTEXT Searches
Optimizing Queries
Performing Transactions
Database Encryption
Review and Pursue

8. Error Handling and Debugging
Error Types and Basic Debugging
Displaying PHP Errors
Adjusting Error Reporting in PHP
Creating Custom Error Handlers
PHP Debugging Techniques
SQL and MySQL Debugging Techniques
Review and Pursue

9. Using PHP with MySQL
Modifying the Template
Connecting to MySQL
Executing Simple Queries
Retrieving Query Results
Ensuring Secure SQL
Counting Returned Records
Updating Records with PHP
Review and Pursue

10. Common Programming Techniques
Sending Values to a Script
Using Hidden Form Inputs
Editing Existing Records
Paginating Query Results
Making Sortable Displays
Review and Pursue

11. Web Application Development
Sending Email
Handling File Uploads
PHP and JavaScript
Understanding HTTP Headers
Date and Time Functions
Review and Pursue

12. Cookies and Sessions
Making a Login Page
Defining the Login Functions
Using Cookies
Using Sessions
Improving Session Security
Review and Pursue

13. Security Methods
Preventing Spam
Validating Data by Type
Validating Files by Type
Preventing XSS Attacks
Using the Filter Extension
Preventing SQL Injection Attacks
Review and Pursue

14. Perl-compatible Regular Expressions
Creating a Test Script
Defining Simple Patterns
Using Quantifiers
Using Character Classes
Finding All Matches
Using Modifiers
Matching and Replacing Patterns
Review and Pursue

15. Introducing jQuery
What is jQuery?
Incorporating jQuery
Using jQuery
Selecting Page Elements
Event Handling
DOM Manipulation
Using Ajax
Review and Pursue

16. An OOP Primer
Fundamentals and Syntax
Working with MySQL
The DateTime Class
Review and Pursue

17. Example—Message Board
Making the Database
Writing the Templates
Creating the Index Page
Creating the Forum Page
Creating the Thread Page
Posting Messages
Review and Pursue

18. Example—User Registration
Creating the Templates
Writing the Configuration Scripts
Creating the Home Page
Registration
Activating an Account
Logging In and Logging Out
Password Management
Review and Pursue

19. Example—E-Commerce
Creating the Database
The Administrative Side
Creating the Public Template
The Product Catalog
The Shopping Cart
Recording the Orders
Review and Pursue

Disclaimer:
All course objectives and outlines are a guide for students. To ensure student satisfaction, these course topics and order may be modified or added to ensure the latest information is covered to support real world use of the technology.

We have instructors ready to teach this class, but we do not currently offer it on our open enrollment schedule. If you are interested in this class, please fill out the form below and we will contact you shortly about your training options!