Calculating Free-to-Paid Conversion Rate with SQL Project

Calculating the Fraction of Students Who Convert to Paying Ones after Starting a Course free beginner

With Hristina Hristova

Type: Practice project

Duration: 2 Hours

Case Description

SQL is a powerful tool that can be used for extracting information from databases with its invaluable ability to join tables and aggregate results. Data extraction is the first step towards data analysis, and, therefore, extracting data correctly is crucial to arrive at the correct conclusions during the analysis process.

This Calculating Free-to-Paid Conversion Rate with SQL project aims to put your SQL skills into practice. You’ll work with an excerpt of our own data—stripped of personally identifiable information—to estimate the fraction of students who purchase a subscription after starting a lecture, i.e., the free-to-paid conversion rate among students who’ve engaged with video content on the 365 platform. You will also be tasked with calculating several other key metrics and analyzing the results.

The data you’ll be working with includes three tables storing information about students’ registration dates, engagement dates, and subscription purchase dates.

Project requirements

For this Calculating Free-to-Paid Conversion Rate with SQL, you’ll work with MySQL Workbench 8.0.

Project files

db_course_conversions.sql – the file contains the database for the project.
Start project
Project content
  • 1 Project file
  • Guided and unguided instructions
  • Part 1: Create the Subquery
  • Part 2: Create the Main Query
  • Part 3: Interpretation
  • Quiz
Topics covered
Programming Relational Databases