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.

#dev #database #100SecondsOfCode

Install the quiz app 🤓

Use code lORhwXd2 for 25% off your first payment.

My VS Code Theme

- Atom One Dark
- vscode-icons
- Fira Code Font

[danieljayne]

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

[erwinmesi]

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

[anupjoseph]

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

[FM-kloc]

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.

[CoenCritcho]

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

[RedShift]

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!

[stokbrood]

in 100 minutes/days/years... We'll never know

Edit: The title originally didn't contain "Seconds"

[degree]

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

[tobiasrasmussen]

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!

[independent]

when reccomendations are quicker then notifications

[AdityaKumar-fltb]

I was searching for this!

Thank you for the video!

Keep the hard work going! 🔥🔥🔥🔥

[fyd]

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.

[cormanec]

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

[Thokpower]

Why did I learn more from this 100 second free YouTube 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.

[Iforgotme]

I retired in 2000. I was the data base administrator, and was generating a report for a merchandise manager. Two days before I retired, I coded the report in SQL. I entered two command sequences in the console and picked up the report a couple of minutes later. As I was leaving the console, it hit me: it would have taken a week of Cobol (15 years writing Cobol) coding and testing to generate the same report.

[candiedskull]

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

[penguinmonk]

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

[kokomanation]

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

[FunGuyxx]

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