MySQL Database - Full Course

Опис:

Learn about MySQL Database in this full tutorial course for beginners. This course teaches you not just SQL basics, but also key database concepts such as data modeling, locks, indexes, and SQL explain. The course starts with an introduction at 0:00:00, then shows how to create an AWS EC2 instance at 0:04:03, how to install MySQL at 0:07:47, covers data modeling at 0:15:43, and then moves into SQL basics: creating tables at 0:42:04, inserting data at 0:44:41, updating and deleting data at 0:49:11, reading data at 0:54:53, and SQL joins at 0:57:53. It continues with transaction isolation levels at 1:02:06, table level locks at 1:15:18, row level locks at 1:27:11, database deadlocks at 1:35:38, clustered indexes at 1:40:19, and finishes with SQL explain at 1:51:06.