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, WHERE, ...   The whole SQL tutorial series:    • SQL for Data Science and Analytics Tutoria...   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