MySQL Database - Full Course

Dive into a comprehensive MySQL database tutorial for beginners, covering essential SQL fundamentals and advanced database concepts. Learn to create AWS EC2 instances, install MySQL, and master data modeling techniques. Explore SQL basics including table creation, data insertion, updating, deleting, and querying. Delve into SQL joins, transaction isolation levels, table and row-level locks, and database deadlocks. Gain insights on clustered indexes and SQL explain plans. Access provided resources, including a GitHub repository with MySQL scripts, to enhance your learning experience. By the end of this course, you'll have a solid foundation in MySQL database management and key database principles.

) 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.