Published 1/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: 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 beginners
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 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!
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 (Lifetime 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
Recommend Download Link Hight Speed | Please Say Thanks Keep Topic Live
Links are Interchangeable - No Password - Single Extraction
