MySQL Database – Full Course

Learn about MySQL Database in this full tutorial course for beginners. This course teaches you not just SQL basics, but it also goes into key database concepts such as Data Modeling, Locks, Indexes, Data Modeling, SQL Explain, and more.

Course Contents
Introduction
How to create an AWS EC2 Instance
How to install MySQL database
Data Modeling
SQL Basics – Creating a Table
SQL Basics – Inserting data
SQL Basics – Updating and Deleting Data
SQL Basics – Reading data (Select statements)
SQL Joins
Transaction Isolation Levels
Table Level Locks
Row Level Locks
Database Deadlocks
Clustered Indexes
SQL Explain