MySQL and PHP - Developing Dynamic Web Applications

In the MySQL[tm] and PHP - Developing Dynamic Web Applications you will learn 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.

Students who can benefit from this course:

• 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

A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.

Audience
Course Topics Introduction

• Structure of MySQL AB
• MySQL Products and Services
• MySQL Partners
• Supported Operating Services
• MySQL Certification Program
• Training Curriculum Paths
• MySQL Website

Verify Installation

• LAMP Architecture
• Install/Verify Apache Installation
• Install/Verify MySQL Installation
• Install/Verify PHP Installation
• Putting it All Together

PHP Foundations

• Delimit PHP Code Within HTML
• Comment PHP Code
• Construct PHP that interacts with end users
• Data Types in PHP
• Key Control Systems
• Use Defined Functions

MySQL Foundations

• General Architecture
• SQL Parser and Storage Engine Tiers
• MySQL Client
• MySQL Query Browser

Manage Databases

• Database Properties
• Database Design Practices
• MySQL Identifiers
• Create Databases
• Alter Databases
• Drop Databases

Manage Tables

• Table Properties
• MySQL Data Types
• Create Table
• Alter Table
• Empty Table
• Remove Table
• Indexes
• Foreign Keys

SQL SELECT Commands

• SELECT Statements
• Aggregating Query Results

SQL Expressions

• SQL Expressions
• Functions in SQL Expressions

SQL DML Commands

• INSERT Statement
• DELETE Statement
• UPDATE Statement
• REPLACE Statement

SQL Joins

• What is a Join
• Inner Joins
• Outer Joins
• Using Qualifiers and Aliases
• Multiple Table UPDATE and DELETE Statements

MySQL Database Driven Web Based Forms

• Connecting to MySQL
• Retrieving Data
• Inserting Data
• Updating Existing Data
• Deleting Data
• MySQL Metadata
• MySQL Error Information

Session Handling

• What is Session Handling
• Session Handling Tasks
• PHP Session Handling with MySQL

Object Oriented Programming

• Benefits of OOP
• Working with Objects
• Exception Handling

Authentication

• HTTP Authentication
• PHP Authentication

Securing PHP and MySQL

• PHP Configuration Parameters
• Data Encryption
• Securing the MySQL Server
• Privileges

Conclusion

• Course Overview
• MySQL System Overview
• Training and Certification Website
• Course Evaluation
• Thank You!
• QA Session

Course Objectives

• 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