SQL Explained in 100 Seconds

Learn the fundamentals of Structured Query Language SQL! Even though it's over 40 years old, the world's most popular databases still run on SQL.
Foreign key basics docs.microsoft.com/en-us/sql/...
#dev #database #100SecondsOfCode
Draw SQL Diagrams drawsql.app/
Install the quiz app 🤓
iOS itunes.apple.com/us/app/fires...
Android play.google.com/store/apps/de...
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 Font

[@danieljayne8623]

Why am I watching this when I have 10 years of SQL experience? Can't get enough of these videos!

[@shishkebab64]

@John Doe Sounds like SQL was too difficult for you

[@phatakom]

@@shishkebab64 🤣🤣🤣

[@danieljayne8623]

I probably used MongoDB about 9 years ago for the first time 😄 The two aren't mutually exclusive

[@prasannavenkatesh8245]

@@shishkebab64 LoL 😂😂😂

[@mihajanstrehovec5114]

Passive agressive much @everyone

[@erwinmesi]

Maybe we can change the title to: "Your College Semester in 100 seconds"?

[@ChaoticNeutralMatt]

Lmao 🤣

[@-indeed8285]

🤣🤣🤣

[@shalinisil9214]

Yess

[@DR3WS1]

This would cover the first 3 weeks of my 1st DB module in college

[@_boris]

still more comprehensive than my college DB modules

[@FM-kl7oc]

SQL: Instead of describing every step necessary to produce a wanted end result, you instead describe what you want the end result to look like, and the database will figure out the steps necessary to produce that end result for you. This aspect of SQL and query engines have always fascinated me.

[@luisbeneyto6154]

P

[@rodrigozanabria2978]

@@luisbeneyto6154 riveting statement

[@SuperBlackReality]

Well, it was just ahead of it's time with all this: the computer knows better spoiler: it doesn't

[@reilandeubank]

@@user-bj4lp3fr1o And now I can tell chat GPT about a database and ask it in plain english what Data I want and it can write a valid query 99% of the time

[@Alixdkari]

lol why did they make sql when they can just use a filter on an excel sheet? dumb nerds!

[@anupjoseph7368]

sequel for short, now that's how you settle both sides of a debate

[@smellyD5655]

If you want to shorten it, say "squeal". Save another syllable.

[@GavHern]

im sure that he spent a little bit of time figuring out how to make everyone satisfied haha

[@smellyD5655]

And pronounce "vi" "six"

[@stolensentience]

The guy who coined it pronounced it as “sequel”

[@smellyD5655]

@@stolensentience that line of reasoning has not settled the gif pronunciation debate either.

[@CoenCritcho]

An SQL Query walks into a bar and goes up to two tables and asks "Can i join you?"

[@-Cocell]

An*

[@RedShift5]

Some pro tips after years of experience: use singular type (table) names, use a fully descriptive name for the primary key (player_id, team_id, ...) and reuse those names for foreign keys, make sure to properly apply constraints (foreign key constraints and for example a column can only contain a value between 0 and 10), try to avoid NULLs as much as possible, don't bother with datetime types (just use bigint unix timestamp and always ALWAYS store in UTC), learn as much about your database server as you can because it can do a lot more than you think, use the force!

[@uv42]

I've always wanted to use a bigint Unix timestamp but wherever I've worked they always use a date time. Had to fix so many bugs related to timezones.

[@UliTroyo]

DrawSQL looks like such a neat tool.

[@frankhuurman3955]

thanks for the tool name :) was actually curious about it. Too bad there isn't a free variant on this

[@azventures8038]

@@frankhuurman3955 There is, for public tables

[@SumanRoy.official]

​@@frankhuurman3955mysql workbench, it ain't that beautiful to look at but its good, else you can pirate dbforge

[@frankhuurman3955]

@@SumanRoy.official Thanks! I'll check it out :)

[@stokbrood]

in 100 minutes/days/years... We'll never know Edit: The title originally didn't contain "Seconds"

[@samarmohan9891]

lol, its funny that i said that first but you got more likes :D

[@benouattara6249]

@@samarmohan9891 it's funny that you are tracking his numbers of likes

[@thisbevibhor]

@@samarmohan9891 How the turntables.

[@Fireship]

That's what happens when you publish from your phone 🤦‍♀️

[@benouattara6249]

@@Fireship gotta make an AI for that

[@degree1996]

The only channel where I'd watch something i already know about regarding computer science, your videos are captivating man, keep it up

[@kushal6065]

cuz it's short and sweet with soothing and relaxing voice

[@rinie875]

@@kushal6065 lmao true

[@tobiasrasmussen4347]

I am just now learning SQL Server and your video is God-sent. I mean, the concise explanation, the language used, the graphical representations, etc. It's just perfectly done!

[@56independent42]

when reccomendations are quicker then notifications

[@drjoriv]

Yep

[@Abhishek-dp5tc]

Lmao same

[@AdityaKumar-fl1tb]

I was searching for this! Thank you for the video! Keep the hard work going! 🔥🔥🔥🔥

[@cormanec210]

Early enough for the title to be "SQL Explained in 100' without the 'seconds'

[@sodiboo]

title written in less than 100 lmao

[@softwarelivre2389]

yes

[@cormanec210]

Holy crap... now I know how effective being early is when making your comment.

[@f2yd]

They took half a year to explain this in Uni and you did in 100 seconds, nicely done! I might be wrong, but at 2:01 the "primary" and "foreign" labels seem to be swapped.

[@Ali2307013]

You are right about the last point. You seem very focused haha.

[@mikoajfiedorczuk9431]

it's more like it takes half a year to fully understeand what is he saying in those 100s

[@kennyelkhart]

I bet they took half a year to explain this and *much* more to give you a proper understanding. If they didn’t, you got ripped off.

[@captainlennyjapan27]

Thanks for this cuz I was confused a bit

[@Thokpower1]

Why did I learn more from this 100 second free KZbin video than the thousand dollar university course I took

[@sessionswithtemitope]

Thanks to this I understand what primary key and foreign key is. I would like to see an extended tutorial on all JOINs and some random Clauses like Trigger.

[@candiedskull9841]

I love watching your explanations before I really dive into something, and then later after I've done some more in-depth learning. Still waiting on the rewatch for when I actually "know" something though

[@creatingwithcode1630]

Greg Ostertag... there's a blast from the past. Another great vid Jeff. Thx! 👍🏾

[@kokomanation]

I am an amateur developer and your videos have really helped me gain spherical knowledge on CS

[@stanleywarren129]

I'm a huge basketball fan and know nothing about sql but the fact that you used basketball as your example really helped me alot

[@penguinmonk7661]

Wonderfully efficient, thank you. This was a master class in minimalized visual explanation .

[@BarbaHectic]

Absolutely love these series!

[@nolram]

This was great, I cant wait for the SQL !

[@poloyc]

I really like your videos! Short, but FULL of content. Thanks for sharing ;)

[@OleksandrBorysenko333]

I'm trying to learn SQL and this video gives me a bit more understanding! It helps 👍

[@gregor3148]

I primarily use MySQL 8 for everything. Tried lots of time to shift to other db but nothing beats the power of SQL. I might perhaps switch something else in future but in generally, all my production apps are running smoothly on MySQL. With JSON type supported, it becomes even more useful

[@kuldipthakkar2606]

I just love your explaination....Simple...Short...Superrr 🥳

[@n_core]

>Video about SQL Everyone else: Talk about database, data manipulation, MySQL, PostgresSQL, SQL Server, etc. Me: Civilization V & VI modding!

[@FunGuyx0x]

1:50 shouldnt be the where clause after the join :D?

[@manishbfmv]

Ya same question..

[@stevie1da_]

I'm required to take a database class for my cs degree, this video just summarized the entire content of that class

[@Max-42]

Awesome as always!

[@lelosithole7402]

Wow great explanation makes it soooo easy , Thank you !

[@ruaidhrilumsden]

Sorry for the downer but in MS SQL Server the statement at the end of the video wouldn't work. The WHERE clause has to come after the JOIN statement. I haven't used much of MySQL and haven't touched any of the others so not sure if the syntax varies and it lets you do it that way.

[@esclavodeluna8000]

My college makes us use the oracle standard and I don't think it would work either.

[@dammitanothername]

LOL this logic in the video wouldn't work anywhere. They all need the source before they can limit the source's data. So joins come before the where clause. i've worked on ms sql, mysql, redshift, snowflake, oracle, sqlite, access...all kinds of tech. good catch. very astute.

[@ejm110]

I am not programmer but a network guy, I really do enjoy your videos

[@mridulbarman027]

I like you videos even before played, and you never disappoint me ❣️

[@rakshitpatel9664]

Mark my words In near future this channel will be on top choices of every Developer in the world.

[@RayMangan]

hello from the future, you were right!

[@ubisuccle]

This alone taught me more than my college Databases class

[@RuiAndrada]

Like without see, it's always a terrific vídeo!

[@davidabba7663]

short and on the point thank you

[@dovinhas]

i learn in this short video, more any other course or tutorial even books. congrats.

[@kiwihour333]

About to do this in school. Thanks for the explanation

[@kaojaicam]

Excellent description, thanks

[@Ari-ej6lb]

Thanks, perfect timing

[@dan6erbond]

Me: Has been using SQL for years. Also me: Watches anyway because Jeff's about to blow my mind.

[@abdulwahidgul]

I think you have to join the table and then set the where condition. The other way would give your an error

[@Phatrikko]

Was wondering which flavor of SQL that is. The WHERE goes at the end in mssql, mysql, and I think Oracle. Can't speak to any others though.

[@EinKesselBuntes]

Each part of the query is executed sequentially and the order is a bit different to how you read the statement. The execution order is as follows: [1] FROM and JOINs [2] WHERE [3] GROUP BY [4] HAVING [5] SELECT [6] DISTINCT [7] ORDER BY [8] OFFSET

[@penguindrummaster]

@@EinKesselBuntes You separate DISTINCT and ORDER BY but I was somewhat certain that DISTINCT relied on a SORT operation to complete to guarantee the uniqueness of the returned set (it's a small nitpick that doesn't really matter). The thing that does matter, and why I appreciate you grouping FROM and JOINs on the same item, is that just because an item is listed first (like FROM before a JOIN) doesn't guarantee that query processor will start there. It's one of those intermediate lessons you learn after working with it forever that you have little control over the order of operations, and generally the best you can do is nudge it in your intended direction, lol

[@anonymousrashiyama1432]

Looking forward to more Database interview topics, please

[@fercho3689]

I just learned more about it here than in my one semester class

[@thelaitas]

Thanks, I never knew that Greg Ostertag played for the Jazz

[@adnanamin1843]

Loved it! ✌️

[@samuelsamuel4099]

Mom: no we already have mysql at home Mysql at home: Excel

[@santokhan_]

Thank you. It helps❤️❤️❤️

[@PterPmntaM]

Great video and tool for drawing diagram

[@MorganHvidt]

Full SQL tutorial would amazing 🙏

[@echoptic775]

Bruh, im not kidding i started learning sql yesterday and u made the video

[@AkshaySinghJamwal]

Wow, really informative video.

[@poglord._]

Amazing work 😁.

[@jackass984you]

good vid, full sql tutorial would be awesome

[@renu3463]

More on Svelte firebase

[@Fireship]

Sveltekit is looking very cool

[@renu3463]

@@Fireship it uses Snowpack under the hood, I guess.

[@codeaperture]

What about sapper ? Will it ever be released??

[@electrolyteorb]

@@codeaperture nope

[@electrolyteorb]

happy to see svelte enthusiasts... :)

[@FilipCodes]

Sql tutorial cant wait!!

[@adilelkhallouki6634]

thanks I like clear and short 👍

[@tapu_]

My homies use Json as database.

[@softwarelivre2389]

On small test projects I even use csv as database and then keep calling string.trim().split(' ').map(row => row.trim().split(';').map(cell => cell.trim()));

[@Amaraticando]

For POC tests and fake APIs, try json-server. For real stuff, a real database is the way.

[@lancemarchetti8673]

Nice!... lambda loves squirrel sql mounted on a svelte backend that regulates Hugo along transitional database contracts. Tash hags included! . Yay!

[@patrickck8185]

yeah lets go for the full tutorial..

[@panzach]

@ 2:02 Primary/Foreign labels should be swapped: `Players.team_id` is the Foreign key and the `Teams.id` is the Primary key

[@KishanKa]

Great start for beginners. Could you please make a short and detailed video on mongodb?

[@ThomasGodart]

While I generally like those short videos, this one is mostly wrong or lacks important concepts, for a change. Databases are not "based on SQL" they're based on what is called an "engine", and the SQL language is just the API that is used to access it. Tables don't need a key. Keys can span over multiple columns. Accessing data needs to be done through indexes for performance, and indexes can also span to multiple columns. Databases also deal with events and can cascade behaviour to enforces certain integrity contrains. SQL also has capacities for mutation over the scheme of the data, and most of the databases engines can perform those mutations while the database is running other requests in parallel, and those requests will succeed.

[@Fireship]

I agree, there are some areas for improvement here. Working on a full SQL video and taking your comment into account.

[@FabricioLucianoCastillo]

please, do a full video. It'll be awsome

[@KTechy-]

Great explantion❤❤

[@pixiedev]

Loved this explanation. Plz make full sql video. #fireship #fireshipio #100secofcode

[@TheOrteme]

FULL TUTORIAL IS VERY NICE IDEA

[@Tarotakii]

Did you ever do the full tutorial? I'm taking Database at my college and your explanation cleared a bunch of things I didn't understand. :)

[@demonslayer8502]

really awesome man

[@cockroachdb]

Impressive Greg Ostertag reference.

[@asina1773]

Thanks for the video, I'm a business student and I'm primarely interested in marketing. Do you guys think that learning SQL to making analysis on using a data for marketing purposes helps me out?

[@funkykong9001]

Excellent!

[@GKNaidu-hb5zv]

informative video.. ♥️ from India

[@the_linguist_ll]

You would not believe how much of a lifesave SQL is during linguistic fieldwork

[@marlonmarcello]

A full SQL tutorial please!

[@monkemode8128]

No clue what any of this means but sounds interesting, nice video 👍👍

[@sufler7180]

Awesome - as ussual

[@jorritwegman9143]

Fun video! It would have been nice if you added in that SQL is a descriptive language, so the text you write isn't actually executed. It's translated to an optimized script, which then gets executed.

[@ShadowriverUB]

Its executive code as it technicly same as commands and have procedural features and you can execute in sequance. Lot of classical php cms install by not having information how database is constucted which would be descriptive, but sequance of sql queues which builds the database. What you dezcribe could be said about C or C++ or C#. Also programing languages can addapt sql like features like Linq in C#

[@Amplifimusic]

Can you do a video of Gemini? The middle ground between Gopher and http

[@okopyl]

Yeah, please make a complete tutorial on SQL

[@trustnt1337]

Easiest video about SQL

[@rajitgupta1140]

a full tutorial on sql pls 🥺

[@ganeshgoogly4832]

Redux in 100s..... awaiting 🙏

[@pharmokan]

MIND BLOWN FOREIGN KEY

[@codingisinourdna]

Structured Query Language , SQL or Sequel for short *lol , this made me distracted for the first minute and had to rewatch 😆

[@fernandoorozco3474]

He should stop asking "... If you wanna see", of course we want to, I mean, it's a fireship video. 🔥

[@ninoverre]

I just landed junior analyst position only by watching this video. many thanks

[@songokussj4cz]

I'm kind of "new" to SQL (mssql) and right now I have few tables with relations, no problem. But how do I design a table for USER SETTINGS? I mean for example site background (and few others). Where and what values would the table have for logged in users?

[@sahh7089]

Thanks so much

[@ibrahim--]

Basketball examples made it so much easier

[@thenamewhowillknockksidown7333]

i love your content

[@francoperez869]

Sequel tutorial pleaseeee :D

[@dammitanothername]

this is good for beginners. The hard part is learning how to think in logical terms to get what you want. the last sql statement in the video is wrong. as someone pointed out the where clause is mistakenly placed before the join.

[@FredrikPlays]

very nice

[@yan2410]

Thank you sir

[@prakhartiwari9296]

Great video

[@toxaq]

The most important part was missed: ACID compliance. You can actually trust and rely on the data integrity, unlike most document databases...

[@Nikola9517]

i was searching for this dumb comment ngl