1

Advanced SQL Window Functions & Ranking

Description

Mastering Complex Calculations Description: Dive deep into advanced window functions and ranking functions in SQL. Learn how to perform complex calculations across partitions, calculate running totals, identify top performers, and analyze trends within datasets. This includes exploring RANK(), DENSE_RANK(), ROW_NUMBER(), NTILE(), LAG(), LEAD(), CUME_DIST(), PERCENT_RANK(), and their practical applications in growth analysis. Resources/Activities: Expected Outcomes:

Available

Learning Objectives

  • Understand the fundamentals
  • Apply practical knowledge
  • Complete hands-on exercises
2

Optimizing SQL Queries for Growth Analysis

Query Tuning and Performance Description: Learn about SQL query optimization techniques. Focus on indexing, query plan analysis, understanding execution costs, and refactoring inefficient queries. Explore the impact of various database systems (e.g., PostgreSQL, MySQL, BigQuery) on query performance, and learn how to tailor your optimization strategies based on the specific database in use. Resources/Activities: Expected Outcomes:

Locked

Learning Objectives

  • Understand the fundamentals
  • Apply practical knowledge
  • Complete hands-on exercises
3

Advanced SQL for Cohort Analysis

Segmentation, Time-Series Analysis, and Forecasting Description: Focus on using SQL for advanced cohort analysis, including segmenting users, analyzing their behavior over time, and building predictive models. Learn to calculate cohort retention rates, conduct time-series analysis to identify trends and seasonality, and create forecasts using SQL. Resources/Activities: Expected Outcomes:

Locked

Learning Objectives

  • Understand the fundamentals
  • Apply practical knowledge
  • Complete hands-on exercises
4

SQL for A/B Testing Analysis

Statistical Significance and Results Reporting Description: Learn to use SQL for analyzing A/B testing results. This includes calculating statistical significance, identifying statistically significant differences between test groups, and building comprehensive reports on test performance. Resources/Activities: Expected Outcomes:

Locked

Learning Objectives

  • Understand the fundamentals
  • Apply practical knowledge
  • Complete hands-on exercises
5

SQL for Funnels and User Journey Analysis

Mapping User Flows Description: Focus on using SQL to map user journeys and analyze conversion funnels. This includes understanding user behavior across different steps, identifying bottlenecks in the funnel, and visualizing user flows using SQL. Resources/Activities: Expected Outcomes:

Locked

Learning Objectives

  • Understand the fundamentals
  • Apply practical knowledge
  • Complete hands-on exercises
6

Working with JSON Data in SQL

Advanced Data Extraction and Manipulation Description: Learn how to handle JSON data within SQL. This is crucial for growth analysts as much of the data comes in JSON format. Explore JSON functions in different SQL dialects (e.g., JSON_EXTRACT, JSON_VALUE, JSONB in PostgreSQL, JSON_TABLE in MySQL) and learn how to extract specific information, parse JSON structures, and manipulate JSON data for analysis. Resources/Activities: Expected Outcomes:

Locked

Learning Objectives

  • Understand the fundamentals
  • Apply practical knowledge
  • Complete hands-on exercises
7

SQL for Data Visualization and Reporting – Connecting SQL to BI Tools & Automating Reports

Description: This day focuses on connecting SQL queries to Business Intelligence (BI) tools (e.g., Tableau, Power BI, Looker) and automating report generation. Learn to create data visualizations, build interactive dashboards, and schedule automated reports based on SQL queries. Resources/Activities: Expected Outcomes:

Locked

Learning Objectives

  • Understand the fundamentals
  • Apply practical knowledge
  • Complete hands-on exercises

Share Your Learning Path

Help others discover this learning path