If you want to work independently with data without the help of an analyst — solve Big Data cases using SQL, as a Product Manager in a large international company.
SQL Basics
for Product Managers
HANDS-on COURSE
Practice in SQL and Superset
Live application with data
Real product cases
14000+
38%
★4.8/5
alumni since 2020
come from colleagues’ recommendations
average review score
19000+
PMs in our community
trusted by:
Student reviews
This is my third course from Product Do. I started with basic and TechPM, and continued with Data-Driven PM. As always: practical knowledge, no water. Practice on simulators is a very valuable thing. By its specifics, I work more with web analytics and the course allowed me to expand and structure my understanding of product analytics and the tools used.
An excellent course for practicing Product Analysts. The simulator and Superset helped to test new knowledge in practice and fill the cones. After the course, the desire to dive into big data and manage it has become much greater. Already in practice, I use SQL to get data on my own. Making a decision or getting answers to questions has become much faster. It's great to be in the first group of this course. I am sure that Konstantin and Andrew will improve the simulators.
A great course for PMs who want to improve in analytics. A lot of practice, and real cases. After the course, I got a systematic approach to product analytics, my life will not be the same anymore:) It will be especially cool for those who did not get the data themselves and did the analyses only in Excel.
For me, Product Do products are the training of a "healthy person" (not a smoker). The theory is always given concisely and deepens in the process of real tasks. The content itself is based on the realities of different companies, not ideal conditions disconnected from reality and quotes from books. I can advise new participants to reserve time for the timely completion of all tasks, and immersion in additional materials. Then the effect will be maximum!
The ProductDo platform is a godsend. In the world of information saturation, it is difficult to find something like this today. The content of the course, the presentation, and the form reveal the given topic as much as possible: clear, clear, and sustained. The interactive simulator really brings you closer to the essence of the PM's work and the style of communication in real life. The level of detail impressed and inspired me. This, by the way, is another huge bonus. At the end of the course, there is a sense of clarity, a more holistic understanding of the system and its role in it, and, as a bonus, a desire to move forward and practice new techniques in real life. After completing the course, I have significantly improved the area related to metrics on my current project. ProductDo do an excellent job, nurturing specialists of their profile, and at the same time cultivating a love for this process. I was inspired to take another course in my specialty: I want to restructure the features of the PM role. I am sure that the picture will eventually be wide and complete. I highly recommend it. Have fun doing everything!
A cool introduction to SQL for those who have always wanted to, but it seemed difficult.
I figured out the pyramid of metrics, drew the problems of the average in my head, and justified why it is necessary to segment users. I wrote down some new visualizations, which were brought to working dashboards. Thanks to the exercises of the course, I began to use schemes more often in my work and I noticed that they help me think more logically.
I figured out the pyramid of metrics, drew the problems of the average in my head, and justified why it is necessary to segment users. I wrote down some new visualizations, which were brought to working dashboards. Thanks to the exercises of the course, I began to use schemes more often in my work and I noticed that they help me think more logically.
Many thanks to the guys from Product Do Andrew and Kostya! I took a course for Data-Driven products with them. Course design: style. The simulation lessons are well written, there are hints and comments on why the authors offer such solutions. In general, I am super-pleased with the acquaintance with the ProductDo team, I like that the course is not much promoted, a kind of chamber class, but with a strong team. As for practice, in my work tasks, I even looked at my notes and returned to some lessons. I recommend the course to PMs who have already worked with metrics and analytics. There will be no general presentation and introductory lectures here, we immediately solve cases;)
A great course to get a boost in the direction of becoming a real Data-driven PM. Now, when solving product tasks, I know how to look at the data and which data to look at. For me, the combination of live webinars and practical tasks in the simulator became ideal for maximum perception of the material. A cool bonus was a huge number of links to very useful articles and resources. Thank you very much to Andrew and Kostya, you are great professionals!
A look from the outside from someone who understands the technical part more than the product part. The SQL topic is disassembled in a cool manner, enough to start from scratch and to the level of minimal understanding of queries that developers can share with you when you request the calculation of some metrics. There is a lot of practice, we managed to apply the theory. It was very cool that you could give an example of your project and disassemble it in class. We have clearly figured out where the data comes from in order to count metrics, build a system from them, and analyze work on the product.
The coolest thing I found in this course is a section with funnels, a hierarchy of metrics, and working with Superset. There were a lot of different pieces of information from some articles and experience in my head, but the course supplemented it all with cool examples, webinars and helped to sort it all out so that this knowledge could be applied in practice.
From the point of view of practical application, I have already managed to apply the part with the hierarchy of metrics, which helped to better build the structure and priorities of the product line.
From the point of view of practical application, I have already managed to apply the part with the hierarchy of metrics, which helped to better build the structure and priorities of the product line.
I work in a related field as a Project Manager, but in the past, I was a Business/System Analyst. Since the company is small, I often perform Product Owner tasks on a number of projects. I want to do my job better and bring cool ideas to the team. This was the reason for the course. Data-Driven PM is my first course with ProductDo and my first introduction to what a Product Owner should do in large companies. This course is about the practice of defining and collecting metrics, working with various programs for their analysis, and working with data using SQL. The first part about SQL was easy because I'm a tech person. The part about solving product tasks via SQL was much more difficult.
How You'll Become a PM Powerhouse
Product Manager
Data-Driven PM
Owns SQL, extracts data, builds dashboards
Confidently works with Big data
Asks the right questions and finds insights in the data
Does not let chance fool them
I've heard something about data analysis
I've seen Big data only in pictures
Remembers the basic concepts of statistics
Builds metrics in an SQL query
Speaks with the analyst in different languages
Knows about CTR and MAU
Makes decisions based on data
Makes decisions based on vision and intuition
Who is this simulator for?
PMs wishing to quickly obtaining insights from data
You will learn to independently extract data using SQL, test hypotheses faster, and close quarterly plans more efficiently.
Those who wish to improve their skills in analytics
Working with SQL and BI systems like Superset will allow you to become a real data-driven Product Manager.
Those wishing to find a job in an IT-giant
"Strong analytical skills" is one of the most common requirements for PMs in big international companies.
What does the simulator look like?
One of the ProductDo authors explains the courses' practical aspects.
Meet the Authors
- Andrew MendeSenior ML Product Manager
Booking.com Netherlands- Master of Business Administration (MBA)
- 13 years in Product Management
- Trained 1,000+ PMs on various edu-platforms
- Analytics
- A/B tests
- ML for PMs
- Konstantin GrabarSenior Product Manager
Coupang South Korea- 10+ years in Product Management
- Developer and Data analyst in the past
- Created and launched A/B test system in Flo
- Data
- A/B Tests
- Platform Products
Course Program
10−15 hours of training
depends on experience
depends on experience
Learning from the live application "Viditation": solve cases with real data. Tasks are set by CEO, analytics and other fellow characters who help you with the solutions.
We focus on practice in order to confidently own the tools and use the acquired analytical skills in work (or when applying for a job).
Why it is important
The PM operates with many hypotheses in parallel. The ability to quickly "ask" your question to data (your own or found on the Internet), get an answer, and focus on more valuable ideas is a very important skill of the senior PM.
What we will do
You will learn
Average passage time: 2-4 hours.
The PM operates with many hypotheses in parallel. The ability to quickly "ask" your question to data (your own or found on the Internet), get an answer, and focus on more valuable ideas is a very important skill of the senior PM.
What we will do
- Get acquainted with SQL and how data is stored
- Analyze the simplest constructions and fix them in practice
You will learn
- Basic work with SQL
- Basic work with tabular data storage
Average passage time: 2-4 hours.
Why it is important
To date, it is impossible to imagine any serious major product that does not use its own data warehouse and a system for working with them, similar to Superset. The skills of working with such a system is a serious advantage for any PM: both in employment and in solving work tasks.
What it looks like
You will learn
Average passage time: 2-4 hours.
To date, it is impossible to imagine any serious major product that does not use its own data warehouse and a system for working with them, similar to Superset. The skills of working with such a system is a serious advantage for any PM: both in employment and in solving work tasks.
What it looks like
- We analyze the subtleties of working with SQL and plotting in Superset using the example of determining the most popular models of user devices.
- We learn to build graphs in the system independently and analyze their results.
You will learn
- When you need to work with tabular data, and when you don't.
- Why product analytics is sometimes not enough.
Average passage time: 2-4 hours.
Why it is important
In this lesson, we will tell you in more detail about where the data is stored and how to link data from different sources. You will do this using JOIN operations, subqueries, and the Superset interface. Since the necessary data is always scattered across several tables, understanding these mechanisms is key to the successful search for insights. At the beginning of the lesson, we will analyze in detail the subtleties of working with JOINS, and then smoothly move on to subqueries and consolidate the acquired skills by solving a practical case with the definition of the most effective version of onboarding.
What it looks like
You will learn
Average passage time: 2-4 hours.
In this lesson, we will tell you in more detail about where the data is stored and how to link data from different sources. You will do this using JOIN operations, subqueries, and the Superset interface. Since the necessary data is always scattered across several tables, understanding these mechanisms is key to the successful search for insights. At the beginning of the lesson, we will analyze in detail the subtleties of working with JOINS, and then smoothly move on to subqueries and consolidate the acquired skills by solving a practical case with the definition of the most effective version of onboarding.
What it looks like
- We analyze in detail how data is stored in different tables and how to connect them with each other using subqueries and the JOIN operation.
- We solve a product case with an analysis of the effectiveness of our onboarding using both the Superset graphical interface and a quick manual data analysis using SQL.
You will learn
- How to work effectively with data stored in multiple tables.
- How to analyze funnels using SQL and BI systems on the example of onboarding data.
Average passage time: 2-4 hours.
Why it is important
SQL and Superset are often needed to analyze things that simply cannot be accessed from analytical systems like Mixpanel, or there is access, but it is inconvenient to analyze them. We will calculate the accuracy of the ML model by predicting the Lifetime of the users in Viditation.
What it looks like
You will learn
Average passage time: 2-4 hours.
SQL and Superset are often needed to analyze things that simply cannot be accessed from analytical systems like Mixpanel, or there is access, but it is inconvenient to analyze them. We will calculate the accuracy of the ML model by predicting the Lifetime of the users in Viditation.
What it looks like
- We are building the first dashboards.
- We analyze what can go wrong in the construction of SQL queries.
- We solve the case by calculating Lifetime and evaluating the accuracy of the ML model.
You will learn
- What systems like Superset are capable of and what typical cases they have.
- How to build dashboards.
- How to evaluate the accuracy of ML models in practice using the example of Lifetime calculation.
Average passage time: 2-4 hours.
Why it is important
Lifetime and Churn user research is one of the most popular areas in product analytics. It is always useful to analyze the data yourself and answer the question: "why are users leaving?" In the final lesson, we will analyze one of these cases, see in practice how to apply cohort analysis, and build it using Superset and SQL.
What it looks like
You will learn
Average passage time: 2-4 hours.
Lifetime and Churn user research is one of the most popular areas in product analytics. It is always useful to analyze the data yourself and answer the question: "why are users leaving?" In the final lesson, we will analyze one of these cases, see in practice how to apply cohort analysis, and build it using Superset and SQL.
What it looks like
- We conduct a cohort analysis of user retention and withdrawal in Superset.
- Independently solve a complex case using SQL.
- We are learning to use the so-called "window functions" for non-standard cases.
- We analyze the results of the case using the Heatmap graph.
You will learn
- How to calculate Churn of users by cohorts using SQL.
- How to build a Heatmap graph based on the result obtained and how to analyze it correctly.
Average passage time: 2-4 hours.
Pricing
1 student
Solo
Start immersive, hands-on learning and accelerate your career growth.
€259 €89
or get up to 30% off with a bundle
• 5 simulator lessons
Pay via Stripe • Digital certificate
• Unlimited access
2-10 students
Team
Engage your team in upskilling together and enjoy an extra 10% discount.
€259 €80
per student
• 5 simulator lessons
Contact sales • Digital certificate
• Unlimited access
11+ students
Enterprise
Boost the company's growth by educating your employees on in-demand skills.
Contact Sales
• 5 simulator lessons
Contact sales • Digital certificate
• Unlimited access
• Students' progressSimulator Bundle
Want to save on multiple simulators? Create your own bundle and unlock discounts! The more you add, the more you save:
• 2 simulators: 10% off
• 3 simulators: 15% off
• 4 simulators: 20% off
• 5 or more simulators: 30% off
Click the button below to see the final price and purchase a package.
• 2 simulators: 10% off
• 3 simulators: 15% off
• 4 simulators: 20% off
• 5 or more simulators: 30% off
Click the button below to see the final price and purchase a package.
Our Students Work at
Still not sure?
Check out more student reviews on LinkedIn
Try a free simulator lesson!
30 minutes of practice, more than 20 actual tasks that give you an idea of working as a PM in an international company. It's also a quick and easy way to understand how the ProductDo simulator works.
Frequently Asked Questions
There is no need to prepare for the course. We give an introductory theory and tasks with a gradual increase in complexity. The simulator teaches the basic understanding of product analytics that a Product Manager needs to build successful products.
In this course, we are looking at a very specific area of knowledge - basic analytics for a PM. This knowledge by itself will not make you a super-specialist, but you will just know one piece of knowledge. It's like building the powerful engine of a car that doesn't have wheels yet: there's nothing to drive on, but at the same time, the engine is waiting in the wings.
Therefore, we recommend that very beginners go through The Fundamentals of Product Management simulator in parallel. There are a lot of basic materials on product management and they are relatively simple. And a specialist who pumps complex necessary disciplines grows much faster than others. They immediately plunge into real tasks without simplification.
Therefore, we recommend that very beginners go through The Fundamentals of Product Management simulator in parallel. There are a lot of basic materials on product management and they are relatively simple. And a specialist who pumps complex necessary disciplines grows much faster than others. They immediately plunge into real tasks without simplification.
If you practice for half an hour or an hour a day, then it will take about 15-20 days. The pleasure can be stretched by thinking over the cases for a long time and reading the additional materials. Meanwhile, the simulator will be here for you.
Well, no: they are generated, but you can't tell them from the real ones!
The cases are really real and reflect the diversity of products in the industry: not everyone has a "website" or a "store". In the "Fundamentals" course, we cover the clothes rental start-up; in the "Tech for PM" simulator, we will look at a taxi ordering app (like Uber), a music service (like Spotify), and a food delivery app. In the simulator "A/B testing" we will dive into experiments on the Meditation service, and in "Product Discovery" we will analyze the business of renting clothes.
The more cases you solve (and not just read/watch), the more experienced a product manager you become. There is no other way.
The more cases you solve (and not just read/watch), the more experienced a product manager you become. There is no other way.
One of the distinctive features of ProductDo is that all our courses are packaged in a simulator format. We can say that this is an important element of our product vision. The simulator as a learning tool has many wonderful properties:
- it requires constant active participation of the student. In order to move forward, you need to choose some action or answer a question every time.
- it allows you to give detailed feedback on any action: You can justify the preferred option with links and examples
- it allows you to move at your own pace and does not burden those who do not really like to work in a group with unnecessary communication.
Usually, they teach like this: theory → practice. If you have mastered the theory well, then you do the practice 100% or so. We have a completely different methodology. We start with a practical task that needs to be solved (and if the course suits you, then you don't know how to do it yet). Only when you have tried to solve the problem, we bring up some theory behind it. We believe that the cycle: trying to think independently → making a decision → feedback on a decision is a very effective way to master new material, especially for those who have already reached some professional level.
If you want to try the simulator format, take a free lesson. It contains questions from different areas of product management. At the same time, you can evaluate which skills you already have enough pumped, and which can be further enhanced.
- it requires constant active participation of the student. In order to move forward, you need to choose some action or answer a question every time.
- it allows you to give detailed feedback on any action: You can justify the preferred option with links and examples
- it allows you to move at your own pace and does not burden those who do not really like to work in a group with unnecessary communication.
Usually, they teach like this: theory → practice. If you have mastered the theory well, then you do the practice 100% or so. We have a completely different methodology. We start with a practical task that needs to be solved (and if the course suits you, then you don't know how to do it yet). Only when you have tried to solve the problem, we bring up some theory behind it. We believe that the cycle: trying to think independently → making a decision → feedback on a decision is a very effective way to master new material, especially for those who have already reached some professional level.
If you want to try the simulator format, take a free lesson. It contains questions from different areas of product management. At the same time, you can evaluate which skills you already have enough pumped, and which can be further enhanced.
We help by giving you a bunch of practical tasks and sharing our mistakes and experiences. We have already built so many products that with our examples we can help you formulate your area (more technical or more payment, related to ML / AI, or sales, etc.). We believe that a good PM chooses their favorite product themselves and does not need to be led by the hand.
The entire history of the simulator with comments and answers is saved. Access to the materials remains forever.
Yes, students who have successfully passed the course may generate a certificate and proudly add it to their LinkedIn profile to Licenses & Certifications, or upload it to Facebook in the Schools section.
Yet do keep in mind that upon applying to a product company, certificates do not really increase the chances of being hired, at least in our practice. If a resume mentions a certain course, then this may raise questions about what the candidate really knows right now. Therefore, you need to solve problems and develop skills, and not chase certificates. Fortunately, our courses have enough practice.
Yet do keep in mind that upon applying to a product company, certificates do not really increase the chances of being hired, at least in our practice. If a resume mentions a certain course, then this may raise questions about what the candidate really knows right now. Therefore, you need to solve problems and develop skills, and not chase certificates. Fortunately, our courses have enough practice.
You can be sure of the materials' quality and our mentors' experience. We've been teaching for many years, and we have thousands of happy PMs. Feel free to take a look at the student reviews for verification.
If you passed less than 30% of tasks of the simulator you could refund your money in full.
If you passed less than 30% of tasks of the simulator you could refund your money in full.
- Alex ProductDoWe hope we answered all of your questions.
Still have more? Contact us via any messenger plug-in at the bottom right, or drop us a line at support@productdo.io, and we'll be happy to assist you.