SQL Intro with MySQL and Python

  • 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