MySQL and PHP - Developing Dynamic Web Applications

What you will learn
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.

Database Administrators
Database Designers

Related Training

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

Course Objectives
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


MySQL Overview
MySQL Products
MySQL Services
MySQL Enterprise Services
Supported Operating Systems
MySQL Certification Program
Training Curriculum Paths
MySQL Website


LAMP Architecture
Apache Server
The MySQL Database
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
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


Use the INSERT statement
Use the UPDATE statement
Use the REPLACE statement
Use the DELETE statement


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


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


Course Overview
Training and Certification Website
Course Evaluation
Thank You!
Q&A Session

Training Schedule

MySQL and PHP - Developing Dynamic Web Applications
2021 - 2022
Training schedule not found.