Solve Real-World Data Problems with SQL

سرفصل های دوره

01 - Introduction

01 - Advancing your skills with SQL

02 - What you should know

03 - CoderPad introduction

02 - 1. Product Analytics in SQL with CTEs

01 - Summarizing customer data for leadership

02 - Combining aggregate functions with CTEs

03 - Introduction to CTEs

04 - Solution Pull descriptive statistics with a CTE

05 - Solution Explore variable distributions with CTEs

06 - Solution Payment funnel analysis with CTEs

03 - 2. Data Transformation in SQL with CASE

01 - Translating status codes into business acumen

02 - Recoding and bucketing values using CASE

03 - Introduction to CASE

04 - Solution Creating binary columns with CASE

05 - Solution Create aggregated columns with CASE

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

01 - Combining multiple email lists

02 - Combining multiple data sources with UNION

03 - Introduction to UNION

04 - Solution Combine product tables with UNION

05 - Solution Unpivoting columns into rows using UNION

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

01 - Dealing with hierarchical data

02 - Relating users and admins using a self join

03 - Introduction to self joins

04 - Solution Employee-manager data with a self join

05 - Solution Comparing rows within the same table

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

01 - Pulling the most recent sales data

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

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

04 - Introduction to window functions

05 - Solution Get running totals with window functions

06 - Solution Timestamp differences with LEAD()

07 - Conclusion

01 - Continuing on with SQL

189,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: LinkedIn Learning (Lynda)