MySQL and PHP - Developing Dynamic Web Applications

Total time

MySQL and PHP - Developing Dynamic Web Applications

Oracle University
Logo Oracle University
Provider rating: starstar_borderstar_borderstar_borderstar_border 2 Oracle University has an average rating of 2 (out of 1 reviews)

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

In the MySQL[tm] and 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

A Live Virtual Class (LVC) is exclusively for registe…

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, PHP, Database Management, Web Accessibility, and Web Analytics.

In the MySQL[tm] and 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

A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.


Audience
Course Topics Introduction
  • Structure of MySQL AB
  • MySQL Products and Services
  • MySQL Partners
  • Supported Operating Services
  • MySQL Certification Program
  • Training Curriculum Paths
  • MySQL Website
Verify Installation
  • LAMP Architecture
  • Install/Verify Apache Installation
  • Install/Verify MySQL Installation
  • Install/Verify PHP Installation
  • Putting it All Together
PHP Foundations
  • Delimit PHP Code Within HTML
  • Comment PHP Code
  • Construct PHP that interacts with end users
  • Data Types in PHP
  • Key Control Systems
  • Use Defined Functions
MySQL Foundations
  • General Architecture
  • SQL Parser and Storage Engine Tiers
  • MySQL Client
  • MySQL Query Browser
Manage Databases
  • Database Properties
  • Database Design Practices
  • MySQL Identifiers
  • Create Databases
  • Alter Databases
  • Drop Databases
Manage Tables
  • Table Properties
  • MySQL Data Types
  • Create Table
  • Alter Table
  • Empty Table
  • Remove Table
  • Indexes
  • Foreign Keys
SQL SELECT Commands
  • SELECT Statements
  • Aggregating Query Results
SQL Expressions
  • SQL Expressions
  • Functions in SQL Expressions
SQL DML Commands
  • INSERT Statement
  • DELETE Statement
  • UPDATE Statement
  • REPLACE Statement
SQL Joins
  • What is a Join
  • Inner Joins
  • Outer Joins
  • Using Qualifiers and Aliases
  • Multiple Table UPDATE and DELETE Statements
MySQL Database Driven Web Based Forms
  • Connecting to MySQL
  • Retrieving Data
  • Inserting Data
  • Updating Existing Data
  • Deleting Data
  • MySQL Metadata
  • MySQL Error Information
Session Handling
  • What is Session Handling
  • Session Handling Tasks
  • PHP Session Handling with MySQL
Object Oriented Programming
  • Benefits of OOP
  • Working with Objects
  • Exception Handling
Authentication
  • HTTP Authentication
  • PHP Authentication
Securing PHP and MySQL
  • PHP Configuration Parameters
  • Data Encryption
  • Securing the MySQL Server
  • Privileges
Conclusion
  • Course Overview
  • MySQL System Overview
  • Training and Certification Website
  • Course Evaluation
  • Thank You!
  • QA Session

Course Objectives
  • Design web-based applications
  • Design schemas based on MySQL
  • Use include files to make code easier to maintain
  • Use PHP 5 and takes advantage of its advanced features
  • Build applications following a precise flow
  • Authenticate users in a secure way against a database
  • Handle errors in your PHP applications efficiently and gracefully
  • Writes composite queries using JOINs and subqueries
  • Use indexing efficiently in order to manipulate large amounts of data efficiently
  • Uses joins to extract data from multiple tables
  • Uses GROUP BY clauses and aggregate functions
  • Write applications whose components can be scaled to meet increased demand
  • Build a complete application that includes authentication and session management
  • Understand how PHP, MySQL and the Apache web server work together to deliver dynamic web content

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.