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
On this page of the site you can watch the video online SQL INTRO with MySQL and Python - Hands on Class with a duration of hours minute second in good quality, which was uploaded by the user Eli the Computer Guy 19 May 2023, share the link with friends and acquaintances, this video has already been watched 6,491 times on youtube and it was liked by 272 viewers. Enjoy your viewing!
