Use AI and SQL to analyze the rise of AI. 

Analyze AI Systems with SQL

Query Hacker News data using SQL to discover trends.

Analyze Hacker News Trends

Query from two tables that contain Twitch’s stream viewing data and chat room usage data.

Analyze Twitch Gaming Data

Use PySpark SQL and DataFrames to analyze Wikipedia clickstream data

Analyzing Wikipedia Clickstreams with PySpark

Answer business questions about the performance of marketing campaigns for CoolTShirts.com, an innovative apparel shop.

Attribution Queries

In this project, we'll look at an online bookseller's database and think about how to improve it using indexes.

Book Store Indexes

This project is a step-by-step guide to create a restaurant menu database schema using PostgreSQL that closely models a real-life restaurant.

Build A Menu For Bytes Of China

This project is an overview of all material covered in the PostgreSQL constraints lesson and asks learners to apply different datatypes, nullability constraints, check constraints, unique constraints, and primary and foreign key constraints on new and existing tables.



Building an Inventory Database with PostgreSQL

Practice calculating churn rates using SQL.

Calculating Churn Rates

Apply your knowledge of window functions to explore real climate data from each state in the United States.

Climate Change

Challenge project time! Use your knowledge of SQL and analyze some mockup Codecademy students data.

Codecademy Learners Mockup Data

Practice using prepared statements and form validation to prevent SQL injection attacks. 

Codey's Confectionery: Preventing SQL Injection Attacks

Build fluency in SQL manipulation. We're going to practice creating tables in SQL so you can hone your skills and feel confident taking them to the real world.

Create a Table

51 Cent is a digital currency exchange headquartered in San Francisco, California. They broker exchanges of Bitcoin, Bitcoin Cash, Ethereum, and Litecoin with fiat currencies in around 32 countries. Help them analyze their January data using SQL aggregate functions!

Cryptocurrency Exchange

In Codestrips, you'll build a back-end to support a small comic strip creation app. Using Express.js and Node-SQLite, create a new database, build the proper table, and create GET and POST routes to provide access to and the ability to create new comic strips.

Cumulative Project: Codestrips

Let's experiment with creating roles and permissions on a PostgreSQL database

Data Exchange Service

In this project, learners will normalize a database table containing data from a furniture store by creating a new set of tables that contain all of the same information. Learners will then have a chance to explore how data modifications and queries differ before and after normalization. 

Database Normalization at Fred's Furniture

In this project we will be working with a small database of customer information and how to improve it with triggers.

Database Triggers

Do you remember Davie's Burgers from our Learn CSS course? Well, the business has been booming and it is now looking to place a funny and catchy advertisement in a local subway station. Help them dig into their `orders` data to see if there is anything interesting in there!

Davie's Burgers Subway Ad

Use your knowledge of models and databases to programmatically help the owners of Djaunty Rent-a-Bike build out their rental system!

Djaunty Rent-a-Bike

Let's add some more complex indexes to our book store database!

Intermediate Book Store Indexes

It's time to build fluency in SQL fundamentals. In this project, we're going to practice using multiple tables in SQL so you can hone your skills and feel confident taking them to the real world. Why? It's important to understand how to interact with multiple tables in a single query. What's next? A data analyst, ride sharing, more SQL. You got this! 

Lyft Trip Data

Let's put what you've learned so far in SQL into practice. As a data analyst, you've been assigned to analyze some fictional data across multiple tables from the social news and content rating site Reddit. Let's dive in!

Multiple Tables with Reddit

Practice writing the most common types of queries.

New York Restaurants

Play the role of two collaborators using Git to work on a book of recipes

Recipe Book

The marketing department of Reputable Product Agency are looking to segment the company users by a number of different criteria. Use SQL queries to generate user lists for them!

RPA Customer Segmentation

Reputable Product Agency (RPA) has started receiving complaints from their credit card processor about fraudulent transactions. Help your finance department identify potentially risky transactions before they finish processing.

RPA Fraud Detection

Analyze company data and apply data transformation techniques to help a management team make business decisions.

Startup Transformation

Use the SQL aggregate functions to dig through the collection of The Metropolitan Museum of Art of New York, the largest art museum in the United States.

The Metropolitan Museum of Art

Put some of your database maintenance skills to the test in this project!

Traffic Analytics

In this project, we're going to practice aggregate functions in SQL so you can hone your skills and feel confident taking them to the real world. Using these functions will combine row values together and return a single result.

Trends in Startups

Analyze Warby Parker’s marketing funnel from Quiz → Home Try-On → Purchase in order to calculate conversion rates.



Usage Funnels with Warby Parker

In this project, you will perform multiple joins on tables to analyze a company's workforce. 

VR Startup Company

In this project, you will perform multiple joins on tables to analyze data from an app, "Welp", where users can rate and write reviews about businesses.

Welp

Practice SQL queries on a database of world populations by country.

World Populations SQL Practice

Practice SQL joins and aggregate functions with a database of country population statistics.

World Populations SQL Practice II

Build a comic book company API from scratch using Express.js and SQLite

Practice projects in SQL

Solidify concepts with guided practice.

Analyze AI Systems with SQL

Analyze Hacker News Trends

Analyze Twitch Gaming Data

Analyzing Wikipedia Clickstreams with PySpark

Attribution Queries

Book Store Indexes

Build A Menu For Bytes Of China

Building an Inventory Database with PostgreSQL

Calculating Churn Rates

Resources

Support

Resources

Support

Plans

Community

Subjects

Languages

Career building

Mobile

Mobile