You've mastered the basics of aggregating and joining data in your database—what's next? This intermediate course dives into essential SQL techniques to help you manipulate, transform, and interpret data effectively. You'll expand your SQL skillset by learning to wrangle, filter, and categorize information with powerful tools like CASE statements, subqueries, and window functions. Along the way, you'll explore fascinating insights about soccer using the European Soccer Database, gaining the skills to tackle complex questions with ease.
Timestamps:
0:00 Welcome to Intermediate SQL!
3:02 In CASE things get more complex
6:41 CASE WHEN with aggregate functions
10:11 WHERE are the Subqueries?
13:58 Subqueries in FROM
17:05 Subqueries in SELECT
20:21 Subqueries everywhere! And best practices!
23:54 Correlated subqueries
27:26 Nested subqueries
30:40 Common Table Expressions
34:08 Deciding on techniques to use
37:42 Window Functions
41:22 Window Partitions
44:21 Sliding windows
47:18 Bringing it all together
#sql #database #dataanalysis #sqltutorial #IntermediateSQL #SoccerData #learnsql #datawrangling #sqlfunctions #datascience #windowsfunction #coding