Solve Real-World Data Problems with SQL

Focused View

2:08:29

62 View

01 - Introduction

01 - Advancing your skills with SQL.mp4

00:27

02 - What you should know.mp4

00:27

03 - CoderPad introduction .mp4

01:38

02 - 1. Product Analytics in SQL with CTEs

01 - Summarizing customer data for leadership.mp4

02:14

02 - Combining aggregate functions with CTEs.mp4

06:49

03 - Introduction to CTEs.mp4

03:36

04 - Solution Pull descriptive statistics with a CTE.mp4

07:51

05 - Solution Explore variable distributions with CTEs.mp4

05:20

06 - Solution Payment funnel analysis with CTEs.mp4

10:56

03 - 2. Data Transformation in SQL with CASE

01 - Translating status codes into business acumen.mp4

02:50

02 - Recoding and bucketing values using CASE.mp4

04:18

03 - Introduction to CASE.mp4

04:45

04 - Solution Creating binary columns with CASE.mp4

05:04

05 - Solution Create aggregated columns with CASE.mp4

07:47

04 - 3. Combining Multiple Data Sources in SQL with UNION

01 - Combining multiple email lists.mp4

03:48

02 - Combining multiple data sources with UNION.mp4

04:10

03 - Introduction to UNION.mp4

03:30

04 - Solution Combine product tables with UNION.mp4

02:22

05 - Solution Unpivoting columns into rows using UNION.mp4

03:44

05 - 4. Dealing with Hierarchical Data in SQL with Self Joins

01 - Dealing with hierarchical data.mp4

01:28

02 - Relating users and admins using a self join.mp4

04:04

03 - Introduction to self joins.mp4

02:26

04 - Solution Employee-manager data with a self join.mp4

06:30

05 - Solution Comparing rows within the same table.mp4

06:14

06 - 5. Solving Advanced Problems in SQL with Window Functions

01 - Pulling the most recent sales data.mp4

02:23

02 - Rank(), row number(), and dense rank().mp4

02:55

03 - Pulling the most recent sale with row number().mp4

03:31

04 - Introduction to window functions.mp4

03:30

05 - Solution Get running totals with window functions.mp4

06:22

06 - Solution Timestamp differences with LEAD().mp4

06:54

07 - Conclusion

01 - Continuing on with SQL.mp4

00:36

More details

User Reviews

Rating

average 0

Total votes0

Focused display

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.