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.
Audience
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
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
PHP
Installing XAMPP
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
General Architecture
MySQL client
Tables
Storage Engines
SELECT statement
Aggregate queries
Establish and close a connection to the MySQL server from PHP
Retrieve and display data from the MySQL server
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
Describe Session Handling
Use Session Handling Tasks
Database Authentication
Template Systems
Smarty Template System
Course Overview
Training and Certification Website
Course Evaluation
Thank You!
Q&A Session
