PHP and MySQL

This course shows you how to create dynamic websites using PHP and MySQL. You'll be able to apply your knowledge to the creation of dynamic web applications such as content management, user registration, and e-commerce.

You'll learn how to:

• download, install, configure, and test all the software required to create dynamic websites using PHP and MySQL
• create elaborate scripts, write HTML forms, and program PHP to handle the form data
• create databases and tables, and sort and retrieve data using SQL and MySQL
• use the principles of database design, including normalisation and use of forms and use MySQL to create relational database
• identify and correct errors that can occur when running PHP and MySQL applications
• create dynamic websites that allow for database interactions such as the storing, gathering, and updating of information
• manage database encryption and decryption techniques
• create an e-commerce site using PHP and MySQL, including creating the database, creating the public and administrative pages, and managing the shopping cart

Modules:

There are 15 modules in this course

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

Course features:

• Flash and audio provide animated, interactive lesson introductions, activities, and simulations.
• Simulations teach you to perform specific tasks in applications through guided, multi-step exercises.
• Decision Point activities allow you to apply course concepts in an interactive questioning environment.
• Exercises allow you to practise in the actual application you're studying.
• Supplied sample files include sample documents, application files, programs, and programming code that enable you to practise with these files, enhancing your learning experience.
• MindNotes provide printable quick-reference sheets and other files you can use to apply your skills on the job.
• A Course Topics list contains active hyperlinks, giving you quick access to specific topics.
• Find-A-Word helps you to look up an unfamiliar term in the Glossary, on the web, or in a dictionary. You can also find other occurrences of the term in the same course.
• Search text lets you rapidly search all text within a course to easily retrieve information you're looking for.
• Variety of question formats, including multi-step simulations, true/false, multiple choice, and fill-in-the-blank.
• A skill assessment generates a customised learning path based on the results of your pre-test.
• A glossary provides a reference for definitions of unfamiliar terms.
• Bookmarking tracks your progress in a course.

You'll have access to this course for six months from the date of purchase - giving you plenty of time to finish your course.

How this course can help your business:

• Create professional graphics and design for your website
• Express your brand identity creatively
• Save time and money by bringing design and web-building tasks in-house

Course Code: 104266BT051