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.
ARTICLE VERSION (RECOMMENDED): https://data36.com/sql-data-analysis-...
6-WEEK-DATA-SCIENCE COURSE: https://data36.com/jds
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:
SQL TUTORIAL EP#1 video: • SQL TUTORIAL EP#1: BASICS (SELECT, WH...
The whole SQL tutorial series: • SQL for Data Science and Analytics Tu...
LINKS MENTIONED IN THE EPISODE:
SQL cheat sheet: https://data36.com/newsletter
Learn SQL (10+ tutorial articles): https://data36.com/learn-sql-for-data...
7-day SQL online course: https://data36.com/sql-for-aspiring-d...
Article about subqueries, HAVING and CASE: https://data36.com/sql-data-analysis-...
Newsletter: https://data36.com/newsletter
Free mini-course: https://data36.com/how-to-become-a-da...
--------------------------------------------------------
Check my website: https://data36.com/jds
Get access to more data science tutorials, join the inner circle: https://data36.com/inner-circle
Find me on Twitter: / data36_com
Watch video Subqueries, HAVING, CASE... more advanced SQL concepts (tutorial for beginners in data science EP#5) online without registration, duration hours minute second in high quality. This video was added by user Data36 - Online Data Science Courses 28 December 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 16,90 once and liked it 56 people.