NSDC Data Science Project – Advanced SQL Queries

Advanced SQL Queries

Project Description

This SQL project is designed for an intermediate to advanced learner who is looking to continue to practice writing SQL queries using a real-world dataset. In this project, we will work with the New York City Airbnb dataset. The main goal is to help you become familiar with advanced SQL syntax and data analysis tasks.


New York City Airbnb Dataset

Relevant Skills You May Apply

Intermediate SQL Skills – which you can learn through the Introduction to SQL Queries project and the Intermediate SQL Queries project!

Skills You May Gain

Advanced SQL Syntax and Data Analysis Skills

Total Time

Approximately 5 hours


Milestone 1: Libraries and Database Setup
Milestone 2: Loading the Dataset
Milestone 3: Advanced SQL Queries
Milestone 4: Closing Connection
Milestone 5: Summary of Advanced SQL Commands


Deliverables include an interactive Google Colab Notebook.