MySQL Database – Full Course

Ecommerce Empire Academy

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:

💻 GIT Repo with mysql scripts:

✏️ Course created by Execute on Command. Check out their channel:

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

Read hundreds of articles on programming:

And subscribe for new videos on technology every day:

24 thoughts on “MySQL Database – Full Course”

    1. Yes. Actually even if u just do casual programming stuff, u still should learn data structures and algorithms because it really helps in solving problems. Thats what separates professionals from the rest. They optimize and write code in such a way that it is…. Very neat.

    2. “Frontend” just means “in the browser”, so what you need to be able to do “something in the browser” depends entire on what you want to do.

      Mostly: no, the frontend does not have to have any knowledge of how the backend stores the data, they only have to know how the API works.

  1. Michel Schweinsberg

    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.

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

  3. 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!

  4. 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.

    1. I think it’s just the pronunciation, and how people choose to pronounce it. Sequel or SQL 🤷🏿‍♂️

  5. 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.

  6. 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?

  7. Abhishek Sharma

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

    Awesome course!

Comments are closed.