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.


Dataset

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


Milestones

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

Deliverables include an interactive Google Colab Notebook.