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.

🔗 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

source

This Post Has 25 Comments

  1. jorge ramirez

    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!

  2. Adesh Mishra

    Why we need to create a AWS account for learning MySql??

  3. Angelo Adduci

    Thanks a lot this is really helpful!
    I have a question about cross join in MySQL. On w3school they are cited as one of MySQL join. Do they operate in the same way as full join?
    Thanks for your work!

  4. Jesus

    Gracias por los subtitulos! Son de mucha ayuda +1

  5. Timothy Andes

    At around 32 minutes and I'm not sure when/how you set up anything on mySQL Workbench. When did you set up that DB? "I am already connected to a database"… Could you provide some guidance on that?

    Edit: I feel like this could have all been completed locally and avoided any of the complication with AWS

  6. curmudgeonIII

    Sequel and SQL are not the same thing. Sequel is the name of IBM's first database system. SQL is "structured query langauage" and the tow and NOT interchangable. Hope this helps.

  7. Sanumi Oluwafemi

    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.

  8. VIMANYU PURTY

    It would have been kind if you had show how to install in the Windows.

  9. TAWSIF AHMED

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

  10. Jeff Herdzina

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

  11. Felix

    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?

  12. Vladek Zbozinek

    Until now (0:42) I have managed everything o.k.; I use Workbench 8.0. Schema created according to your instructions works well locally. However, when transferred to Goorm-IDE/MySQL environment it reports mistakes in syntax and does not create tables.

  13. Abhishek Sharma

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

    Awesome course!

  14. christian37ism

    I couldn't connect my ec2 instance to mysql workbench so I made an RDS and used that. A little detour, but it all worked out.

Leave a Reply