Knowledge Transfer Microsoft Certified Training Partner CTEC
Knowledge Transfer is a Microsoft Certified Gold Partner
Microsoft Certified Gold Training Partner
Search for a Course Topic:
Public Courses
Corporate Services & Training
 

 

 



 Course Search
Keyword
Course #
State

 Training Delivery
 
Training Delivery
Custom Curriculum
Course List
 
 Main Menu
 
Home
View Courses
Site Index
 
 


MySQL and PHP - Developing Dynamic Web Applications Overview


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

 

View Printer Friendly Page


To Inquire About Future Classes

Request a class date

if one is not scheduled.