📘 Bookstore SQL Portfolio Project

This beginner SQL project simulates a bookstore database built with SQL Server, Docker, and VS Code.

🚀 Tools Used

• Docker (SQL Server)
• Visual Studio Code (mssql extension)
• T-SQL (Transact-SQL)

🧱 Schema Design

• Authors: AuthorID, Name, Country
• Books: BookID, Title, Genre, Price, AuthorID (FK)

📊 Sample Queries

• Books per genre
• Books with author info
• Filtering and price analysis

💻 How to Run

1. Clone this repo
2. Start SQL Server via Docker
3. Connect using VS Code
4. Run scripts in order:
   • 02_create_database.sql
   • 03_insert_data.sql
   • 04_queries.sql

⚙️ Docker Container Running

🧠 Sample Query Output

🖥️ vs_code_connected

Vs SQL connected

✍️ Report

Find insights in 05_analysis_report.md

“I built this project to strengthen my SQL skills and practice real-world database design using modern tools like Docker and VS Code.”