Home > Courses Certifications > Web Design > Web Database Applications

Web Database Applications with PHP and MySQL

Overview: This course will cover the fundamentals of building a real world web application using MySQL and PHP.

Duration: 10 Days

 

Chapter 1: Database Applications and the Web

• The Web
• Three-Tier Architectures

Chapter 2: The PHP Scripting Language

• Introducing PHP
• Conditions and Branches
• Loops
• Functions
• Working with Types
• User-Defined Functions
• A Working Example

Chapter 3: Arrays, Strings, and Advanced Data Manipulation in PHP

• Arrays
• Strings
• Regular Expressions
• Dates and Times
• Integers and Floats

Chapter 4: Introduction to Object-Oriented Programming with PHP 5

• Classes and Objects
• Inheritance
• Throwing and Catching Exceptions

Chapter 5: SQL and MySQL

• Database Basics
• MySQL Command Interpreter
• Managing Databases and Tables
• Inserting, Updating, and Deleting Data
• Querying with SQL SELECT
• Join Queries
• Case Study: Adding a New Wine

Chapter 6: Querying Web Databases

• Querying a MySQL Database Using PHP
• Processing User Input
• MySQL Function Reference

Chapter 7: PERL

• Overview
• Core Components
• Packages

Chapter 8: Writing to Web Databases

• Database Inserts, Updates,and Deletes
• Issues in Writing Data to Databases

Chapter 9: Validation with PHP and JavaScript

• Validation and Error Reporting Principles
• Server-Side Validation with PHP
• JavaScript and Client-Side Validation

Chapter 10: Sessions

• Introducing Session Management
• PHP Session Management
• Case Study: Using Sessions in Validation
• When to Use Sessions
• PHP Session API and Configuration

Chapter 11: Authentication and Security

• HTTP Authentication
• HTTP Authentication with PHP
• Form-Based Authentication
• Protecting Data on the Web

Chapter 12: Errors, Debugging, and Deployment

• Errors
• Common Programming Errors
• Custom Error Handlers

Chapter 13: Reporting

• Creating a Report
• Producing PDF
• PDF-PHP Reference

Chapter 14: Advanced Features of Object-Oriented Programming in PHP 5

• Working with Class Hierarchies
• Class Type Hints
• Abstract Classes and Interfaces
• Freight Calculator Example

Chapter 15: Advanced SQL

• Exploring with SHOW
• Advanced Querying
• Manipulating Data and Databases
• Functions
• Automating Querying
• Table Types