- 00:00 Opening
- 09:21 Introduction
- 10:37 SQL’s place in a coding project
- 16:32 What are Relational Databases
- 22:11 What is SQL
- 28:02 Database Engines
- 29:47 Case sensitivity in MySQL
- 32:36 Garbage in = Garbage out
- 34:25 MySQL delimiter
- 37:27 Installing MySQL Server
- 45:33 Basic MySQL Navigation
- 51:58 Create a Database and Tables
- 01:04:35 Inserting Data into Tables
- 01:08:41 Select Statements in SQL
- 01:20:39 Alter Tables
- 01:22:30 Update and Delete Records
- 01:37:13 Group by
- 01:29:29 Basic SQL Math count(), min(), max, avg()
- 01:31:10 Join Tables INNER JOIN, LEFT JOIN, RIGHT JOIN
- 01:44:02 Subquery in SQL
- 01:46:19 Users and Permissions in MySQL
- 01:52:24 Connect Python to MySQL
- 01:55:34 Using Python for Select Statements in SQL
- 02:02:14 Lab – Simulated Sensor Dashboard (Python, MySQL, HTML)
- 02:14:16 Final Thoughts