Chapters (15)
- 0:00Introduction
- 4:03How to create an AWS EC2 Instance
- 7:47How to install MySQL database
- 15:43Data Modeling
- 42:04SQL Basics - Creating a Table
- 44:41SQL Basics - Inserting data
- 49:11SQL Basics - Updating and Deleting Data
- 54:53SQL Basics - Reading data (Select statements)
- 57:53SQL Joins
- 1:02:06Transaction Isolation Levels
- 1:15:18Table Level Locks
- 1:27:11Row Level Locks
- 1:35:38Database Deadlocks
- 1:40:19Clustered Indexes
- 1:51:06SQL Explain
Show the creator's full description
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
❤️ Try interactive Databases courses we love, right in your browser: https://scrimba.com/freeCodeCamp-Databases (Made possible by a grant from our friends at Scrimba)
⭐️ 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
Description and video by freeCodeCamp.org. This page is an independent companion view; the video is embedded from YouTube.