Learn SQL Basics in Just 15 Minutes!

Learn SQL basics with this tutorial in just 15 minutes.

In this tutorial, you'll learn how to use SQL using mySQL. First, you'll learn what SQL is and the different relational database management systems. Second, you'll learn to install mySQL in your computer. Third, you'll learn to import a real database for you to practice.
Then we'll get into writing queries. First we'll write simple SELECT statements, then SELECT with DISTINCT, and eventually aggregate functions such as COUNT or AVG. We'll then move on to filtering using the WHERE statement. Following that we'll learn to GROUP BY, ORDER BY, and even add a LIMIT. Finally, you'll learn to export your query scripts and results table and importing it into Excel or Power BI.

LEARN:

SOCIALS:

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

Chapters:
0:00​ -​ SQL Intro
0:58​ - Installing mySQL
2:40​ - Importing a Real Database
4:04​ - SELECT statement
5:30 - DISTINCT
6:00 - Aggregate Functions
8:40​ - Filtering with WHERE
10:55 - Combing SELECT, COUNT & WHERE
11:45 - GROUP BY, ORDER BY and LIIMIT
15:10 - Exporting Data

[travelrepeat]

Please make a playlist to teach us SQL from beginner to Pro, thanks man

[alecseidman]

Please make a full series, this was so helpful!

[nainglinnphyoe]

I set off to data analytics career from sales career through your videos and it was really effective to me for its clear explanations with case study materials . I have learnt Power BI for data cleansing, visualization and reporting and now on the way to SQL with you. Thanks a million and you are the best !

[DhrumitMehta]

Really enjoyed this! Would love a Part 2

[sonngy]

Hey man, your videos landed me an offer, just wanted to thank you

[Osborne]

Hey Kenji, thanks for the video
Just started learning SQL recently.

[ShimaGodlove]

I'm literally taking a data science course but now that you explained it deeply and understandably I'm slightly getting every query and it's logic. looking forward for more like this one for real. Thanks bro!

[petermapoma]

I like the way you teach especially the fact that you make complicated things simple that's a plus. I don't regret subscribing to your channel.

[Babyk]

Kenjii you are so smarttt, please upload a second part!!

[goldennuggetinfo]

This is my very first SQL video. I clicked through a few and knew this would be best. Perfect walk through.

[mayowaadeleye]

Really enjoyed the video. Definitely looking forward to part 2. Thank you

[thaivang]

I'd love to see you make videos on Python as well. You always provided us with the best content.

[aymen]

You a king for this for real, every other video about sql are just guys yappin about useless things, you got straight to the point, keep up the good work man

[shambhavimehrotra]

So well and patiently explained! Thank you, Kenji!

[alexcolombu]

Could you make a video on overall formatting and margins in excel from beginner to advanced? Thank you and love your videos.

[Monalove]

You covered some essential tips on how to write the code in a cleaner format. Awaiting the next part to this series.

[janegathiaka]

Great content. Love the way you simplify difficult topics in a short time. Thanks Kenji

[mirwansiregar]

Thank you so much Kenji, your channel is very resourcefull...you make it as main reference for everyone to learn data analyst

[markuskankare]

Thanks a lot man. I'm studying Software Engineering in University and having exam from this topic. Helped a lot!

[j.b.]

Dang! This is so good. Your course looks way better than the courses on Coursera. Looks well thought out and very practical with a fun set of data to use.