Subqueries, HAVING, CASE... more advanced SQL concepts (tutorial for beginners in data science EP#5)

In this episode, I’ll show you some more advanced SQL moves! Okay, I’d rather put them into the intermediate category. They are not beginner things — but that’s also for sure that junior data scientists can’t live without them.

00:00 Intro
01:27 SQL subqueries (query in a query)
08:41 Subquery syntax requirements
09:31 Test yourself #1
10:23 SQL CASE (the "if statement" of SQL)
16:37 SQL HAVING clause
21:57 Test yourself #2
22:46 Conclusion

PREVIOUS EPISODES:

LINKS MENTIONED IN THE EPISODE:

--------------------------------------------------------

[osoriomatucurane]

Awesome tutorial. The concept is intuitivo, running a query usong previous result, as chaining. In the example given, it is clear how you get the aggregate min and max of all data set by collapsing the table. Well done

[umairmir]

Waiting for your next two videos! Really helpful!

[naveenkalyan]

Tons of thanks brother! Can I get flights table dataset?

[altareq]

You explain complex things in very easy way. I appriciate your effort. You were setting self assessment questions, but unfortunately I did not find any link downloading the Dataset and without that it was impossible practicing on your self test questions rather than just watching the video.

[shovonchowdhury]

Great video. Would be great if you had a diagram of the database schema with all the tables with their rows and columns.

[thecodenerd]

Did anyone tell you that look very similar to Paul Rudd? Btw great video and explanation of concepts

[akansha_bhatt]

Hi Tomi,
I loved your SQL playlist. Can you make a playlist too on Python for Data Science?

[lindseyhristov]

Where can the dataset be accessed to enable me to practice your question

[davidbarnwellutech]

Do you have anything on Machine Learning in say, MATLAB?

[majdzatar]

i am using google cloud how can i get the table you are working with so i can practice

[chimaokoro]

Where can I get the data for This tutorial?

[camo]

Hello, is it possible to group many rows into one output row? example, print 'early', 'late' and 'ontime' on one output row.

[subhanbasha]

Hello Tomi,
Is it recommend to code all the machine learning algorithms from scratch so that I can learn math behind it or just understand and start to code?

[oscarmartuasinaga]

i think problem number 1 can be solved easily by just write *Limit 1* at the bottom of your query.