MySQL Database - Full Course

[@TheGrandmaster1]

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.

[@okelloisaac2306]

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

[@jeffherdzina6716]

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

[@asharma741]

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

[@karengomez3143]

Takeaways: -Normalized data could increase the query complexity but could lean towards data integrity. -40:00 Forward Engineer to DB (to create a SQL Script in Workbench). -52:00 There's a SET SQL_SAFE_UPDATEs = 1; that is going to block DELETE * FROM table. - There's different ways to select data, joins showing repeated or different data from 2 tables. -Thanks to transaction isolation levels and transaction logs, transactions are done in a expected manner. -Clustered indexes: through B-tree based on primary key, unique non-nullable index, internally maintained PK (hidden).

[@Random_Coffee_Cup]

I love this Chunnel so freaking much

[@cedricmendoza8316]

Me too!

[@ExclusivelyC4]

Thanks!

[@hemanthsrujan8414]

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

[@sleeping4cat]

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

[@woosukbyun2455]

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

[@Sam-ke5zb]

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

[@t-ree]

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

[@bavan1358]

Hellll yeahhhhh , right when I needed

[@ashutoshthite]

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

[@hmm7458]

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

[@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!

[@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!!!

[@sanumioluwafemi7247]

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.

[@maramcharanteja6320]

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

[@AmeerHamza-mt5yi]

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

[@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.

[@anarpatel8998]

thank you for sharing!! My ec2 wasn't connecting either. I used same approach.

[@vonnghost]

how did you do that?

[@christian37ism]

@@vonnghost Create an rds with your amazon account, then link the workbench to it the same as ec2

[@josuemartinez4685]

awesome work...thanks team..!!

[@StaticBlaster]

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

[@TK-wp3iw]

Do we need Data base algorithms and similar complex stuff for front end??

[@neillunavat]

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.

[@vinny142]

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

[@elobservador7155]

Gracias por los subtitulos! Son de mucha ayuda +1

[@papusa9878]

Another SQL course yayyy😄😄😄

[@thejack483]

2:11 Let me comb first then we will start MySQL

[@calvo_en_moto]

Thank you for this beautifil material

[@marc5226]

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?

[@muhammadsolikhin8025]

Really-really Helpfull

[@flanker8415]

There is already a basic MySQL course on the channel, why not get an intermediate or advanced course?

[@ilianos]

Do you mean the one that's about 4 and a half hours long? I feel like I will like this one better.

[@kensimba7868]

I agree. Am done with that 4.5 hrs basic mysql training and I thought this could be an advanced one. We need next level tutorials pls

[@thedevnoteyt]

Thanks Freecodecamp ❤️

[@jeffkamga7902]

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

[@therealnero820]

Learned more from an indian guy then in school

[@ZeusOP]

How do we write directly to Excel sheets from mysql

[@Juancarlos-hw8sf]

Gracias buen hombre, 👌👌👌👌👌👌👌

[@BlissAden]

Can’t wait for Postgress

[@alongbarbrahma484]

I have zero experience on Mysql. Can i take this course as a beginner?

[@GilligansIsland]

Yes you should be able to. plain SQL is pretty simple as a query language and not much like typical programming languages so most people are probably starting from 0 like you. Have fun!

[@invinciblevikas9553]

I am student as this course are good for me

[@r3ady150]

Why is AWS EC2 Instance needed? There was no explanation what this is and why it's needed.

[@adeshmishra1671]

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

[@CrazyGamerEmonJ]

Skip that part, just use a terminal or download Linux or run Linux on VM

[@burakmike3161]

Thanks a lot

[@buntypeter4584]

What are prerequisites for the course??

[@TorFromReno]

The video to create AWS account is unavailable and marked as "private".

[@keshavthakur5990]

Very nice

[@emilianorobertosesaregoaco4770]

I cannot install mysql-commuty-server with this instructions. I have errors like: nothing provides libstdc++.so.6(CXXABI_1.3.13)(64bit) needed by mysql-community-server-8.0.30-1.el9.x86_64 .. etc.

[@user-hs2vc2rl9w]

how do I access setting up the AWS account? It says private and I can't access it

[@AmroAlmutasim]

is this for linux or windows ?

[@aditya_asundi]

thanks fcc!!!

[@drhastings]

The start of the video is not beginner friendly.

[@teenytinytoons]

it's quite awful actually.

[@ivanzq21]

What do you mean? I did not understand

[@malkeetnanwa23]

I am a non-technical person so can I start learning mysql as first programming language to get job in IT Industry

[@niturai9488]

you should start with javascript or python as they are easy to learn and are in demand also after that you can learn sql but prior to all these you should learn some computer basics like using the command line, installing and uninstalling programs, creating and saving files and the most important thing, you should learn to type as fast as you can by the touchtyping method. This will save a lot of time and reduc your learning duration to appoximately 3/4 th of what it takes to learn normally

[@teenytinytoons]

@@niturai9488 lol. JS is not easy to learn.

[@iamcktyagi]

Thank-you

[@juju-9454]

Do we need to learn while we know mongoDB?

[@el_cucu2512]

that*s which i was looking for.

[@coderinmood5119]

Awesome

[@curmudgeoniii9762]

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.

[@reztheson]

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

[@speedrusha]

SQL = Sequel = Structured English QUEry Language

[@GM-uj8cs]

마이스꿜 이즈 파퓰러 데러베이르~

[@vimanyupurty6166]

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

[@__-cd1nd]

Thanks

[@anupamkumar7083]

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.

[@GustavAgar]

Postgress please 🙏

[@ramdayalkumawat3712]

Next course for unity course plz

[@dilipkumar-ck1nc]

Give us a course on iis webserver

[@aniljangir2540]

great

[@farhan_aftab]

Laravel Please ?

[@CodingByAmp]

Cool

[@ganalytical]

Likes for the video

[@HarshAnalysis]

I have a test 4 days later and this popped up... Wth

[@williamgomez6087]

ThankUThankUThankUThankUSenior

[@azizshifulla1938]

I want termux full course

[@r3ady150]

So I tried to push through. I got through creating first db but then you just skipped to the sql scripts. i thought this was for beginners. You skip over key steps. Like after you created database how to properly save it. Not everyone can do A b skip c and d then go on to e f g. A beginners course explains everything in between. This is not a beginner course. This is not a good course.

[@LectureHubKe]

Mine is beginner. Check out my playlist

[@longalex5194]

I'm quite disappointed about the 'Data Modeling' and 'Creating a table' part. I believe they should be more hand-writing other than just using tools MySQL offers. I agree it is time-saving but business do not pay you for just using tools because everyone else can learn them too. They only have no idea how tables are actually created, for example pk refers to columns of a table, a table cannot have 2 pks but a pk can consist of as many columns as user want.

[@OkiemTaty]

"in this full tutorial course for beginners" you fail to explain key points of the earliest of journeys - installing DB... If someone hasn't worked with a DB why would you assume they have knowledge about connecting to one? you go through the process but you have loads of presuppositions and assumptions about the knowledge of your audience...

[@VTS_99]

This is not Database administration , this should be called MySQL Developer .. its abou Crud and stuff not admin really

[@IamCaptainDeadpo0l]

"MYSQL" self obsessed much

[@anantgamer8952]

😊

[@samsonsylvester9545]

MySQL

[@endrisofia]

👏👏👏👏

[@mrrishiraj88]

🙏

[@MP-wm9gb]

Who da hell gave 26 thumbs down? People, CMON! This is just pure hate and nothing more. Idiots.

[@ivanyosifov2629]

I guess it comes from the PHP haters.

[@Timureithi]

People who never made it past html.

[@TonyTony-dl9xr]

Add lyrics uzbek please

[@satyasridevi851]

I am just ----

[@iamibayat]

First comment!!

[@ashishhverma]

First like, first comment, first viewer

[@SkulzR]

S

[@billuop5665]

10 th

[@kweku1on1]

This video isn't really helpful. The instructor skips some key aspects thinking its just easy to work around but most people watching this video are beginners and they need to know how everything is down to the latter. So much confusion going forward. I wouldn't recomend.

[@LectureHubKe]

Kindly review my MySQL playlist

[@timmcgee6787]

It is pronounced my SQL not my sequel

[@balajidevanathan6107]

This Guy will waste your time 😏

[@MOLOTOV_1991]

00:08 😰🤮😭

[@karamalinumberone7478]

thank you for teaching but Indian acsend is super annoying

[@rajugunawan]

Thanks