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.
Overview
Syllabus
) 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.
Taught by
freeCodeCamp.org
Related Courses
Related articles
Reviews
4.0 rating, based on 2 Class Central reviews
-
I had a wonderful time learning here.
Lessons were simplified and thus easy to understand with a good flow -
It's great course as for beginners level students of MySQL learnering. Content was great and audio & quality was good. I'm very glad to have this kind course was available free with certificate
