SQL Hands-On Practice: Solve Business Problems

Introduction

• Advancing your skills with SQL
• What you should know
• CoderPad introduction

1. Product Analytics in SQL with CTEs

• Summarizing customer data for leadership
• Combining aggregate functions with CTEs
• Introduction to CTEs
• Solution: Pull descriptive statistics with a CTE
• Solution: Explore variable distributions with CTEs
• Solution: Payment funnel analysis with CTEs

2. Data Transformation in SQL with CASE

• Translating status codes into business acumen
• Recoding and bucketing values using CASE
• Introduction to CASE
• Solution: Creating binary columns with CASE
• Solution: Create aggregated columns with CASE

3. Combining Multiple Data Sources in SQL with UNION

• Combining multiple email lists
• Combining multiple data sources with UNION
• Introduction to UNION
• Solution: Combine product tables with UNION
• Solution: Unpivoting columns into rows using UNION

4. Dealing with Hierarchical Data in SQL with Self Joins

• Dealing with hierarchical data
• Relating users and admins using a self join
• Introduction to self joins
• Solution: Employee-manager data with a self join
• Solution: Comparing rows within the same table

5. Solving Advanced Problems in SQL with Window Functions

• Pulling the most recent sales data
• Rank(), row_number(), and dense_rank()
• Pulling the most recent sale with row_number()
• Introduction to window functions
• Solution: Get running totals with window functions
• Solution: Timestamp differences with LEAD()

Conclusion

• Continuing on with SQL