SQL Projects

Sales Analysis

This project tracks product sales performance, showing revenue generation across different products. The visualization demonstrates total revenue by product category through a bar chart.

Employee Management System Department Analysis

This HR database tracks departments and employees, showing staffing levels and salary distributions across departments. The visualizations compare employee count and average salaries between departments.

Student Database System Student Analysis

This academic database manages student records, tracking majors and GPAs. The scatter plot shows the relationship between number of students and average GPA for each major.

Inventory Management System Inventory Analysis

This inventory system tracks office supplies and furniture, showing quantity and value distribution. The pie charts compare the distribution of items by quantity and total value across categories.

Each project demonstrates different SQL concepts, including:

·      Table creation and relationships

·      Data insertion and manipulation

·      Aggregation and grouping

·      JOIN operations

·      Complex queries with multiple conditions