computer training image
Online Training Classes Purchased Securely
Shopping cart  Shopping cart
0 Product(s) in cart
Total $0.00
> Checkout
Online Payments

Benefits of Computer Coach's online computer training classes

  • Accessible 24 hours a day 7 days a week, so you can learn when you have time.
  • Cost-effective solutions, so you don’t go broke learning the skills you need.
  • Available Anytime, anywhere with an Internet connection, so you can study at your house, office, or where you feel comfortable.
  • Interactive & fun courses allow for greater retention of course topics.
  • Easy to use so you can start learning right away.
  • Full of hands-on labs so you can get the practice you need
  • HTML Based so you don’t need any additional downloads
  • Live Mentor Available to ask questions and get clarification

online computer training questions answered

PHP and MySQL Online Course

12 Month Subscription - $70
Live Mentor +$30

Summary:
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.

Audience:
This course is for anyone who would like to create dynamic Web sites using PHP and MySQL.

Features:
●  Flash and audio provide animated, interactive Lesson Introductions, Activities, and Simulations.
●  Activities allow learners to apply course concepts in an interactive questioning environment.
●  Bookmarking tracks a learner's progress in a course.
●  Exercises allow learners to practice in the actual application being studied.
●  A glossary provides a reference for definitions of unfamiliar terms.
●  Courses challenge the learner with a variety of question formats, including multi-step simulations, true/false, multiple choice, and fill-in-the-blank.
●  Simulations teach learners to perform specific tasks in applications through guided, multi-step exercises.
●  A skill assessment generates a customized learning path based on the results of a pre-test.
●  Supplied sample files include sample documents, application files, programs, and programming code that enable learners to practice with these files, enhancing the learning experience.

Topics included in this course:
PHP and MySQL : Installing Required Software
PHP and MySQL : PHP Basics
PHP and MySQL : Programming with PHP
PHP and MySQL : Creating Dynamic Web Sites
PHP and MySQL : SQL and MySQL
PHP and MySQL : Advanced SQL and MySQL
PHP and MySQL : Error Handling and Debugging
PHP and MySQL : Using PHP with MySQL
PHP and MySQL : Developing Web Applications
PHP and MySQL : Cookies and Sessions
PHP and MySQL : Web Application Security
PHP and MySQL : Extended Topics
PHP and MySQL : Content Management Example
PHP and MySQL : User Registration Example
PHP and MySQL : E-Commerce Example

PHP and MySQL : Installing Required Software
Summary:
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:
After completing this course, students will be able to:
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
top

PHP and MySQL : PHP Basics
Summary:
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:
After completing this course, students will be able to:
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
top

PHP and MySQL : Programming with PHP
Summary:
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:
After completing this course, students will be able to:
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
top

PHP and MySQL : Creating Dynamic Web Sites
Summary:
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:
After completing this course, students will be able to:
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
top

PHP and MySQL : SQL and MySQL
Summary:
After taking this course, the learner will be able to create databases and tables, and sort and retrieve data using SQL and MySQL.

Objectives:
After completing this course, students will be able to:
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
top

PHP and MySQL : Advanced SQL and MySQL
Summary:
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:
After completing this course, students will be able to:
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
top

PHP and MySQL : Error Handling and Debugging
Summary:
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:
After completing this course, students will be able to:
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
top

PHP and MySQL : Using PHP with MySQL
Summary:
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:
After completing this course, students will be able to:
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
top

PHP and MySQL : Developing Web Applications
Summary:
This course provides the learner with information about a number of independent topics that are present in more sophisticated Web applications.

Objectives:
After completing this course, students will be able to:
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
top

PHP and MySQL : Cookies and Sessions
Summary:
This course provides the learner with information about using cookies and sessions with PHP to overcome the statelessness of the Web.

Objectives:
After completing this course, students will be able to:
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
top

PHP and MySQL : Web Application Security
Summary:
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:
After completing this course, students will be able to:
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
top

PHP and MySQL : Extended Topics
Summary:
This course covers extended PHP topics that are worth considering in your development work, but not related to every Web application.

Objectives:
After completing this course, students will be able to:
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
top

PHP and MySQL : Content Management Example
Summary:
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:
After completing this course, students will be able to:
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
top

PHP and MySQL : User Registration Example
Summary:
This course provides an overview of the user registration system.

Objectives:
After completing this course, students will be able to:
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
top

PHP and MySQL : E-Commerce Example
Summary:
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:
After completing this course, students will be able to:
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
top

12 Month Subscription - $70
Live Mentor +$30