💻 SQL Project: Real Estate Sales Analysis

📝 Overview

This project demonstrates basic SQL database setup, data loading, and queries for analyzing real estate sales data. It is designed as a beginner-friendly project for learning SQL.

Project Structure

• 📁 Beginner SQL data analysis project
  • 📄 setup.sql
  • 📄 load_data.sql
  • 📄 queries.sql
  • 📄 sample_data.csv
  • 📄 .gitignore
  • 📄 README.md

Prerequisites

• MySQL (any version) installed or running in Docker
• SQL client (e.g., SQLTools in VS Code, MySQL Workbench, or DataSpell)

Instructions

1. Create the database and tables

Run setup.sql in your SQL client to create the database and the real_estate_sales:

SOURCE path/to/setup.sql;

💡 Tip
You can drag & drop a file to show the path!

2. Load sample data

• The repo includes sample_data.csv (10-20 rows) for testing.
• Update load_data.sql to point to your CSV location if needed.
• Run load_data.sql to populate the table:

SOURCE path/to/load_data.sql;

3. Run analysis queries

• Open queries.sql in your SQL client to run example queries.
• You can modify or add queries for your own analysis.

Optional: Using Docker

If you prefer to use MySQL in Docker:

1. Start a MySQL container:

docker run --name mysql-container -e MYSQL_ROOT_PASSWORD=yourpassword -p 3306:3306 -d mysql:9.4

📕 Note
You can also download the Docker desktop for Mac or Windows.

2. Connect your SQL client to localhost:3306 with the root password.
3. Follow the instructions above to run setup.sql and load_data.sql.

Notes

• The repo includes a sample CSV for demonstration. The full dataset is excluded and should be downloaded separately if needed.
  • The full dataset is available on data.gov
  • All SQL scripts are structured to run on any standard MySQL setup.