Training Center
Computer Training courses online, at your pace !

Computer Training Online


Or call 800 639 0160








PHP and MySQL
Join over 1 million people who learn online, with these complete interactive computer training courses.




See How It Works

This online course includes: Time Needed
Installing Required Software 2 hours
PHP Basics 3 hours
Programming with PHP 4 hours
Creating Dynamic Web Sites 3 hours
SQL and MySQL 4 hours
Advanced SQL and MySQL 3 hours
Error Handling and Debugging 2 hours
Using PHP with MySQL 2 hours
Developing Web Applications 2 hours
Cookies and Sessions 3 hours
Web Application Security 3 hours
Extended Topics 4 hours
Content Management Example 2 hours
User Registration Example 3 hours
E Commerce Example 3 hours
Estimated time needed to complete entire course 43 hours


Receive your login ID to take the training courses online, as many times as you wish, for 1 year.  Click here for group orders.

Buy this entire online training course with one easy payment of $67

OR

Buy the Web Design pack, and receive this course plus many more, for only $197
Bonus: Order a value pack NOW, and receive Free unlimited "Instant Mentoring", real time help, so you can chat online,
            with a support person, as needed (24 hours a day, 7 days a week).  You can ask your mentor to clarify
            concepts, fine tune solutions, confirm a process or simply seek assurance that you understand a topic.



Benefits

  • Unlimited access for 1 year
  • Learn anytime, anywhere
  • You control the pace
  • Start & stop wherever you want
  • No books to read
  • No software needed
  • Value Packs include Free online tech support
  • Double guarantee
  • 100% Money back guarantee
  • One time payment No monthly fee
  • Use the course index for review anytime
  • Answer course questions with at least 70% accuracy and print your own certificates of completion to prove that you have mastered each training course.
  • Free status reports for company managers

Requirements

All you need is a PC with Windows, the Microsoft Internet Explorer (browser) and an Internet connection.
Note: The online computer training is designed to work only with Internet Explorer. 
Prices shown are per user.




What You will Learn

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.




Installing Required Software

  • To install and configure MySQL
  • To install and configure Apache with PHP
  • To test PHP and MySQL installations
  • To create MySQL users and grant privileges
  • To configure PHP




PHP Basics

  • Identify basic PHP syntax
  • Create basic PHP scripts
  • Send data to the Web browser
  • Apply variables, strings, and constants to a PHP a script




Programming with PHP

  • Handle HTML forms using PHP scripts
  • Validate form data
  • Manage arrays using various types of loops
  • Work with magic quotes




Creating Dynamic Web Sites

  • 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




SQL and MySQL

  • Choose column types and other column properties
  • Create databases and tables
  • Insert records, select, update and delete data
  • Use conditionals and functions




Advanced SQL and MySQL

  • Normalize a database into First, Second and Third Normal Forms
  • Create and populate a database in MySQL
  • Change the search engine type of a table
  • Search a database using joins, groupings, and FULLTEXT searches
  • Create indexes to improve the ability to search a database




Error Handling and Debugging

  • Identify error types
  • View, log, and debug errors
  • Adjust PHP's error reporting
  • Create custom error handlers




Using PHP with MySQL

  • Describe how arguments and PHP functions relate to the database
  • Differentiate between simple and complex functions depending on execution results
  • Update database records using PHP scripts
  • Modify specific scripts to allow for secure data transmission
  • Understand the importance of associative and indexed arrays




Developing Web Applications

  • Adjust behavior for server settings
  • Pass variables and values to a script
  • Edit existing records 
  • Paginate query results
  • Make sortable displays
  • Use HTTP headers




Cookies and Sessions

  • Use cookies
  • Use sessions
  • Improve session security
  • Manage the relationship between cookies and sessions




Web Application Security

  • Prevent forms from being submitted multiple times
  • Define patterns and both match and replace them
  • Validate form data 
  • Manage database encryption and decryption techniques




Extended Topics

  • Upload a file in PHP
  • Develop JavaScript using PHP
  • Utilize output buffering
  • Identify Improved MySQL Extension functions
  • Describe the purpose of PEAR




Content Management Example

  • 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




User Registration Example

  • Handle user registration
  • Activate accounts 
  • Create login and logout scripts
  • Apply password management




E Commerce Example

  • Create a database for an e commerce site
  • Create pages for a customer to browse the inventory and place orders from an e commerce site
  • Create the administrative pages for an e commerce site 
  • Create and manage an online shopping cart for your e commerce site





 

 

Copyright © 2007 TrainingCenter.com