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
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.