Advancing your skills with SQL - SQL教程

内容

• Introduction Introduction

  • Advancing your skills with SQL

    27 秒
  • What you should know

    27 秒
  • CoderPad introduction

    1 分钟 38 秒
• 1. Product Analytics in SQL with CTEs 1. Product Analytics in SQL with CTEs

  • (已锁定)
    Summarizing customer data for leadership

    2 分钟 14 秒
  • (已锁定)
    Combining aggregate functions with CTEs

    6 分钟 49 秒
  • (已锁定)
    Introduction to CTEs

    3 分钟 36 秒
  • (已锁定)
    Solution: Pull descriptive statistics with a CTE

    7 分钟 51 秒
  • (已锁定)
    Solution: Explore variable distributions with CTEs

    5 分钟 20 秒
  • (已锁定)
    Solution: Payment funnel analysis with CTEs

    10 分钟 56 秒
• 2. Data Transformation in SQL with CASE 2. Data Transformation in SQL with CASE

  • (已锁定)
    Translating status codes into business acumen

    2 分钟 50 秒
  • (已锁定)
    Recoding and bucketing values using CASE

    4 分钟 18 秒
  • (已锁定)
    Introduction to CASE

    4 分钟 45 秒
  • (已锁定)
    Solution: Creating binary columns with CASE

    5 分钟 4 秒
  • (已锁定)
    Solution: Create aggregated columns with CASE

    7 分钟 47 秒
• 3. Combining Multiple Data Sources in SQL with UNION 3. Combining Multiple Data Sources in SQL with UNION

  • (已锁定)
    Combining multiple email lists

    3 分钟 48 秒
  • (已锁定)
    Combining multiple data sources with UNION

    4 分钟 10 秒
  • (已锁定)
    Introduction to UNION

    3 分钟 30 秒
  • (已锁定)
    Solution: Combine product tables with UNION

    2 分钟 22 秒
  • (已锁定)
    Solution: Unpivoting columns into rows using UNION

    3 分钟 44 秒
• 4. Dealing with Hierarchical Data in SQL with Self Joins 4. Dealing with Hierarchical Data in SQL with Self Joins

  • (已锁定)
    Dealing with hierarchical data

    1 分钟 28 秒
  • (已锁定)
    Relating users and admins using a self join

    4 分钟 4 秒
  • (已锁定)
    Introduction to self joins

    2 分钟 26 秒
  • (已锁定)
    Solution: Employee-manager data with a self join

    6 分钟 30 秒
  • (已锁定)
    Solution: Comparing rows within the same table

    6 分钟 14 秒
• 5. Solving Advanced Problems in SQL with Window Functions 5. Solving Advanced Problems in SQL with Window Functions

  • (已锁定)
    Pulling the most recent sales data

    2 分钟 23 秒
  • (已锁定)
    Rank(), row_number(), and dense_rank()

    2 分钟 55 秒
  • (已锁定)
    Pulling the most recent sale with row_number()

    3 分钟 31 秒
  • (已锁定)
    Introduction to window functions

    3 分钟 30 秒
  • (已锁定)
    Solution: Get running totals with window functions

    6 分钟 22 秒
  • (已锁定)
    Solution: Timestamp differences with LEAD()

    6 分钟 54 秒
• Conclusion Conclusion

  • (已锁定)
    Continuing on with SQL

    36 秒