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 to create large web applications using MySQL and PHP?

Then Effective Web Development with MySQL and PHP 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 improve your PHP skills and combine them 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:

• Design web-based applications
• Design schemas based on MySQL
• Use include files to make code easier to maintain
• Use PHP 5 and takes advantage of its advanced features
• Build applications following a precise flow
• Authenticate users in a secure way against a database
• Handle errors in your PHP applications efficiently and gracefully
• Writes composite queries using JOINs and subqueries
• Use indexing efficiently in order to manipulate large amounts of data efficiently
• Uses joins to extract data from multiple tables
• Uses GROUP BY clauses and aggregate functions
• Write applications whose components can be scaled to meet increased demand
• Build a complete application that includes authentication and session management
• Understand how PHP, MySQL and the Apache web server work together to deliver dynamic web content

Who should attend?

• Developers who use PHP and MySQL to build and maintain their websites
• Developers who want to learn how PHP and MySQL can be used for the rapid prototyping and deployment of dynamic websites

Prerequisites

This class is suitable for web developers with some HTML experience and experience with some other programming language. We will be using Linux as our Operating System.

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