MySQL and PHP - Developing Dynamic Web Applications

• Do you want to learn how to use both MySQL and PHP effectively?
• Have you heard about LAMP and wonder what the fuss is all about?
• Do you want understand the foundational steps to create large web applications using MySQL and PHP?

Then the MySQL and PHP - Developing Dynamic Web Applications is the class for you! An Authorized MySQL instructor will teach you how to develop applications in PHP and how to use MySQL efficiently for those applications!

Through a hands-on approach, this instructor-led course will help you add to your knowledge the skills to combine PHP and MySQL with time-proven database management techniques to create best-of-breed web applications that are efficient, solid and secure.

Objectives

At completion of this course, you should be able to:

• Describe the LAMP architecture
• Utilize the basic components of PHP to build a foundation for more complex web applications
• Understand the basic components of MySQL to build a foundation for the development of fully dynamic and database-driven sites
• Utilize SQL query commands to retrieve data from the MySQL Database
• Manipulate table data using the SQL Data Manipulation Language (DML) commands
• Retrieve data from multiple MySQL tables using Joins
• Create web based forms that interact with the end user and the data within MySQL
• Utilize session handling within PHP to track user-specific behavior and preferences.
• Authenticate user identities utilizing PHP built-in authentication capabilities
• Describe the purpose of template systems
• Explain version control techniques and systems
• Communicate the stages in the deployment process of an application

Prerequisites

This class is suitable for web developers with HTML experience and experience with some other programming language.

Format

• Instructor led, with hands-on lab exercises
• Each student will be provided with their own computer

Applies to MySQL Version

4.1, 5.0, 5.1

Duration

4 days

Upcoming Sessions