Data Manipulation in SQL Full Course
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
On this page of the site you can watch the video online Data Manipulation in SQL Full Course with a duration of hours minute second in good quality, which was uploaded by the user Code Path 11 January 2025, share the link with friends and acquaintances, this video has already been watched 679 times on youtube and it was liked by 22 viewers. Enjoy your viewing!
