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. ???? Tips and
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.
???? Tips and Resources: https://docs.google.com/document/d/1tDPgLoE1SakXJlwBF283nG12iUaBVy-OngmFaC4KHbI/edit
???? GIT Repo with mysql scripts: https://github.com/jmbharathram/executeoncommand/tree/master/mysql
✏️ Course created by Execute on Command. Check out their channel: https://www.youtube.com/channel/UCwfA8RML42R-a65NRA4MQ2A
⭐️ Course Contents ⭐️
⌨️ (0:00:00) Introduction
⌨️ (0:04:03) How to create an AWS EC2 Instance
⌨️ (0:07:47) How to install MySQL database
⌨️ (0:15:43) Data Modeling
⌨️ (0:42:04) SQL Basics - Creating a Table
⌨️ (0:44:41) SQL Basics - Inserting data
⌨️ (0:49:11) SQL Basics - Updating and Deleting Data
⌨️ (0:54:53) SQL Basics - Reading data (Select statements)
⌨️ (0:57:53) SQL Joins
⌨️ (1:02:06) Transaction Isolation Levels
⌨️ (1:15:18) Table Level Locks
⌨️ (1:27:11) Row Level Locks
⌨️ (1:35:38) Database Deadlocks
⌨️ (1:40:19) Clustered Indexes
⌨️ (1:51:06) SQL Explain
???? Thanks to our Champion and Sponsor supporters:
???? Wong Voon jinq
???? hexploitation
???? Katia Moran
???? BlckPhantom
???? Nick Raker
???? Otis Morgan
???? DeezMaster
???? Treehouse
???? AppWrite
--
Learn to code for free and get a developer job: https://www.freecodecamp.org
Read hundreds of articles on programming: https://freecodecamp.org/news
And subscribe for new videos on technology every day: https://youtube.com/subscription_center?add_user=freecodecamp
