This course covers MySQL Database for beginners, teaching SQL basics along with key concepts like Data Modeling, Locks, Indexes, and SQL Explain. The course aims to help learners understand how to create a database, manipulate data, and optimize queries. The teaching method includes video tutorials and practical demonstrations. This course is intended for individuals interested in learning about databases, SQL, and MySQL specifically.
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
