Sales Database Management System (SQL Project)

This project is a beginner-friendly SQL-based Sales Database Management System that demonstrates how to design, populate, and query a relational database using basic and intermediate SQL techniques.

📁 Files Included

• schema.sql — Creates the database tables: Customers, Products, Orders, and Order_Details.
• insert-data.sql — Populates the tables with sample data.
• sample-queries.sql — Contains useful queries for data analysis such as sales summaries, customer insights, and product reports.

🗃️ Database Structure

Tables:

• Customers: Stores customer details.
• Products: Stores product information and stock.
• Orders: Contains order records linked to customers.
• Order_Details: Contains details for each product in an order.

🧪 Sample Queries

• View all customers and products.
• Find orders placed in the last 30 days.
• Analyze total sales by product or customer.
• Identify products that were never ordered.
• Monthly sales trends and more.

🚀 How to Use

1. Run schema.sql to create the tables.
2. Run insert-data.sql to populate the tables with sample data.
3. Execute queries from sample-queries.sql to explore and analyze the data.

🛠️ Technologies

• SQL Server (or any SQL-compatible RDBMS)
• SQL Language (DDL, DML, JOINS, Aggregates, Subqueries)

👩‍💻 Author

Project designed by a career-switcher passionate about learning SQL and database development.

---

✅ Perfect for students, freshers, and career-switchers showcasing SQL skills on GitHub!