Solve Real-World Data Problems with SQL

Download Now


Files Included :

01 - Advancing your skills with SQL.mp4 (1.65 MB)
MP4
02 - What you should know.mp4 (732.48 KB)
MP4
03 - CoderPad introduction.mp4 (3.09 MB)
MP4
01 - Summarizing customer data for leadership.mp4 (3.1 MB)
MP4
02 - Combining aggregate functions with CTEs.mp4 (12.87 MB)
MP4
03 - Introduction to CTEs.mp4 (4.97 MB)
MP4
04 - Solution Pull descriptive statistics with a CTE.mp4 (15.64 MB)
MP4
05 - Solution Explore variable distributions with CTEs.mp4 (9.87 MB)
MP4
06 - Solution Payment funnel analysis with CTEs.mp4 (21.78 MB)
MP4
01 - Translating status codes into business acumen.mp4 (3.81 MB)
MP4
02 - Recoding and bucketing values using CASE.mp4 (7.71 MB)
MP4
03 - Introduction to CASE.mp4 (7.16 MB)
MP4
04 - Solution Creating binary columns with CASE.mp4 (9.28 MB)
MP4
05 - Solution Create aggregated columns with CASE.mp4 (15.58 MB)
MP4
01 - Combining multiple email lists.mp4 (4.99 MB)
MP4
02 - Combining multiple data sources with UNION.mp4 (7.96 MB)
MP4
03 - Introduction to UNION.mp4 (4.72 MB)
MP4
04 - Solution Combine product tables with UNION.mp4 (3.87 MB)
MP4
05 - Solution Unpivoting columns into rows using UNION.mp4 (6.04 MB)
MP4
01 - Dealing with hierarchical data.mp4 (1.86 MB)
MP4
02 - Relating users and admins using a self join.mp4 (9.59 MB)
MP4
03 - Introduction to self joins.mp4 (3.16 MB)
MP4
04 - Solution Employee-manager data with a self join.mp4 (13.87 MB)
MP4
05 - Solution Comparing rows within the same table.mp4 (12.27 MB)
MP4
01 - Pulling the most recent sales data.mp4 (3.21 MB)
MP4
02 - Rank(), row number(), and dense rank().mp4 (3.97 MB)
MP4
03 - Pulling the most recent sale with row number().mp4 (6.2 MB)
MP4
04 - Introduction to window functions.mp4 (4.74 MB)
MP4
05 - Solution Get running totals with window functions.mp4 (11.64 MB)
MP4
06 - Solution Timestamp differences with LEAD().mp4 (13.36 MB)
MP4
01 - Continuing on with SQL.mp4 (1.97 MB)
MP4