MySQL and PHP – Developing Dynamic Web Applications

Special Notices

Please note that Oracle courses running at London training centres are subject to a 10% surcharge

Overview

In the MySQLand 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

Audience:

• Database Administrators
• Database Designer

Prerequisites

Required Prerequisites:

• Some experience with relational databases
• Understand how HTML files are assembled
• Understand fundamental PHP syntax
• Have some programming experience (preferably PHP)

Suggested Prerequisites:

• Have some knowledge of Object-Oriented Programming

Delegates will learn how to

• 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

Course Outline.

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