SQL Intro with MySQL and Python - Hands-on Class

Learn SQL fundamentals with MySQL and Python in this comprehensive hands-on class. Explore relational databases, SQL basics, and database engines. Master MySQL server installation, navigation, and essential operations like creating databases, inserting data, and executing select statements. Dive into advanced topics such as table alterations, record updates, joins, and subqueries. Gain practical experience with user permissions, connecting Python to MySQL, and creating a simulated sensor dashboard using Python, MySQL, and HTML. Perfect for beginners and intermediate learners looking to enhance their database management and programming skills.

Opening
Introduction
SQL’s place in a coding project
What are Relational Databases
What is SQL
Database Engines
Case sensitivity in MySQL
Garbage in = Garbage out
MySQL delimiter
Installing MySQL Server
Basic MySQL Navigation
Create a Database and Tables
Inserting Data into Tables
Select Statements in SQL
Alter Tables
Update and Delete Records
Group by
Basic SQL Math count, min, max, avg
Join Tables INNER JOIN, LEFT JOIN, RIGHT JOIN
Subquery in SQL
Users and Permissions in MySQL
Connect Python to MySQL
Using Python for Select Statements in SQL
Lab - Simulated Sensor Dashboard Python, MySQL, HTML
Final Thoughts