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

Focused View

Luis Andrade

1:59:14

58 View

1 - Introduction

1 - Introduction.mp4

01:45

2 - SQL concepts.mp4

02:26

3 - Installing MySQL on MacOS.mp4

02:30

4 - Installing MySQL on Windows.mp4

03:55

5 - Creating the database.mp4

05:31

5 - create-db-business.zip

2 - SQL

6 - Intro.mp4

00:37

7 - Selecting Columns.mp4

07:11

8 - Exercise 1 Select.mp4

00:09

9 - Exercise 1 solution.mp4

00:25

10 - Exercise 2 Select part II.mp4

00:14

11 - Exercise 2 solution.mp4

01:06

12 - Where.mp4

03:49

13 - Exercise 3 Where.mp4

00:06

14 - Exercise 3 solution.mp4

00:42

15 - Dates.mp4

02:00

16 - Logical operations.mp4

04:50

17 - Exercise 4.mp4

00:08

18 - Exercise 4 solution.mp4

01:05

19 - Matching operators I IN.mp4

02:14

20 - Exercise 5 IN.mp4

00:08

21 - Exercise 5 solution.mp4

00:59

22 - Matching operators II Like.mp4

01:47

23 - Exercise 6 Like.mp4

00:08

24 - Exercise 6 solution.mp4

01:03

25 - NULL values.mp4

01:01

26 - Sorting Order by.mp4

03:00

27 - Exercise 7 Order By.mp4

00:10

28 - Exercise 7 solution.mp4

01:26

29 - Aggregations.mp4

05:42

30 - Exercise 8 Aggregating.mp4

00:07

31 - Exercise 8 solution.mp4

00:30

32 - Grouping.mp4

03:09

33 - Exercise 9 Group By.mp4

00:06

34 - Exercise 9 solution.mp4

00:46

35 - Exercise 10 Group by part II.mp4

00:08

36 - Exercise 10 solution.mp4

01:11

37 - Joins.mp4

13:22

38 - Exercise 11 Inner Join.mp4

00:09

39 - Exercise 11 solution.mp4

01:05

40 - Exercise 12.mp4

00:07

41 - Exercise 12 solution.mp4

01:18

42 - Exercise 13.mp4

00:25

43 - Exercise 13 solution.mp4

05:33

3 - Product metrics

44 - Intro.mp4

01:00

45 - Metric fundamentals.mp4

02:13

46 - MRR Monthly Recurring Revenue.mp4

00:43

47 - Exercise 14 solution.mp4

04:12

48 - ARPU Average Revenue Per User.mp4

01:12

49 - Exercise 15 solution.mp4

01:01

50 - LTV Lifetime Value.mp4

02:16

51 - MAU Monthly Active Users.mp4

01:34

52 - Exercise 16 solution.mp4

01:09

53 - Exercise 17.mp4

00:12

54 - Exercise 17 solution.mp4

02:54

55 - Retention.mp4

02:24

56 - Exercise 18 solution.mp4

04:04

57 - CSAT Customer Satisfaction.mp4

00:44

58 - Exercise 19 solution.mp4

01:31

59 - Bonus Vizualizing metrics.mp4

03:25

60 - Reporting metrics.mp4

03:50

4 - Conclusion

61 - Conclusion.mp4

00:47

Description

Learn the basics of SQL, important product metrics, and how to combine both to make better data-drive decisions!

What You'll 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 is this for?

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

More details

Description
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!

Who this course is for:
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

User Reviews

Rating

average 0

Total votes0

Focused display

SQL

Luis Andrade

Instructor's Courses

As a seasoned data scientist with a wealth of experience in growing products from zero to millions of active users, I bring a unique perspective to my role as a data science instructor. With a background in seed stage tech startups and extensive experience at a major bank, where I led the development of AI-powered recruitment tools, and Spotify, where I built internal integrity products to keep our users safe, I am well-versed in the intricacies of data science and product development. My current role as a lead data scientist at Instagram (Meta) has provided me with even more opportunities to develop and grow products in the creator monetization and blockchain spaces.With over 500 students taught since 2019, I have a proven track record of successfully teaching and mentoring students in the field of data science. My hands-on approach, combined with my real-world experience, makes me the ideal instructor for students looking to learn from a seasoned professional and gain valuable insights into the industry.I understand that learning data science can be a daunting task, especially for those who are new to the field. That's why I want to share with you my own journey in learning the course content. Like many of you, I had to teach myself several concepts of data science and product development. I spent countless hours reading books, experimenting with different tools and techniques, and learning from others in the industry in companies such as Spotify and Meta. I know that the process of learning can be frustrating and time-consuming, but I also know that it's worth it. I want to provide you with the knowledge and guidance that I wish I had when I was starting out. I am excited to share my experience with you and help you navigate your own journey in learning data science and product.In my spare time, you can find me reading a nice book, trying out new food, and exploring the world!

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.