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

سرفصل های دوره

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

1 - Introduction

1 - Introduction

2 - SQL concepts

3 - Installing MySQL on MacOS

4 - Installing MySQL on Windows

5 - Creating the database

5 - create-db-business.zip

2 - SQL

6 - Intro

7 - Selecting Columns

8 - Exercise 1 Select

9 - Exercise 1 solution

10 - Exercise 2 Select part II

11 - Exercise 2 solution

12 - Where

13 - Exercise 3 Where

14 - Exercise 3 solution

15 - Dates

16 - Logical operations

17 - Exercise 4

18 - Exercise 4 solution

19 - Matching operators I IN

20 - Exercise 5 IN

21 - Exercise 5 solution

22 - Matching operators II Like

23 - Exercise 6 Like

24 - Exercise 6 solution

25 - NULL values

26 - Sorting Order by

27 - Exercise 7 Order By

28 - Exercise 7 solution

29 - Aggregations

30 - Exercise 8 Aggregating

31 - Exercise 8 solution

32 - Grouping

33 - Exercise 9 Group By

34 - Exercise 9 solution

35 - Exercise 10 Group by part II

36 - Exercise 10 solution

37 - Joins

38 - Exercise 11 Inner Join

39 - Exercise 11 solution

40 - Exercise 12

41 - Exercise 12 solution

42 - Exercise 13

43 - Exercise 13 solution

3 - Product metrics

44 - Intro

45 - Metric fundamentals

46 - MRR Monthly Recurring Revenue

47 - Exercise 14 solution

48 - ARPU Average Revenue Per User

49 - Exercise 15 solution

50 - LTV Lifetime Value

51 - MAU Monthly Active Users

52 - Exercise 16 solution

53 - Exercise 17

54 - Exercise 17 solution

55 - Retention

56 - Exercise 18 solution

57 - CSAT Customer Satisfaction

58 - Exercise 19 solution

59 - Bonus Vizualizing metrics

60 - Reporting metrics

4 - Conclusion

61 - Conclusion

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training