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

Duration5 Days
Registration Open Now!

Video Learning

Duration:5 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: Searching and Authentication in the Online Winestore

FULL COURSE OUTLINE

Module 1 : Introduction to PHP

  • Incorporating PHP within HTML
  • This books examples
  • The structure of PHP
  • Questions

Module 2 : Expressions and control flow in PHP

  • Expressions
  • Operators
  • Conditionals
  • Looping
  • Implicit and explicit casting
  • PHP dynamic linking
  • Dynamic Linking in action
  • Questions

Module 3 : PHP Functions and objectives

  • PHP Functions
  • Including and requiring files
  • PHP Version compatibility
  • PHP objects
  • Questions

Module 4 : PHP Arrays

  • Basic access
  • The foreach … as loop
  • Multidimensional arrays
  • Using arrays functions
  • Questions

Module 5 : Practical PHP

  • Using prinf
  • Date and time functions
  • File handling
  • System files
  • XHTML or HTML5
  • Questions

Module 6: Introduction to MySQL

  • MySQL basics
  • Summary of database terms
  • Accessing MySQL via the command line
  • Indexes Web Database Applications with PHP and MySQL
  • MySQL Functions
  • Accessing MySQL via phpMyAdmin
  • Questions

Module 7: Mastering MySQL

  • Database Design
  • Normalization
  • Relationships
  • Transactions
  • Using EXPLAIN
  • Backing up and restoring
  • Questions

Module 8: Accessing MySQL Using PHP

  • Querying a MySQL Database with PHP
  • A practical example
  • Practical MySQL
  • Preventing hacking attempts
  • Using mysqli Procedurally
  • Questions

Module 9 : Form Handling

  • Building forms
  • Retrieving submitted data
  • An example program
  • What’s new n HTML5?
  • Features awaiting full implementation
  • Questions

Module 10 : Cookies, Sessions and Authentication

  • Using cookies in PHP
  • HTTP Authentication
  • Using sessions
  • Questions

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

Become Part of MasterGrade IT to Further Your Career.