MySQL Database - Full Course

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.


⭐️ 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

--

[okelloisaac]

Thanks a lot, I am currently studying DBMS and this already so helpful

[TheGrandmaster]

Yes! 2 hours, goldilocks zone. Not too much, not too little. Perfect way to knock the rust off my database skills and get back in the game. Every day this damn channel astonishes me with the incredible content.

[jeffherdzina]

This is by far the best information about learning MySql on YouTube.

[Sam-kezb]

Thanks for this. It came on the right time. Bless up

[hemanthsrujan]

Your timing is awesome thanking you to do more...

[asharma]

Hi sir, Git Cli works perfectly fine for Windows users no need to install putty, just a little tip.

Awesome course!

[woosukbyun]

Watched some part of this video and seems good to watch the whole thing. Thanks for the great video!

[ashutoshthite]

Thanks for putting it... I just needed this..

[AmeerHamza-mtyi]

You help lot of people keep doing man thanks a lot ❤️❤️

[elobservador]

Gracias por los subtitulos! Son de mucha ayuda +1

[jhramirezr]

Hello, couple of questions

1) If I’m using Mac, should I still start by installing Linux like you did in the video?
2) When you opened mySql, and stated that your database was already connected - - is it the same thing as what you did in the CLI previously?
3) Later, when you forward engineered. Which hosts and port names did you use? The same ones from your AWS EC instance?

Sorry I’m just confused
Thanks!

[t-ree]

Didn't started yet. But i think it will be outstanding!!

[hmm]

oo what a timing.. i was abt to start with some database and full stack

[sanumioluwafemi]

Just a question please. At 48:22, was product_3 created? I tried running it but I am getting an error saying ecomm_store.product_3 doesn't not exist. I will appreciate your reply. Thanks for the training session.

[StaticBlaster]

Thank you, sir, for your generosity and sharing your knowledge with the world.

[maramcharanteja]

please make a course on object oriented programming in c++

[marc]

Thanks for the course! Why did you not use AWS RDS to set up the database and what are the advantages of doing it this way?

[sleepingcat]

I'm High School Student :) And I'm learning to do my Software Development tasks ^^

[kareenaolivera]

How is this channel for FREEE? thank you so much for this! Forever Grateful! If I become successful coder, I will forever mention you guys haha!!!

[jeffkamga]

Hi please which software do you use to make videos and edit them. I hope to hear from you soon.