1 – MySQL Basics
- 1.1 – Introduction to Databases and SQL
- 1.2 – What is MySQL?
- 1.3 – What is phpMyAdmin?
- 1.4 – Datatypes MySQL
- 1.5 – Keywords MySQL
2 – phpMyAdmin
- 2.1 – Login and Logout phpMyAdmin
- 2.2 – Create Users
- 2.3 – Create Database and Table
- 2.4 – Run Simple SQL Statements
3 – MySQL Statements
- 3.1 – Create a Table
- 3.2 – Drop a Table
- 3.3 – INSERT Statements
- 3.4 – SELECT Statements
- 3.5 – Clause – WHERE, LIMIT
- 3.6 – Operators – IS NULL, LIKE, ORDER BY
- 3.7 – UPDATE Statements
- 3.8 – DELETE Statements
4 – mySQL & PHP with PDO
- 4.1 – Database Connectivity
- 4.2 – Simple Query from PHP to mySQL
- 4.3 – Form to Add, Edit, Update and Delete
5 – mySQL & PHP with mysqli
- 5.1 – Database Connectivity
- 5.2 – Simple Query from PHP to mySQL
- 5.3 – Form to Add, Edit, Update and Delete