Learn PHP and MySQL for Beginners the Easy Way – 13 Hours

Course Curriculum

Chapter 1: PHP Programming Training Course

Lecture 1: Course Objectives; PHP Definition, Syntax, Key Words and Tags

Lecture 2: WATCH ME: Essential Information for a Successful Training Experience

Lecture 3: PHP Course Exercise Files

Lecture 4: PHP Development Environment; Whitespace and Comment

Lecture 5: Variables; Exercise 2

Lecture 6: Echo vs. Print; Single vs. Double Quotes

Lecture 7: Operators

Lecture 8: Controlling the Flow of Execution; Exercise 3

Lecture 9: Repeating Codes; Exercise 4

Lecture 10: Debugging PHP; Scaffolding Code

Lecture 11: Arrays; Exercise 5

Lecture 12: Functions – Part 1

Lecture 13: Functions – Part 2; Exercise 6

Lecture 14: External PHP

Lecture 15: Runtime Error Handling

Lecture 16: Reading and Writing to a File

Lecture 17: Reading a Configuration File; Exercise 7

Lecture 18: Form Processing; Cookies and Sessions Superglobals; Exercise 8

Lecture 19: Database Storage – Part 1

Lecture 20: Database Storage – Part 2

Lecture 21: Object-Oriented Development – Part 1

Lecture 22: Object-Oriented Development – Part 2

Lecture 23: Object-Oriented Development – Part 3

Lecture 24: Inheritance Demo

Lecture 25: Exercise 9

Lecture 26: Common Threats

Lecture 27: Security Demo and Exercise 10

Lecture 28: PHP Built-in Constants and Standard PHP Library

Lecture 29: Standard PHP Library Demo – Part 1

Lecture 30: Standard PHP Library Demo – Part 2

Lecture 31: SPL Data Structures and Exception Types

Lecture 32: SPL Data Structures Demo

Lecture 33: SPL Exception Types Demo; Exercise 11

Lecture 34: Relational Database Management Systems and SQL Language

Lecture 35: SQL Statement

Lecture 36: Select Statement Demo – Part 1

Lecture 37: Table Joins and Union

Lecture 38: Select Statement Demo – Part 2

Lecture 39: Joins Demo

Lecture 40: Insert, Update and Delete Commands; Aggregate Functions

Lecture 41: Queries and Store Procedure

Lecture 42: Design Pattern Categories

Lecture 43: Singleton Pattern Demo

Lecture 44: Observer Pattern Demo

Chapter 2: MySQL Training Course

Lecture 1: Course Outline and Intro to MySQL and Database

Lecture 2: READ ME: Essential Information for a Successful Training Experience

Lecture 3: Course Review

Lecture 4: MySQL Architecture and Installation of MySQL

Lecture 5: Installation Demo – Part 1

Lecture 6: Installation Demo – Part 2

Lecture 7: Database Design

Lecture 8: MySQL Workbench Download

Lecture 9: Database Table and Constraints

Lecture 10: Database Designing and Normalization – Part 1

Lecture 11: Database Designing and Normalization – Part 2

Lecture 12: Storage and Data Types

Lecture 13: Data Types Demo

Lecture 14: ACID and Transactions

Lecture 15: Locks, Deadlocks, Isolation Levels and Logging

Lecture 16: Isolation Levels and Locking Demo

Lecture 17: Locking Mechanism Demo and MySQL ACID Support

Lecture 18: Responsibilities of a Database Administrator

Lecture 19: Creating a User and Limiting Access to a Database; Basic Maintainance Function

Lecture 20: Protecting your Database; How to Perform Database Backup

Lecture 21: Performance Monitoring

Lecture 22: InnoDB Indexing and Clustered vs. Unclustered Index

Lecture 23: Query and Where Clause

Lecture 24: Impact of Indexing on Database Performance

Lecture 25: Performance Optimization

Lecture 26: Char vs. Varchar Data Types; Create, Alter and Drop Keywords; Views and Triggers

Lecture 27: Data Definition Language; How to Create Database Objects

Lecture 28: SQL Select Statements

Lecture 29: SQL Select Statements Demo

Lecture 30: Joins

Lecture 31: Combining Related Table Using Joins

Lecture 32: Insert, Update and Delete Commands

Lecture 33: Insert, Update, and Delete Commands Demo

Lecture 34: Query Optimization

Lecture 35: Query Optimization Demo

Lecture 36: Database Replication

Lecture 37: Setting Up Replication in MySQL

Lecture 38: Data Encryption

Lecture 39: High Availability

Lecture 40: Course Wrap-up

Lecture 41: Column-Level Database Encryption Demo