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
PHP Development Environment; Whitespace and Comment
Course Exercise Files
Variables, Syntax, Operators and Conditional Control
Variables
Echo vs. Print; Single vs. Double Quotes
Operators
Controlling the Flow of Execution
Defining Loops and Debugging
Repeating Codes; Exercise 4
Debugging PHP; Scaffolding Code
Working with Arrays and Functions
Arrays
Functions - Part 1
Functions - Part 2
External PHP
Runtime Error Handling
File Resources
Reading and Writing to a File
Reading a Configuration File
Forms and Superglobals
Form Processing; Cookies and Sessions Superglobals
Database Storage
Database Storage - Part 1
Database Storage - Part 2
Object-Oriented Development
Object-Oriented Development - Part 1
Object-Oriented Development - Part 2
Object-Oriented Development - Part 3
Inheritance Demo
Exercise 9
Security
Common Threats
Security Demo and Exercise 10
PHP Library
PHP Built-in Constants and Standard PHP Library
Standard PHP Library Demo - Part 1
Standard PHP Library Demo - Part 2
SPL Data Structures and Exception Types
SPL Data Structures Demo
SPL Exception Types Demo; Exercise 11
SQL for Developers
Relational Database Management Systems and SQL Language
SQL Statement
Select Statement Demo - Part 1
Select Statement Demo - Part 2
Joins Demo
Table Joins and Union
Insert, Update and Delete Commands; Aggregate Functions
Queries and Store Procedure
Design Pattern
Design Pattern Categories
Singleton Pattern Demo
Observer Pattern Demo
Introduction to MySQL
Course Outline and Intro to MySQL and Database
MySQL Architecture and Installation of MySQL
Installation Demo - Part 1
Installation Demo - Part 2
Database Design
Database Design
MySQL Workbench Download
Database Table and Constraints
Database Designing and Normalization - Part 1
Database Designing and Normalization - Part 2
Storage and Data Types
Data Types Demo
ACID and Transactions
Locks, Deadlocks, Isolation Levels and Logging
Isolation Levels and Locking Demo
Locking Mechanism Demo and MySQL ACID Support
Administration
Responsibilities of a Database Administrator
Creating a User and Limiting Access to a Database; Basic Table Maintainance Function
Protecting your Database; How to Perform Database Backup
Performance Monitoring
Indexing for Performance
InnoDB Indexing and Clustered vs. Unclustered Index
Query and Where Clause
Impact of Indexing on Database Performance
Performance Optimization
Query Analysis and Optimization
Char vs. Varchar Data Types; Create, Alter and Drop Keywords; Views and Triggers
Data Definition Language; How to Create Database Objects
SQL Select Statements
SQL Select Statements Demo
Joins
Combining Related Table Using Joins
Insert, Update and Delete Commands
Insert, Update, and Delete Commands Demo
SQL for Developers
Query Optimization
Query Optimization Demo
Data Replication
Database Replication
Setting Up Replication in MySQL
Data Encryption
Column-Level Database Encryption Demo
High Availability
Conclusion
Course Wrap-up
Joins Demo
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock