HOT

SQL with a focus on Product metrics by ex-Spotify & Meta DS

Development

Rating4.9
Enroll Now

SQL with a focus on Product metrics by ex-Spotify & Meta DS, available at $74.99, has an average rating of 4.88, with 61 lectures, 19 quizzes, based on 4 reviews, and has 34 subscribers.

You will learn about Learn the basics of SQL and how to write queries on your own Understand important product metrics to empower you to craft your own metrics and those relevant to your products Learn how to use SQL to calculate and track key product metrics, such as monthly active users and retention Learn how to interpret product metrics and how to use them to inform strategy, product decisions, and marketing campaigns This course is ideal for individuals who are This course is great for anyone working with with products or aspirpring to work with products or Product managers who want to be able to extract insights from data using SQL or Entrepreneurs who want to learn SQL in order to better understand and track the performance of their own products or Data analysts and data scientists who want to improve their SQL skills for working with product metrics or Business analysts who want to learn SQL in order to better understand and analyze product data or Marketing professionals who want to use SQL to track and analyze the performance of marketing campaigns It is particularly useful for This course is great for anyone working with with products or aspirpring to work with products or Product managers who want to be able to extract insights from data using SQL or Entrepreneurs who want to learn SQL in order to better understand and track the performance of their own products or Data analysts and data scientists who want to improve their SQL skills for working with product metrics or Business analysts who want to learn SQL in order to better understand and analyze product data or Marketing professionals who want to use SQL to track and analyze the performance of marketing campaigns.

Enroll now: SQL with a focus on Product metrics by ex-Spotify & Meta DS

Summary

Title: SQL with a focus on Product metrics by ex-Spotify & Meta DS

Price: $74.99

Average Rating: 4.88

Number of Lectures: 61

Number of Quizzes: 19

Number of Published Lectures: 61

Number of Published Quizzes: 19

Number of Curriculum Items: 80

Number of Published Curriculum Objects: 80

Original Price: £19.99

Quality Status: approved

Status: Live

What You Will Learn

  • Learn the basics of SQL and how to write queries on your own
  • Understand important product metrics to empower you to craft your own metrics and those relevant to your products
  • Learn how to use SQL to calculate and track key product metrics, such as monthly active users and retention
  • Learn how to interpret product metrics and how to use them to inform strategy, product decisions, and marketing campaigns

Who Should Attend

  • This course is great for anyone working with with products or aspirpring to work with products
  • Product managers who want to be able to extract insights from data using SQL
  • Entrepreneurs who want to learn SQL in order to better understand and track the performance of their own products
  • Data analysts and data scientists who want to improve their SQL skills for working with product metrics
  • Business analysts who want to learn SQL in order to better understand and analyze product data
  • Marketing professionals who want to use SQL to track and analyze the performance of marketing campaigns

Target Audiences

  • This course is great for anyone working with with products or aspirpring to work with products
  • Product managers who want to be able to extract insights from data using SQL
  • Entrepreneurs who want to learn SQL in order to better understand and track the performance of their own products
  • Data analysts and data scientists who want to improve their SQL skills for working with product metrics
  • Business analysts who want to learn SQL in order to better understand and analyze product data
  • Marketing professionals who want to use SQL to track and analyze the performance of marketing campaigns

This course covers the basics of SQL and important product metrics. The course will empower you to use SQL to extract insights from your data and make data-driven decisions to improve any product you work with.

Learn and Master the Most Important Product Metrics Using SQL

  • Learn the basics of SQL and how to write queries

  • Recognize important product metrics and how to interpret them

  • Build your own metrics using SQL

  • Learn to quickly visualize your metrics and report them efficiently

In this course, we will start by introducing you to the basics of SQL, including how to structure a query, the different types of data in SQL, and how to filter and sort data. You will also learn how to work with multiple tables using joins.

Once you have a solid understanding of the basics, we will move on to cover the most commonly used product metrics. These include metrics such as monthly active users, retention, recurring revenue, and customer lifetime value. You will learn how to use SQL to compute these product metrics. and uncover meaningful insights about a product. You will also learn to use SQL to visualize data using simple spreadsheets.

Throughout the course, there are several hands-on exercises to help you practice what you’ve learned. You will also be provided with examples to help you understand how these concepts can be applied in the real world. After spending years working in Big tech companies such as Spotify and Meta, and having instructed hundreds of students, I’ve built this course to allow you to master the basics at your own pace.

This course is designed for beginners who want to learn the basics of SQL and how to use it to analyze product metrics. It is perfect for anyone who wants to learn SQL and how to use it to analyze product metrics, whether you are (or aspire to be) a product manager, marketer, analyst, data scientist, or product enthusiast. SQL and product metrics are two extremely in-demand skills, and adding them to your resume will make you stand out.

By the end of this course, you will have a solid understanding of SQL and how to use it to analyze product metrics. Enroll now and start learning how to use SQL to analyze product metrics and drive growth for your career or business!

Check out the free preview videos for more information, and see you in the course!

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: SQL concepts

Lecture 3: Installing MySQL on MacOS

Lecture 4: Installing MySQL on Windows

Lecture 5: Creating the database

Chapter 2: SQL

Lecture 1: Intro

Lecture 2: Selecting Columns

Lecture 3: Exercise 1: Select

Lecture 4: Exercise 1 solution

Lecture 5: Exercise 2: Select part II

Lecture 6: Exercise 2 solution

Lecture 7: Where

Lecture 8: Exercise 3: Where

Lecture 9: Exercise 3 solution

Lecture 10: Dates

Lecture 11: Logical operations

Lecture 12: Exercise 4

Lecture 13: Exercise 4 solution

Lecture 14: Matching operators I: IN

Lecture 15: Exercise 5: IN

Lecture 16: Exercise 5 solution

Lecture 17: Matching operators II: Like

Lecture 18: Exercise 6: Like

Lecture 19: Exercise 6 solution

Lecture 20: NULL values

Lecture 21: Sorting: Order by

Lecture 22: Exercise 7: Order By

Lecture 23: Exercise 7 solution

Lecture 24: Aggregations

Lecture 25: Exercise 8: Aggregating

Lecture 26: Exercise 8 solution

Lecture 27: Grouping

Lecture 28: Exercise 9: Group By

Lecture 29: Exercise 9 solution

Lecture 30: Exercise 10: Group by part II

Lecture 31: Exercise 10 solution

Lecture 32: Joins

Lecture 33: Exercise 11: Inner Join

Lecture 34: Exercise 11 solution

Lecture 35: Exercise 12

Lecture 36: Exercise 12 solution

Lecture 37: Exercise 13

Lecture 38: Exercise 13 solution

Chapter 3: Product metrics

Lecture 1: Intro

Lecture 2: Metric fundamentals

Lecture 3: MRR (Monthly Recurring Revenue)

Lecture 4: Exercise 14 solution

Lecture 5: ARPU (Average Revenue Per User)

Lecture 6: Exercise 15 solution

Lecture 7: LTV (Lifetime Value)

Lecture 8: MAU (Monthly Active Users)

Lecture 9: Exercise 16 solution

Lecture 10: Exercise 17

Lecture 11: Exercise 17 solution

Lecture 12: Retention

Lecture 13: Exercise 18 solution

Lecture 14: CSAT (Customer Satisfaction)

Lecture 15: Exercise 19 solution

Lecture 16: Bonus: Vizualizing metrics

Lecture 17: Reporting metrics

Chapter 4: Conclusion

Lecture 1: Conclusion

Instructors

  • Luis Andrade
    Luis Andrade
    Data Scientist @ Instagram, Instructor, Mentor

Rating Distribution

  • 1 stars: 0 votes
  • 2 stars: 0 votes
  • 3 stars: 0 votes
  • 4 stars: 1 votes
  • 5 stars: 3 votes

Frequently Asked Questions


How long do I have access to the course materials?


You can view and review the lecture materials indefinitely, like an on-demand channel.


Can I take my courses with me wherever I go?


Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

You may also like

The Ultimate Digital Marketing and Ecommerce Masterclass

The Marketing Management Masterclass: Marketing Strategy MBA

ChatGPT Secrets | ChatGPT Mastery | ChatGPT Masterclass