PHP & MySQL Course Overview

PHP & MySQL has become one of the most popular full-featured open-source languages. It is capable of managing huge database-driven online environments. This web development course will enable to create complex Web Database Applications.Web developers all over the world us PHP as a general-purpose scripting language. PHP was originally created to help coders maintain personal home pages. Today, however, it is far more than just a set of utilities.

Apply Today

Instructor Led Learning

Duration: 10 Days
Registration Open Now!

Video Learning

Duration: 10 Days
Registration Open Now!

What you will learn

  • Lesson 1: Database Applications and the Web
  • Lesson 2: The PHP Scripting Language
  • Lesson 3: Arrays, Strings, and Advanced Data Manipulation
  • Lesson 4: Introduction to Object-Oriented Programming
  • Lesson 5: SQL and MySQL
  • Lesson 6: Querying Web Databases
  • Lesson 7: PEAR
  • Lesson 8: Writing to Web Databases
  • Lesson 9: Validation with PHP and JavaScript
  • Lesson 10: Sessions
  • Lesson 11: Authentication and Security
  • Lesson 12: Errors, Debugging, and Deployment
  • Lesson 13: Reporting
  • Lesson 14: Advanced Features of Object-Oriented Programming
  • Lesson 15: Advanced SQL
  • Lesson 16: Hugh and Dave’s Online Wines: A Case Study
  • Lesson 17: Managing Customers
  • Lesson 18: The Shopping Cart
  • Lesson 19: Ordering and Shipping at the Online Winestore
  • Lesson 20: earching and Authentication in the Online Winestore

FULL COURSE OUTLINE

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

Chapter 6: Querying Web Databases

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

Chapter 7: Writing to Web Databases

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

Chapter 8: Sessions

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

Chapter 9: Authentication and Security

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

Chapter 10: Errors, Debugging, and Deployment

  • Errors
  • Common Programming Errors
  • Custom Error Handlers

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

  • Working with Class Hierarchies
  • Class Type Hints
  • Abstract Classes and Interfaces

Chapter 12: Advanced SQL

  • Advanced Querying
  • Manipulating Data and Databases
  • Functions
  • Automating Querying
  • Table Types

Chapter 13: Practical Application

  • Creating a PHP & MySQL Application

Join Over 10,000 Students that have studied with MasterGrade IT Now

Become Part of MasterGrade IT to Further Your Career.