MySQL - The Basics // Learn SQL in 23 Easy Steps
814,546
Published 2021-04-16
Buy the MySQL Pillow fireshipio-swag.creator-sprin...
References
Diagram drawsql.app/fireship/diagrams/airbnb-mysql-tutoria…
Installer dev.mysql.com/downloads/installer/
MySQL Docs dev.mysql.com/doc/
#mysql #database #tutorial
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
Install the quiz app 🤓
iOS itunes.apple.com/us/app/fireship/id1462592372?mt=8
Android play.google.com/store/apps/details?id=io.fireship.…
Upgrade to Fireship PRO at fireship.io/pro
Use code lORhwXd2 for 25% off your first payment.
My VS Code Theme
- Atom One Dark
- vscode-icons
- Fira Code Fon
All Comments (21)
-
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.
-
Two MySQL DBAs walk to a NoSQL bar, but they had to leave because they couldn't find any tables! :)
-
I been using MySQL for over 14 years now, yet i still watched a 17 minute video on 'The Basics'.... Totally worth it!
-
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
-
"I use arch, btw" You had to say that, didn't you? 😂
-
I saw a great movie about databases today. I can't wait for the SQL
-
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.
-
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.
-
That drop keyword joke is Awesome 😂
-
Jeff you accidentally dropped the rest of the video using the drop keyword, please reupload it.😂😂
-
It's amazing how much knowledge he can pack in into such a short amount of time, and yet make everything crystal clear 👏
-
I've been through many SQL beginner courses. You certainly take the cake for explaining the concepts quickly and effectively.
-
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💪
-
i love how this dude summarized a whole college course in 17 mnts !
-
Me before 1hour- Should have paid more attention in my DBMS class Me now- Should have subscribed to Fireship a few months ago.
-
Thank you! My whole Database course in my university in just 17m straight!! That's all I have to review before my interview
-
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 😊
-
My whole semester's DBMS syllabus covered in 17 min, Nice 🙄 🔥
-
Despite having used SQL for many years, I still watch the whole video, because I will probably learn something I didn't know!
-
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
