Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Learn Beginner PHP & MySQL the Easy Way
Introduction to PHP
Course Objectives; PHP Definition, Syntax, Key Words and Tags (11:20)
PHP Development Environment; Whitespace and Comment (7:40)
Course Exercise Files
Variables, Syntax, Operators and Conditional Control
Variables (11:00)
Echo vs. Print; Single vs. Double Quotes (5:42)
Operators (11:28)
Controlling the Flow of Execution (11:18)
Defining Loops and Debugging
Repeating Codes; Exercise 4 (11:42)
Debugging PHP; Scaffolding Code (4:54)
Working with Arrays and Functions
Arrays (10:55)
Functions - Part 1 (11:39)
Functions - Part 2 (13:52)
External PHP (7:42)
Runtime Error Handling (10:34)
File Resources
Reading and Writing to a File (11:53)
Reading a Configuration File (8:07)
Forms and Superglobals
Form Processing; Cookies and Sessions Superglobals (10:04)
Database Storage
Database Storage - Part 1 (5:04)
Database Storage - Part 2 (12:33)
Object-Oriented Development
Object-Oriented Development - Part 1 (13:01)
Object-Oriented Development - Part 2 (13:02)
Object-Oriented Development - Part 3 (4:37)
Inheritance Demo (13:37)
Exercise 9 (1:59)
Security
Common Threats (2:44)
Security Demo and Exercise 10 (12:53)
PHP Library
PHP Built-in Constants and Standard PHP Library (12:34)
Standard PHP Library Demo - Part 1 (10:13)
Standard PHP Library Demo - Part 2 (7:10)
SPL Data Structures and Exception Types (8:44)
SPL Data Structures Demo (14:57)
SPL Exception Types Demo; Exercise 11 (8:06)
SQL for Developers
Relational Database Management Systems and SQL Language (5:50)
SQL Statement (7:48)
Select Statement Demo - Part 1 (14:13)
Select Statement Demo - Part 2 (14:47)
Joins Demo (4:08)
Table Joins and Union (5:36)
Insert, Update and Delete Commands; Aggregate Functions (8:01)
Queries and Store Procedure (5:58)
Design Pattern
Design Pattern Categories (6:12)
Singleton Pattern Demo (8:52)
Observer Pattern Demo (6:52)
Introduction to MySQL
Course Outline and Intro to MySQL and Database (10:11)
MySQL Architecture and Installation of MySQL (15:55)
Installation Demo - Part 1 (3:35)
Installation Demo - Part 2 (9:37)
Database Design
Database Design (8:46)
MySQL Workbench Download (7:34)
Database Table and Constraints (9:39)
Database Designing and Normalization - Part 1 (11:51)
Database Designing and Normalization - Part 2 (8:10)
Storage and Data Types (5:25)
Data Types Demo (11:20)
ACID and Transactions (9:44)
Locks, Deadlocks, Isolation Levels and Logging (7:16)
Isolation Levels and Locking Demo (12:43)
Locking Mechanism Demo and MySQL ACID Support (6:22)
Administration
Responsibilities of a Database Administrator (3:41)
Creating a User and Limiting Access to a Database; Basic Table Maintainance Function (10:34)
Protecting your Database; How to Perform Database Backup (7:44)
Performance Monitoring (10:49)
Indexing for Performance
InnoDB Indexing and Clustered vs. Unclustered Index (14:17)
Query and Where Clause (5:28)
Impact of Indexing on Database Performance (10:33)
Performance Optimization (7:49)
Query Analysis and Optimization
Char vs. Varchar Data Types; Create, Alter and Drop Keywords; Views and Triggers (13:16)
Data Definition Language; How to Create Database Objects (12:27)
SQL Select Statements (7:48)
SQL Select Statements Demo (10:19)
Joins (5:36)
Combining Related Table Using Joins (16:06)
Insert, Update and Delete Commands (6:08)
Insert, Update, and Delete Commands Demo (8:47)
SQL for Developers
Query Optimization (3:40)
Query Optimization Demo (6:39)
Data Replication
Database Replication (6:38)
Setting Up Replication in MySQL (4:57)
Data Encryption (5:13)
Column-Level Database Encryption Demo (4:44)
High Availability (10:43)
Conclusion
Course Wrap-up (4:08)
PHP Development Environment; Whitespace and Comment
Complete and Continue