MySQL - The Basics // Learn SQL in 23 Easy Steps

[@marcellsworth287]

I literally spent $4,000 and four months on my college course for database management to learn what you just taught extremely well in 17 minutes.

[@shanetravel]

yeah its sad isnt it..

[@nikhilbajaj3797]

Spending 4k on learning one single subject is nuts bro

[@Robert-ov1wi]

Seriously, or just exaggerating?

[@marcellsworth287]

@@nikhilbajaj3797 yeah, but that’s what it costs per class at my university in the US (if you include the cost of room and board and fees and whatnot). I should have gone to a cheaper university, but my parents and older siblings expectations pushed me here. I had a great experience, but if I could go back and make a different decision I absolutely would

[@marcellsworth287]

@@legionsra I appreciate the kind words, and you’re absolutely right I won’t be pressuring my kids into the same situation I got pushed into. That book sounds extremely interesting, I’ll be looking into it 😁

[@SilveradoNL]

I been using MySQL for over 14 years now, yet i still watched a 17 minute video on 'The Basics'.... Totally worth it!

[@kilianlindberg]

Cool, same here. Since ~2002 😀

[@keremardicli4013]

Have you ever written pages long SQL queries? If so, what were the use cases? I really wonder :)

[@makotv6898]

@@keremardicli4013 Speed, in MSSQL for example procedures and triggers tend to be a lot faster then using a shit language like php. since everything is done within sql. All those shitty queries you tend to make with an ORM and some linked list garbage speed up tons. For example recently I had to generate questions for something based on the database that was being used. Alas I did it in MSSQL with procedures and triggers to build the whole procedure.

[@Rawyu]

Cool. I have a question if you don't mind i just started SQL out of curiosity. I understood how to make a database. My question is how do i make it user friendly i mean what if some one has to enter a data into my database but they shouldn't use insert statement. Something like a data entry form ? How do i make connections to database and data entry form ? Sorry if this is a stupid question

[@passionatebeast24]

@@Rawyu you can use HTML form along with php in your web app and sanitize your data . This way you can get user inserted data but avoid sql injection.

[@talhajubairsiam2197]

Two MySQL DBAs walk to a NoSQL bar, but they had to leave because they couldn't find any tables! :)

[@oussamakhalfi1751]

Two tables sitting in a bar then a select statement came and said can i join u??

[@DanielDaniel-xz2yp]

They also had to leave because they couldn't get in, the bar clearly has an agenda against SQLs

[@alvinxyz7419]

Why mysql walk into a bar that doesn't like relations...

[@oussamakhalfi1751]

@@alvinxyz7419 HAHAHAHAHAHAHAHAHHA

[@killerdroid99]

nice pun

[@jordanfoltz8729]

This one of the best examples of how to explain SQL I have ever seen. Watch other people talk for 4 hours, still no idea what hell they are talking about. This guy did 4 hours in 17 mins in a good way. Thank you sir. Thank you

[@stephen9849]

I saw a great movie about databases today. I can't wait for the SQL

[@shrin210]

Which movie?? Name?

[@No_Namee111]

Which movie?

[@WasiMaster]

@@No_Namee111 r/woooosh

[@WasiMaster]

@@shrin210 r/woooosh

[@xi_red4936]

Dang, they really didn't get the joke 🥶

[@flippyforever8186]

2 things for anyone still trying to use this guide in 2022 for Windows. The installer does not set the PATH variable for MySQL! You have to add the bin folder to your path variables manually. Also be sure to select the legacy authentication system when installing or else the VSCode extension he recommends won't work and give you a "Client does not support authentication protocol requested by server" error.

[@vonderklaas]

PIN!

[@idanlib]

Yes! Thank you! I had the same problem. ChatGPT helped :D But boosting this so others might see it.

[@rajns8643]

PIN THIS @Fireship

[@sanchitwadehra]

PIN THIS

[@hetgurjar5836]

Pin this

[@jakye]

"I use arch, btw" You had to say that, didn't you? 😂

[@sandunrathsara9102]

Linux users when they couldn't tell someone that they use linux for 5minutes => 🤯😭😷😱🤒

[@gurbux6491]

Legit laughed out loudly when he said that

[@earlh]

Arch users are like Harvard graduates, they'll get out of their way to let you know.

[@arifdevcoding]

i think i know what your profile picture is.. btw

[@ravenbergdev]

Purpose of this entire vid was to just be able to mention that 😂😂😂

[@stevie1da_]

This semester, I'm taking "Introduction to Databases" in college. This 17 minute video taught me more about databases and SQL than my professor has done in 15 weeks (8 hours a week). So as of now, the 120 hours I've spent in class < 17 minutes of this video

[@michaelwest2451]

College in a nutshell. Wish this was all covered in a trade school, we'd learn more in a year than getting a masters in CS.

[@arno.claude]

In this case, your college is really really bad, or you are a bad student.

[@J-Kimble]

sad reality of most colleges

[@aninnymoose720]

all that time spent in school is to learn that one thing u can't learn anywhere else. i was pissed

[@VICTORZITOSS]

​@@arno.claudeor he's memeing and doesn't realize that the only reason he was able to digest this video so easily is because he'd spent half a year working on it already

[@rohitkharche7562]

That drop keyword joke is Awesome 😂

[@simon.p]

It's amazing how much knowledge he can pack in into such a short amount of time, and yet make everything crystal clear 👏

[@hamzaseif4992]

i love how this dude summarized a whole college course in 17 mnts !

[@WesleyFranks]

how the education should be.

[@urbanlobster4812]

I have DBMS this sem, nice I watched it ahead 😂

[@alexismandelias]

You've never attended a college course have you...

[@willianandrade1357]

​@@alexismandelias I have and I must agree with this guy. For me it was 1 whole year of Database classes to see pretty much everything explained in the video except that it was in a totally different and harder manner. In the end (next semesters) you didn't even smell databases in posterior classes until the end of college if you didn't go to a "scientific research", which is pretty much a project with a teacher where you do 100% of the work and he get the credits for it.

[@willianandrade1357]

@@alexismandelias But that's my experience here in Brazil. I don't know where you live and where you've got your degree but I sure do hope it was someplace better than most of them.

[@PhuongNguyen-zb2en]

Thank you! My whole Database course in my university in just 17m straight!! That's all I have to review before my interview

[@AncientPenguin1399]

Me before 1hour- Should have paid more attention in my DBMS class Me now- Should have subscribed to Fireship a few months ago.

[@KangJangkrik]

9:12 "country" should be CHAR(2) instead of VARCHAR(2) Because country ID always has 2 characters and CHAR absolutely meant for fixed character length. Thus, long term disk usage + performance efficiency.

[@toopkarcher]

Didn't understand but I agree

[@xNaii1]

@@toopkarcher each data type takes a different amount of bites which effect disk space on the server as the database gets filled with data.

[@naturegirl1999]

@@xNaii1 how do you find how many bites one type takes up compared to another?

[@chrisobi02]

@@naturegirl1999 google is the way. Different types use different numbers of bytes to store them, and with regards to char vs varchar, if it's variable the system likely needs to set aside some extra space on the hardware to account for potential resizing etc

[@deadeye8]

​​@@toopkarcher he means that varchar can have a number of characters upto the length you specify, which means that if you tell it to have 255 it will go upto that number while also can be less for eg 200, 15 or even 0 which is Null. But char will always have fixed number not more not less and since no country code comprises less than two letters/chars you can tell dbms to have exactly two characters for country code. But as far as i think it won't save space and it it does it would be varchar instead.

[@cgme9535]

I've been through *many* SQL beginner courses. You certainly take the cake for explaining the concepts quickly and effectively.

[@cardboardmf2252]

Despite having used SQL for many years, I still watch the whole video, because I will probably learn something I didn't know!

[@Digital963]

As a former SQL dev I appreciate you making this video. Especially since ppl tend to have this weird idea about SQL that it’s an outdated complex technology when it really isn’t bad at all. Thank you 😊

[@40nakedniggasonahugespacecraft]

It is bad

[@Cahangir]

@mr.darkside35 Check out the responsibilities of a Data Architect or a Data Engineer. Must become one of the most respectable positions in IT in near future.

[@rayraysss]

Dude you have no ideia how your videos are helping me out

[@GamingMatt]

The fact that these videos are free blows my mind. So much knowledge in 17 minutes

[@shashanksshetty9870]

All your video contents are really great and helpful. For me, there was an instance where I had absolutely no context on the things to refer from. You always come up with a short and concise version concept. I really use your video content for brushing up. Trust me people who are watching all this video. "Short video which covers up all topic isn't an easy task". It takes lots of skills and experience to do so! Thank you for all you're content

[@Kevin-lr6jy]

Love that ending, legit startled me for a couple seconds 😂

[@Piston1776]

for people watching in 2023 @6:32 there will be a setting called "password mode" change it from "SQLTools Driver Credentials" to "Save as plaintext in settings"

[@vonderklaas]

Thanks, but I get this error for some reason, can you advice me something? ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client

[@dunyan1586]

@@vonderklaas same I need help toooo

[@Piston1776]

@@vonderklaas Moral of the story is you did something wrong in the configuration process

[@Piston1776]

@@vonderklaas Ok not sure what is wrong with youtube but I have replied several times to your comment and it never went through.

[@vonderklaas]

@@Piston1776 Weird, well it's okay!

[@asiessingh23]

That abrupt ending was hilarious 😂😂

[@AP-ol7tj]

I wish every tutorial on earth would seem like this... Everything is explicit, plain and simple. Even your screen resolution and graphical elements are so helpful. A great thank you for your work and sharing your knowledge with us!

[@Helloimtheshiieet]

That's also because SQL is literally purely declarative more so than any other language. So it comes across that way as well.

[@krtirtho]

Because you created this awesome SQL related video I think its hightime you make a ORM(s) related tutorial like TypeORM for Typescript Nodejs or the python one. A series on them will be more awesome💪

[@Fireship]

Will do! Also plan on covering tools like Hasura.

[@krtirtho]

@@Fireship Interesting, I heard about it before but never used it. Waiting for that🤞

[@gabor6259]

@@Fireship Hi. At 8:05 you say we add PRIMARY KEY to make id's unique. Then at 8:57 you say we add the UNIQUE constraint to make sure every email is unique. So what's the difference between PRIMARY KEY and UNIQUE?

[@violetwtf]

I am a full-time software engineer and am well versed in all of this. I just watch these because I really like your voice.

[@chaitanyakulkarni21]

My whole semester's DBMS syllabus covered in 17 min, Nice 🙄 🔥

[@ChaoticNeutralMatt]

Lmao. The feels.

[@K9amilo90]

really? seems pretty basic to me, and I'm about to graduate with master's degree

[@ahmadsyauki9346]

I literally spent a whole semester, 4 credit course, with weekly practical-assignment, just to learn it from you in 17 minutes, and your version is better. Thanks bro

[@talhaibnemahmud]

Damn! The ending was cool ❤

[@hk_200k]

I've always wanted to learn sql but this is the first video that I have watch from the beginning to the end. The speed is fast enough and the content is very useful, a very good showcase

[@JKCD]

Jeff you accidentally dropped the rest of the video using the drop keyword, please reupload it.😂😂

[@Fireship]

Thanks for watching the whole video!

[@uta481]

Trust me, I'm currently studying for Information Technology. We had a database(SQL) class/course and I didn't understand anything laid out by our teachers. This guy is a saver

[@4444altan]

"I use arch btw" How can you say something so controversial yet so brave. You are making me wish I was born later so I could learn everything in a good way from you lmao

[@JosephGallagher]

Had previously watched 2 years ago when I was starting to learn programming, re-watching as now I'm learning SQL to grow in my job. I understood so much better now, and I have no doubt I will re-visit sometime in the future again!

[@arshadpakkali]

Now i can add SQL to my resume, "I use arch btw" 😂

[@temaelbouaazzaoui8709]

I usually pause educative videos so many times because they are boring but I watch yours without pausing them, you are the best

[@KalleJillheden]

Fun trivia: the "My" in MySql stands for the Swedish author's daughter who was named My, which is pronounced like regular "M", plus the initial "Y" note from "You". It's not a pronunciation you have to change. Keep calling it MySql, as in "SQL that is mine", no need to confuse your coworkers about the native pronunciation of the app. It's like you have imported the name into your language, but haven't changed the spelling :P like how most languages do for other country names, ex Sweden vs Sverige, Germany vs Deutschland, MySQL vs MySQL :)

[@GANDHIXtv]

MariaDB

[@nyashachiroro2531]

This is hands down the best tutorial on mySQL and SQL... And its all in 17 Min 🤯🤯🤯

[@Christopher-ew7jw]

Thanks Jeff❤️ “I use arch btw”

[@sanjay_swain]

@Mr. Mehi arch is famous for really difficult to install and use (which is not entirely true) so telling "I use arch" is more of a flexing. Anyway it's not that hard to use honestly and recently you can also install arch with a proper installation interface (earlier you have to do all with command line).

[@sylvaniathehacker]

@@sanjay_swain jokes on you. You still have to do it command-line way because there's no GUI yet. Before it used to be copy-pasta from wiki now it's more over like selecting from the given option. I use mujiOS, btw

[@SilverDennis802]

12:19 just had me pass my interview with flying colors. So happy I watched this video 30 minutes before my interview! Thank you!

[@fishedinson1]

This is amazing! My first SQL video ever. I must say there is so much to digest that i My need to rewatch it a few more times.

[@scrapdev1219]

This channel never disappoints me. All the vital information is compressed into small videos and delivered efficiently in an entertaining way. This guy is a genius.

[@unizfrhn2803]

Easy to digest and thoroughly entertaining video on MySQL I've seen so far. Well done.

[@tylermcgirt7568]

I read my college text book over and over trying to understand normalization and It finally clicked when I watched this! Thank you so much!

[@juliankandlhofer7553]

Can you make a video about the difference between different SQL Databases? I don't really see why I would choose, for example, PostgreSQL over MySQL, MS SQL Server or even Oracle. Great stuff as always! 👍👍

[@vex6559]

Post is supposedly for enterprise lvl, big queries. MySQL is most effective in small to medium business, using light to mid queries.

[@mopishlynx2323]

Thanks so much for these insanely good tutorials! I needed a database for a project and had never touched SQL before; i got it up and running super quickly thanks to this video!

[@RideByAquib]

Glad I stumbled on this channel. All these short videos are amazing! This was a no-nonsense refresher to what I learned in College many years ago. Also enjoying the other vids. Subbed. 👍🏼

[@ashutoshshaha8165]

Damn... You never let your viewers down Best channel ever came across Thank you so much for existing! 🙇

[@kwangsamyew8469]

I needed this! I meant the video. A dolphin pillow would be nice too :)

[@88niyanta]

00:00 0. SQL is King 00:49 1. The Legend of Ted Codd 01:24 2. ORM Magic 02:00 3. What is a RDBMS? 02:37 4. Draw SQL Diagrams 02:56 5. Schemas, Datatypes, & Constraints 04:12 6. Be Normalized 05:00 7. Install MySQL on Windows/Mac 05:50 8. Create a New Database 06:13 9. SQLTools VS Code Extension 06:46 10. --comments 07:02 11. Basic SQL Syntax 08:04 12. Primary Key 08:31 13. Varchar vs Text 09:31 14. INSERT New Data 10:28 15. Read or SELECT Data 10:57 16. LIMIT & ORDER 11:23 17. Filtering with WHERE 11:50 18. LIKE pattern matching 12:19 19. INDEX for read speed 12:56 20. JOIN a relationship 15:41 21. Alias AS 16:08 22. JOIN through a middle man 16:58 23. DROP a video

[@avithedev]

So much info at such a short time

[@quinnh9964]

So much for studying this in school when you've got fireship ❤️

[@PhillipMwaniki]

This video taught me what a left join and a right join does. Been writing raw queries but I always stick to inner join. Thanks man.

[@abhishekpratap05]

Semester worth knowledge in 17+ mins 😂 great work as always. Ending was smart and hilarious 😂

[@reboa.i563]

This man single-handedly explained everything in 17 minutes what my teacher tried to explain in 2 months. Damn, I should’ve found this channel sooner lmao

[@retronav]

Thank you for uploading this video! This helps me cover all things I need for this semester as well as my project. Keep up the good work, Jeff!

[@rayandogy1278]

Thank God for this Channel 😭😭😭😭😭😭 I am literally crying rn. As a self-taught front end developer it really means a lot to know how the backend works😊 thanks Fireship🔥🔥

[@Bersling]

I think UPDATE, GROUP BY and COUNT should also have made it into the video as they are very bread-and-buttery for SQL. Another thing: I really much prefer working with something like JooQ than an ORM. You get safety and flexibility at the same time. And SQL is actually really easy to learn (as you have shown), so no need for an ORM! They'll only slow you down by being a weird black box you'll have to mess with after some point.

[@yash1152]

what is JooQ??

[@thrillhouse4784]

​@@yash1152writing sql in Java

[@Biowulf21]

This has slowly become my favorite tech channel ngl

[@amanraj1608]

Notification squad 🙋🏻‍♂️

[@noelricardo2861]

Congratulations, yo explain the basics in 17.16 min, nailed. I been working with SQL Server and stored procedure for 15 years, and want use this video to explain the basics to my kids

[@sidrao2006]

"Google is your best friend" - (Almost) Every developer's motto

[@szhzs6121]

duckduckgo*

[@chotai]

@@szhzs6121 no developer needs that much privacy in code-time. Google is much better in it.

[@thedarkthrone4699]

Yup

[@Sud0nym-w2q]

I've been banging my head against my keyboard trying to wrap my head around the foreign/primary key functionality as I need it for a project. Thank you so much for illustrating that clearly. This video was awesome.

[@vuhoang7109]

Thank you much for this awesome, simple tutorial! I'm eager to learn more of this good stuff about SQL.

[@neonmarker6994]

If this was a try not to laugh challenge I'd be mad because of the last second of the video I'd have lost the game. Information was a bit too dense at indexing, joining, referencing and aliasing for the first time but then I watched the video multiple times and read about it a little more and it became clear. Thank you! Awesome introduction to sql.

[@kaze-xo]

16:40 The code here is incorrect and will NOT work the way you intend it to, because: the "Rooms.owner_id = guest_id" part will find rooms where the owner is also the guest (i.e. owner books his/her own room), instead, it should be replaced with "Rooms.id = room_id" which matches room ID in Rooms table and Bookings table. Otherwise, excellent informative video!

[@MC-hc7wx]

I agree with it being incorrect and your fix being the good one, but what his code will do is rather returning all (owner, room) pairs for each booking the owner has made anywhere no ?

[@kazuyakoyama4501]

I never comment on KZbin. But, for you I had to. You're simply a Beast. Thanks for these contents man. It saves so much time, money and frustration... Much love to you🙏

[@shakirulhasan]

"I use Arch, btw" Nice flexing, bro 😉

[@qwerasdfhjkio]

thank you

[@ridl27]

could anyone explain the joke about Arch ?! xD

[@qwerasdfhjkio]

@@ridl27 long story short, arch users for some reason always had to mention that they use arch to the point that it became a meme

[@americangulag]

Your voice is the best for teaching tech/coding hands down.

[@ParamKeshkamat]

Me: from today I must sleep less and study more Goes to youtube for studying... KZbin video: MySQL pillow giveaway

[@Working55]

You are the greatest person on Earth! Exactly what I searched the net - straight to it. Thanks!

[@fred.flintstone4099]

Never name your primary keys just "id", name them after the table name, example "user_id", "room_id", "booking_id" etc. This will make JOINs easier.

[@keithsloan994]

the sign-off was great. good work my dude, and thank you!

[@sidrao2006]

Woah.. How? I just had to start with MySQL and Fireship to the rescue! 🔥

[@AbdulelahAGR]

Literally the best SQL course in the world!

[@staywithmesenpai]

"how do you know, that someone is using arch..."

[@nothjg]

I was looking for my SQL tutorial bang you are here with that amazing tutorial in 17 mins

[@sahilrahman1494]

It is said that the MySQL pillow will help you store all the exam notes...

[@flapa2010]

I guess many didn't notice, you used the drop statement to end the video lol. Thanks for the teaching style. its a 17mins video but you could come back to it for years especially those of us who are not core database engineers.

[@liuhc]

Somehow my professor with phd in CS failed to explain join operations clearer than you did. Legend man, legend

[@zkierkniekjion4381]

This is the best summary of the language to get acquainted with the information before my college course

[@ginocode]

SQL seemed simple enough until I saw things like foreign keys and JOIN statements. Now they actually make sense. Thanks!

[@ahurein1641]

I've been on this channel for years now and people always comment about how you made a video on the topic they wanna learn abt, but it hasn't happen to me before until I was given cscd 313(database management) assignment to submit next two days lol Love from Ghana 🇬🇭

[@sagarhindochaa]

That ending though 👑 Summarized nicely in 17mins, good format.

[@harshmudhar96]

Would 100% recommend the book SQL Performance Explained. It's written about db indexes from the perspective of a developer writing business code for a database (or even designing the database) but who is not a DBA.

[@afshin3k3]

Thank you so much for this tutorial! I used this video to learn SQL for the first time touching SQL. It was an awesome tutorial! This (plus a quick review of w3schools exercises) helped me to pass the assessment for a Data Analysis job interview.

[@DouglasFish]

I learned most of this scraping around the internet about two weeks ago. I've watched many of your videos I feel like a dummy for not trying to find this sooner, I learned a few extra tricks.

[@hetaliauchiha]

AHHHH HOW IS THIS SO MORE USEFUL THAN MY COLLEGE CLASSES? thanks man

[@StanEby1]

More helpful information per frame than any video I have ever seen. Thank you.

[@basilsunnyalukka3507]

Dropped the video at the right time ! i was preparing for a mySQL test

[@versol111]

I'm currently learning MySQL and this video was really helpful.

[@sahilsayani1505]

the ending is ELITE.

[@mikk0706]

In 17 minutes i have learned more than in a year in school Thx

[@keokawasaki7833]

first, best sql tutorial i have ever watched second, "i use arch, btw" third, i would have lost my crap if the video id in the video happened to be the actual video id ( i am tripping)

[@robertodelgado6387]

This is incredibly well explained in 17 minutes

[@LG-wb1jf]

thanks again fireship!! your my favorite channel about programming

[@pharmokan]

literally the best dev channel in all of youtube. congrats on your future 1mil subscribers. hopefully you'll get it before 2021 ends

[@SherlyPadua-me5kd]

I'm 12 and MySQL is soo hard for me but this video made me feel it easier to learn

[@markschellhas]

I use all kinds of databases, SQL is still the best language for querying data easily. Thanks for this video 🙌🏽

[@adnanamin1843]

Learned so many new information about SQL. FIREShip on FIRE!

[@farzamkhoddam438]

thanks for the video. It was relatively short but it covered all the crucial concepts of mysql and sql in general