sql crash course - 2022

Note: You might not be able to view until you download the zip.
Zip Files: https://drive.google.com/file/d/1vUVOQqoXyVblbOJx1RkfppfITWXLDc-z/view?usp=sharing

Windows MySQL install video: https://youtu.be/qCja7GZ3-0A
Mac OS X Install video: https://youtu.be/5tVOLE7tEp8

Hello! In this video we're going to cover the fundamentals of MySQL. This is a great video if you have ZERO experience coding because MySQL is a great place to start as a beginner programmer. Even if you already know how to code, this SQL crash course can help you get up to speed on SQL and MySQL quickly.

The zip files for this sql crash course are divided into separate self-contained sections so you should ideally be able to just copy and paste the code snippets to either follow along with the sql tutorial or see the comments and read the docs to learn what's going on in your own time.

This SQL course is designed to take people from zero experience in SQL, all the way up to understanding the differences between database engines, mysql foreign key constraints, inner joins, one to many and many to many relationships, pattern matching and basic regular expressions, and more. Here's a list of timestamps to help you navigate this sql tutorial quickly:

0:00 - 1:10 - SQL Crash Course 2022 introduction
1:11 - 12:03 - Install Mamp on Mac (Mac OS X users)
12:04 - 21:23 - Install WampServer on Windows
21:24 - 25:48 Creating and Deleting Databases with SQL and PHPMyAdmin
25:50 - 35:39 Creating Tables in PHPMyAdmin (MySQL GUI)
35:40 - 43:32 Creating Tables with SQL Code
43:33 - 48:15 Inserting rows & data into tables with SQL
48:16 - 57:27 Deleting Rows in SQL (and duplicating tables)
57:28 - 1:11:29 Altering Tables in SQL
1:11:30 - 1:18:27 Updating existing data in SQL Tables
1:18:28 - 1:36:52 SELECT & WHERE (Querying Data in MySQL with Select, where, conditionals, pattern matching, and more)
1:36:53 - 1:47:40 Inner Joins in SQL (and one to many relationships)
1:47:41 - 1:55:27 Left & Right Joins in SQL (One to many relationships)
1:55:28 - 2:13:10 Foreign Key Constraints, sql table relationships, Cascading deletes, foreign keys & sql restrict. Altering Foreign key Constraints in SQL
2:13:11 - Many to Many Relationships, Join Tables, and Altering Foreign Key Constraints