Published 1/2023MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHzLanguage: English | Size: 876.43 MB | Duration: 1h 59m

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

Requirements

No SQL experience needed, this course is well suited for bners

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 SQLLearn the basics of SQL and how to write queriesRecognize important product metrics and how to interpret themBuild your own metrics using SQLLearn to quickly visualize your metrics and report them efficientlyIn 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 life 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 bners 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!

Overview

Section 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

Section 2: SQL

Lecture 6 Intro

Lecture 7 Selecting Columns

Lecture 8 Exercise 1: Select

Lecture 9 Exercise 1 solution

Lecture 10 Exercise 2: Select part II

Lecture 11 Exercise 2 solution

Lecture 12 Where

Lecture 13 Exercise 3: Where

Lecture 14 Exercise 3 solution

Lecture 15 Dates

Lecture 16 Logical operations

Lecture 17 Exercise 4

Lecture 18 Exercise 4 solution

Lecture 19 Matching operators I: IN

Lecture 20 Exercise 5: IN

Lecture 21 Exercise 5 solution

Lecture 22 Matching operators II: Like

Lecture 23 Exercise 6: Like

Lecture 24 Exercise 6 solution

Lecture 25 NULL values

Lecture 26 Sorting: Order by

Lecture 27 Exercise 7: Order By

Lecture 28 Exercise 7 solution

Lecture 29 Aggregations

Lecture 30 Exercise 8: Aggregating

Lecture 31 Exercise 8 solution

Lecture 32 Grouping

Lecture 33 Exercise 9: Group By

Lecture 34 Exercise 9 solution

Lecture 35 Exercise 10: Group by part II

Lecture 36 Exercise 10 solution

Lecture 37 Joins

Lecture 38 Exercise 11: Inner Join

Lecture 39 Exercise 11 solution

Lecture 40 Exercise 12

Lecture 41 Exercise 12 solution

Lecture 42 Exercise 13

Lecture 43 Exercise 13 solution

Section 3: Product metrics

Lecture 44 Intro

Lecture 45 Metric fundamentals

Lecture 46 MRR (Monthly Recurring Revenue)

Lecture 47 Exercise 14 solution

Lecture 48 ARPU (Average Revenue Per User)

Lecture 49 Exercise 15 solution

Lecture 50 LTV (Life Value)

Lecture 51 MAU (Monthly Active Users)

Lecture 52 Exercise 16 solution

Lecture 53 Exercise 17

Lecture 54 Exercise 17 solution

Lecture 55 Retention

Lecture 56 Exercise 18 solution

Lecture 57 CSAT (Customer Satisfaction)

Lecture 58 Exercise 19 solution

Lecture 59 Bonus: Vizualizing metrics

Lecture 60 Reporting metrics

Section 4: Conclusion

Lecture 61 Conclusion

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

HomePage: