• 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 Object-Oriented Programming (OOP) as needed to build complex projects
• Use include files to make code easier to maintain and scale
• Use PHP 5 and takes advantage of its advanced features
• Work with HTML forms, validating, escaping and filtering data to ensure maximum security
• Build applications following a precise flow
• Authenticate users in a secure way against a database
• Handle errors in your PHP applications efficiently and gracefully
• Take advantage of MySQL’s full-text indexing features
• 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
• Write applications secure applications
• Use PHP’s caching capabilities
• Take advantage of PHP’s encryption capabilities

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

Having attended the PHP Essentials course or similar knowledge:

• Understand how HTML files are assembled
• Understand fundamental PHP syntax
• Have some programming experience (preferably PHP)
• Some experience with relational databases
• Have some understanding and experience of Object-Oriented Programming (OOP)

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