PHP and MySQL

Topics: 15

Length: 43 hours

Location: Online

This course will show you how to create dynamic Web sites. After this course you will be able to apply your new knowledge to creating of dynamic Web applications including content management, user registration, and e-commerce.

Topic 1 Installing Required Software

This course teaches the student how to download, install, configure, and test all the software required to create dynamic Web sites using PHP and MySQL.

Topic 2 PHP Basics

The series of tutorials on this course covers the basics of PHP scripting language. It teaches the student how to describe the language and create basic PHP scripts using the correct PHP syntax.

Topic 3 Programming with PHP

This tutorial course teaches the student how to create elaborate scripts, write HTML forms, and program PHP to handle the form data.

Topic 4 Creating Dynamic Web Sites

This course of tutorials gives the student step-by-step instructions for using PHP to create dynamic, responsive Web sites with content that can adapt and change.

Topic 5 SQL and MySQL

A series of tutorials teaching the student how to create databases and tables, including sorting and retrieving data using SQL and MySQL.

Topic 6 Advanced SQL and MySQL

This course teaches the principles of database design, including normalization and use of forms. Tutorials will teach students how to create relational databases using MySQL and how to search a database.

Topic 7 Error Handling and Debugging

This is a series of tutorials on how to identify and correct the errors that can occur when running PHP and MySQL applications.

Topic 8 Using PHP with MySQL

A course of tutorials providing 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.

Topic 9 Developing Web Applications

A series of tutorials covering more sophisticated Web applications including using hidden form inputs, understanding HTTP headings and paginating query results.

Topic10 Cookies and Sessions

A course of tutorials examining ways of overcoming the statelessness of the Web including the use of cookies and PHP sessions.

Topic11 Web Application Security

A tutorial course examining ways of increasing security for Web applications using PHP and MySQL. Techniques include methods of form validation, defining, matching and replacing patterns and data encryption.

Topic12 Extended Topics

This course covers extended PHP topics for developing students' futher knowledge. The tutorials will give the student knowledge that is not necessarily related to every Web application.

Topic13 Content Management Example

A series of tutorials teaching the student how to build a sample content management site using a database through PHP interactions.

Topic14 User Registration Example

This course provides an overview of the user registration system.

Topic15 E-Commerce Example

A course of tutorials on building an effective e-commerce site. The seminars cover the use of PHP and MySQL, creating the database and the public and administrative pages, and managing the shopping cart.