• GSA SCHEDULE
Call 877-932-8228
for GSA Pricing.
GS-35F-0556S
• CLIENT LOCATIONS
Scottsdale, AZ
Phoenix, AZ
Los Angeles, CA
Sacramento, CA
San Diego, CA
San Francisco, CA
San Jose, CA
Santa Clara, CA
Milpitas, CA
Colorado Springs, CO
Denver, CO
Hartford, CT
Washington, DC
Jacksonville, FL
Atlanta, GA
Chicago, IL
Indianapolis, IN
Muncie, IN
Boston, MA
Cambridge, MA
Baltimore, MD
Ann Arbor, MI
Detroit, MI
St. Louis, MO
Charlotte, NC
Winston-Salem, NC
Lincoln, NE
Madison, NJ
Princeton, NJ
Trenton, NJ
Albany, NY
Buffalo, NY
Rochester, NY
New York City, NY
Syracuse, NY
Las Vegas, NV
Cleveland, OH
Columbus, OH
Dayton, OH
Oklahoma City, OK
Portland, OR
Philadelphia, PA
Pittsburgh, PA
Rapid City, SD
Memphis, TN
Nashville, TN
Austin, TX
Dallas, TX
Fort Worth, TX
Houston, TX
San Antonio, TX
Arlington, VA
Virginia Beach, VA
Seattle, WA
Milwaukee, WI
Toronto, Canada
◊ ONLINE PHP AND MYSQL TRAINING
Save money by buying series in packages. This course series is included with the following package:
Packages include 24/7 access to subject matter experts.
Of course, you can buy this PHP and MySQL series individually as well. Just click on the "Register Now" button below.
Overview |
Catalog |
Benefits |
FAQs |
Try Free Course |
Buy |
Log in |
Support
Online PHP and MySQL Training
Only $99.95
12-month subscription
This series teaches learners to create dynamic Web sites. Learners will be able to apply their knowledge to the creation of dynamic Web applications such as content management, user registration, and e-commerce.
PHP and MySQL Series (43 hours)
ONLINE PHP and MySQL TRAINING FEATURES
- Learn PHP and MySQL online with these interactive online PHP and MySQL courses.
- Affordable Pricing (Only $99.95 for the complete series)
- A full year to complete the PHP and MySQL courses
- Retake the PHP and MySQL courses as many times as you like
- Measure your progress with assessment tests after each course
- Earn completion certificates after passing each assessment test
1. Installing Required Software
Time: 2 hours
After taking this course, the learner will be able to download, install, configure, and test all the software required to create dynamic Web sites using PHP and MySQL.
Objectives
- To install and configure MySQL
- To install and configure Apache with PHP
- To create MySQL users and grant privileges
- To test PHP and MySQL installations
- To configure PHP
Topics
- Installing MySQL
- Installing Apache with PHP
- Setting MySQL permissions
- Testing the installation
- Configuring PHP
2. PHP Basics
Time: 3 hours
After taking this course, the learner will be able to describe the PHP scripting language, and create basic PHP scripts using proper PHP syntax.
Objectives
- Identify basic PHP syntax
- Create basic PHP scripts
- Send data to the Web browser
- Apply variables, strings, and constants to a PHP a script
Topics
- PHP
- Basic syntax
- Sending data
- Understanding PHP, HTML, and white space
- Writing comments
- Using variables
- Using strings
- Using numbers
- Using constants
3. Programming with PHP
Time: 4 hours
After taking this course, the learner will be able to create elaborate scripts, write HTML forms, and program PHP to handle the form data.
Objectives
- Handle HTML forms using PHP scripts
- Validate form data
- Manage arrays using various types of loops
- Work with magic quotes
Topics
- Creating HTML forms
- Handling HTML forms
- Managing magic quotes
- Using conditionals and operators
- Validating form data
- Using arrays
- Creating and accessing arrays
- Multidimensional arrays
- Arrays and strings
- Sorting arrays
- For and While loops
4. Creating Dynamic Web Sites
Time: 3 hours
This course provides the learner with step-by-step instructions for using PHP to create dynamic Web sites that are responsive to users and can alter content based on differing situations.
Objectives
- Create PHP scripts using multiple files
- Display and handle HTML forms within a single PHP script
- Create and call functions
- Create functions that take arguments and return values
- Set and alter variable scope
- Send email from a PHP script
Topics
- Including multiple files
- Using PHP redux
- Making sticky forms
- Creating your own functions
- Creating a function that takes arguments
- Setting default argument values
- Returning values from a function
- Variable scope
- Date and time functions
5. SQL and MySQL
Time: 4 hours
After taking this course, the learner will be able to create databases and tables, and sort and retrieve data using SQL and MySQL.
Objectives
- Choose column types and other column properties
- Create databases and tables
- Insert records, select, update and delete data
- Use conditionals and functions
Topics
- MySQL
- Choosing column types
- Choosing other column properties
- Using mysql client
- Creating databases and tables
- Inserting records
- Selecting data
- Using conditionals
- Using LIKE and NOT LIKE
- Sorting and limiting query results
- Updating and deleting data
- Using text and numeric functions
- Formatting date and time functions
6. Advanced SQL and MySQL
Time: 3 hours
After taking this course, the learner will be able to use the principles of database design, including normalization and use of forms. They will also be able to use MySQL to create relational databases, and perform searches on those databases.
Objectives
- Normalize a database into First, Second and Third Normal Forms
- Create and populate a database in MySQL
- Search a database using joins, groupings, and FULLTEXT searches
- Change the search engine type of a table
- Create indexes to improve the ability to search a database
Topics
- Normalization, keys, and relationships
- First Normal Form
- Second Normal Form
- Third Normal Form
- Creating and populating the database
- Performing joins
- Grouping selected results
- Creating indexes
- Using different table types
- Performing basic FULLTEXT searches
- Performing Boolean FULLTEXT searches
- Optimizing the database
7. Error Handling and Debugging
Time: 2 hours
This course provides the learner with the steps and tools necessary to identify and correct errors that can occur when running PHP and MySQL applications.
Objectives
- Identify error types
- View, log, and debug errors
- Adjust PHP's error reporting
- Create custom error handlers
Topics
- General error types and debugging
- Debugging HTML
- Displaying PHP errors
- Adjusting PHP error reporting
- Creating custom error handlers
- Logging PHP errors
- PHP debugging techniques
- SQL and MySQL debugging techniques
8. Using PHP with MySQL
Time: 2 hours
This course provides the learner with step-by-step instructions for using PHP to create dynamic Web sites that allow for database interactions such as the storing, gathering, and updating of information.
Objectives
- Describe how arguments and PHP functions relate to the database
- Differentiate between simple and complex functions depending on execution results
- Understand the importance of associative and indexed arrays.
- Modify specific scripts to allow for secure data transmission
- Update database records using PHP scripts
Topics
- Modifying the template
- Connecting to MySQL and selecting the database
- Executing simple queries
- Retrieving query results
- Ensuring secure SQL
- Counting returned records
- Updating records with PHP
9. Developing Web Applications
Time: 2 hours
This course provides the learner with information about a number of independent topics that are present in more sophisticated Web applications.
Objectives
- Adjust behavior for server settings
- Pass variables and values to a script
- Edit existing records
- Paginate query results
- Make sortable displays
- Use HTTP headers
Topics
- Adjusting behavior for server settings
- Sending values manually
- Using hidden form inputs
- Editing existing records
- Paginating query results
- Making sortable displays
- Understanding HTTP headers
10. Cookies and Sessions
Time: 3 hours
This course provides the learner with information about using cookies and sessions with PHP to overcome the statelessness of the Web.
Objectives
- Use cookies
- Use sessions
- Improve session security
- Manage the relationship between cookies and sessions
Topics
- Setting cookies
- Accessing cookies
- Setting cookie parameters
- Deleting cookies
- Setting session variables
- Accessing session variables
- Deleting session variables
- Changing session behavior
- Changing the session cookie settings
- Using sessions without cookies
- Improving session security
11. Web Application Security
Time: 3 hours
In this course, the learner will become familiar with methods for increasing the security of their web applications using PHP and MySQL. These techniques include methods of form validation, the ability to define patterns and then matching or replacing those patterns, and data encryption.
Objectives
- Prevent forms from being submitted multiple times
- Validate form data
- Define patterns and both match and replace them
- Manage database encryption and decryption techniques
Topics
- Preventing multiple submissions
- Validating the right form
- Handling HTML
- Validating data
- JavaScript form validation
- Defining a pattern with regular expressions
- Matching regular expression patterns
- Matching and replacing patterns
- Database security and encryption
- Secure salt storage
12. Extended Topics
Time: 4 hours
This course covers extended PHP topics that are worth considering in your development work, but not related to every Web application.
Objectives
- Upload a file in PHP
- Develop JavaScript using PHP
- Utilize output buffering
- Identify Improved MySQL Extension functions
- Describe the purpose of PEAR
Topics
- Handling File Uploads
- Uploading PHP Files Creating Java
- Script Using Output Buffering Using the Improved MySQL Extension
- New MySQL Features
- Using Prepared Statements
- Using PEAR
13. Content Management Example
Time: 2 hours
After taking this course, the learner will become familiar with the foundational information required to build a sample content management site through PHP interactions using a database.
Objectives
- Create the advanced PHP scripts needed for a content management site
- Update and add information with a database
- Download files through PHP scripts and database interactions
- Manage files through PHP scripts and database interactions
Topics
- Creating the template
- Creating the basic pages
- Managing URLs
- The list() function
- The serialize() and urlencode() functions
- Managing files
- Viewing and downloading files
14. User Registration Example
Time: 3 hours
This course provides an overview of the user registration system.
Objectives
- Handle user registration
- Activate accounts
- Create login and logout scripts
- Apply password management
Topics
- Creating the templates
- Writing the configuration scripts
- Creating the home page
- Registration
- Activating an account
- Logging in and logging out
- Resetting a password
- Changing a password
15. E-Commerce Example
Time: 3 hours
After taking this course, the learner will have the information and sample needed to create an e-commerce site using PHP and MySQL, including creating the database, creating the public and administrative pages, and managing the shopping cart.
Objectives
- Create a database for an e-commerce site
- Create the administrative pages for an e-commerce site
- Create pages for a customer to browse the inventory and place orders from an e-commerce site
- Create and manage an online shopping cart for your e-commerce site
Topics
- Creating the database
- The administration side
- Creating the public template
- The product catalog
- The shopping cart
- Recording the orders
