Get Schedule and Pricing Other Open Source PHP training courses
2670

Open Source PHP-Advanced PHP and MYSQL Training Course

PHP-Advanced PHP and MYSQL Training Schedule

Training Course Synopsis

PHP has gained a following among non-technical web designers who need to add interactive aspects to their sites. Offering a gentle learning curve, PHP is an accessible yet powerful language for creating dynamic web pages. This two day hands-on training class is designed to cover the more advanced PHP and MySQL features that will enable you to build powerful database-driven Web applications.

Training Course Length and Time

This class is 2 days long. Class time is 9:00 a.m.- 4:00 p.m. Breaks are scheduled throughout the day and lunch is typically scheduled 12-1. Students provide their own lunch.

What You Will Learn in This Training Course

  • 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

Who Should Attend this Training Course

Web professionals who need to develop dynamic web content through data driven pages, using PHP. Experienced users will also benefit from the many tips and tricks, and special exercises.

Enrollment

Please see our Enrollment Page (http://www.ledet.com/enroll) for our enrollment form.

Locations for this Training Course

We have training centers in Atlanta, Houston, Chicago, Denver, San Diego and Washington DC. We also offer classes at a network of rental facilities. We offer private onsite training and instructor-led, live online training. If coming to a rental facility, please double-check the location of your class with our office to make sure you get to the right location.

Prerequisites for this Training Course

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

Goals for this Training Course

Sterling Ledet and Associates realizes the importance of education and we take pride in being able to offer you classes that are more custom fit to your needs. Call us at (877) 819-2665 if you have any special questions or e-mail us at sales@ledet.com.

Lesson 1

  • Introduction MySQL
  • Simple Select
  • Introduction to the Northwind Database
  • Comments
  • Whitespace and Semi-colons
  • Case Sensitivity
  • SELECTing All Columns in All Rows
  • SELECTing Specific Columns
  • Sorting Records
  • Sorting By a Single Column
  • Sorting By Multiple Columns
  • Sorting By Column Position
  • Ascending and Descending Sorts
  • The WHERE Clause and Operator Symbols
  • Checking for Equality
  • Checking for Inequality
  • Checking for Greater or Less Than
  • Checking for NULL
  • WHERE and ORDER BY
  • The WHERE Clause and Operator Words
  • The BETWEEN Operator
  • The IN Operator
  • The LIKE Operator
  • The NOT Operator
  • Checking Multiple Conditions
  • AND, OR, Order of Evaluation

Lesson 2

  • Subqueries, Joins and Unions
  • Table Aliases
  • Multi-table Joins
  • Table Aliases
  • Outer Joins
  • UNION ALL
  • UNION Rules

Lesson 3

  • Inserting, Updating and Deleting Records
  • INSERT, UPDATE, and DELETE
  • Managing Data
  • Querying a Database
  • mysqli() Overview
  • mysqli Methods and Properties
  • Inserting and Updating Records
  • mysqli Prepared Statements
  • mysqli() Overview
  • mysqli Methods and Properties
  • Inserting and Updating Records
  • mysqli Prepared Statements

Lesson 4

  • Regular Expressions
  • Perl-compatible Regular Expression
  • Functions
  • preg_match()
  • preg_replace()
  • Regular Expression Tester
  • Regular Expression Syntax
  • Form Validation Functions with Regular
  • Expressions

Lesson 5

  • Session Control and Cookies
  • Configuring Sessions
  • Session Functions
  • Sending Email with PHP
  • mail()
  • Shortcomings of mail()
  • PHPMailer

Lesson 6

  • File System Management
  • Opening a File
  • fopen()
  • Reading from a File
  • fgets()
  • Writing to a File
  • fwrite()
  • File Locking
  • flock()
  • Uploading Files via an HTML Form
  • Getting File Information
  • More File Functions
  • Directory Functions
  • Getting a Directory Listing

Disclaimer

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.

Upcoming Classes

Call to schedule