VehiclesFashionRecipesBlogsHuntTravelsSportFunHandmadeITEducation
Mini-Games
x

x
zakruti.com » IT - Software » freeCodeCamp.org
MySQL Database - Full Course

MySQL Database - Full Course

FBTwitterReddit

video description

Rating: 4.0; Vote: 1
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
Date: 2022-03-14

Comments and reviews: 9


there are a lot of missed opportunities at the beginning of the video.
1) He picks AWS EC2 for the cloud hosting. AWS has strengths, but DigitalOcean/Linode/Vultr are far simpler to use for a beginner. He is either unaware of those options or doesn't explain why he picked EC2.
Most videos will demostrate with Ubuntu, he picked RedHat - probably because it's more a standard in the IT world, but it would be appropriate to cover the differences and motivations for the choice.

reply

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!

reply

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

reply

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

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

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!

reply

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

Creating an aws account was not necessary for linux users, we can do all this locally, I was a fool and created one, now its going to be a waste.
reply

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?
reply
Add a review, comment






Other channel videos