SQL INTRO with MySQL and Python - Hands on Class
Support Silicon Dojo at: https://donorbox.org/etcg
RSVP for Classes at: http://www.silicondojo.com
LinkedIN at: / eli-etherton-a15362211
Class Notes and Code Samples - https://www.silicondojo.com/sql-intro...
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
Watch video SQL INTRO with MySQL and Python - Hands on Class online without registration, duration online in high quality. This video was added by user Eli the Computer Guy 19 May 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 6,008 once and liked it 256 people.