MySQL and PHP – Developing Dynamic Web Applications

Level

MySQL and PHP – Developing Dynamic Web Applications

Aikona
Logo Aikona

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.

Description

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 us…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: PHP, Database Management, PHP, Web Accessibility, and Web Analytics.

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
There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.