MySQL and PHP - Developing Dynamic Web Applications

Some experience with relational databases

Understand how HTML files are assembled

Understand fundamental PHP syntax

Have some programming experience (preferably PHP)

Suggested Prerequisites

Describe the LAMP architecture

Use the basic components of PHP to build a foundation for
more complex web applications

Understand the basic components of MySQL

Use SQL query commands to retrieve data from the MYSQL
database

Change 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

Use session handling to authenticate and monitor user
identities

Describe the purpose of template systems

Introduction

MySQL Overview

MySQL Products

MySQL Services

MySQL Enterprise Services

Supported Operating Systems

MySQL Certification Program

Training Curriculum Paths

MySQL Website

LAMP

LAMP Architecture

Apache Server

The MySQL Database

PHP

Installing XAMPP

PHP Foundations

Delimit PHP code within HTML

Comment PHP code

Construct Feedback

Use the Data Types available in PHP

Use Key Control Statements

Develop Reusable Code with user defined functions

MySQL Foundations

General Architecture

MySQL client

Tables

Storage Engines

SELECT statement

Aggregate queries

PHP Connecting to MySQL

Establish and close a connection to the MySQL server from
PHP

Retrieve and display data from the MySQL server

Linking Between Tables

Define and create an HTML link

Create the ability to pass information between web pages

 Link dynamic pages
to other pages

SQL DML

Use the INSERT statement

Use the UPDATE statement

Use the REPLACE statement

Use the DELETE statement

Forms

Create and design HTML web forms

Update data in a MySQL database using a web form

Delete MySQL data with PHP

Insert new records in MySQL using web forms

Joins

Describe the concept of a Join

Connect Data from Multiple Tables using Joins

Resolve Name Clashes when Joining Tables

Session Handling

Describe Session Handling

Use Session Handling Tasks

Database Authentication

Common Techniques

Template Systems

Smarty Template System

Conclusion

Course Overview

Training and Certification Website

Course Evaluation

Thank You!

Q&A Session

Description:

This MySQL and PHP - Developing Dynamic Web Applications
will teach you how to develop applications in PHP and

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 to rapidly prototype and deploy dynamic websites.