Support Silicon Dojo at: [ Ссылка ]
RSVP for Classes at: [ Ссылка ]
LinkedIN at: [ Ссылка ]
Class Notes and Code Samples - [ Ссылка ]
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
