Completed
Select Statements in SQL
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
SQL Intro with MySQL and Python - Hands-on Class
Automatically move to the next video in the Classroom when playback concludes
- 1 Opening
- 2 Introduction
- 3 SQL’s place in a coding project
- 4 What are Relational Databases
- 5 What is SQL
- 6 Database Engines
- 7 Case sensitivity in MySQL
- 8 Garbage in = Garbage out
- 9 MySQL delimiter
- 10 Installing MySQL Server
- 11 Basic MySQL Navigation
- 12 Create a Database and Tables
- 13 Inserting Data into Tables
- 14 Select Statements in SQL
- 15 Alter Tables
- 16 Update and Delete Records
- 17 Group by
- 18 Basic SQL Math count, min, max, avg
- 19 Join Tables INNER JOIN, LEFT JOIN, RIGHT JOIN
- 20 Subquery in SQL
- 21 Users and Permissions in MySQL
- 22 Connect Python to MySQL
- 23 Using Python for Select Statements in SQL
- 24 Lab - Simulated Sensor Dashboard Python, MySQL, HTML
- 25 Final Thoughts
