Codecademy Learners Mockup Data

Brief

Objective

Overview

This project is slightly different than others you have encountered thus far on Codecademy. Instead of a step-by-step tutorial, this project contains a series of open-ended requirements which describe the project you’ll be building. There are many possible ways to correctly fulfill all of these requirements, and you should expect to use the internet, Codecademy, and other resources when you encounter a problem that you cannot easily solve.

Project Goals

Use your knowledge of SQL and analyze some mockup Codecademy learners data. There are two tables:

users table:

user_id
email_domain
country
postal
mobile_app
sign_up_at

progress table:

user_id
learn_cpp
learn_sql
learn_html
learn_javascript
learn_java

Setup Instructions

If you choose to do this project on your computer instead of Codecademy, you can download what you’ll need by clicking the “Download” button below. If you need help setting up your computer, be sure to check out our SQLite setup guide. You can then run SQL commands from your terminal, or install DB Browser to run SQL commands from a desktop application. Our article on running SQL commands in DB Browser will walk you through opening a database file and running queries.