🗄️ SQL Company Database Analysis

📌 Project Overview

This project is a relational company database created to practice and demonstrate SQL concepts using a structured company dataset.

The database contains information about employees, branches, clients, sales relationships, and suppliers. SQL queries are used to analyze employee information, salaries, branch relationships, client sales, and other business-related data.

🎯 Project Objective

The main objective of this project is to demonstrate practical SQL skills including database creation, data manipulation, relational database concepts, joins, aggregations, subqueries, and business-oriented data analysis.

🗂️ Database Tables

The database contains the following tables:

• Employee
• Branch
• Client
• Works_With
• Branch_Supplier

🔍 SQL Concepts Covered

• Database & Table Creation
• Primary Keys
• Foreign Keys
• Referential Integrity
• INSERT
• UPDATE
• SELECT
• WHERE
• IN
• LIKE
• UNION
• INNER JOIN
• LEFT JOIN
• Aggregate Functions
• COUNT()
• SUM()
• AVG()
• GROUP BY
• Subqueries
• Date Filtering
• Table Aliases
• ON DELETE CASCADE
• ON DELETE SET NULL

📊 Analysis Performed

The project includes queries to:

• Find employee information based on different conditions
• Calculate the average employee salary
• Calculate total employee salaries
• Count employees by gender
• Analyze total sales by salesperson
• Analyze total sales by client
• Find employees based on branch relationships
• Identify employees associated with specific clients
• Analyze employees based on sales performance
• Practice nested queries and joins

🛠️ Tools & Technologies

• MySQL
• PostgreSQL
• SQL
• Relational Database Concepts

📁 Project Files

• company_database.sql — Database creation, sample data, and SQL queries
• README.md — Project documentation

💡 Key Skills Demonstrated

• SQL Query Writing
• Relational Database Design
• Data Manipulation
• Data Aggregation
• Joins & Relationships
• Subqueries
• Business Data Analysis
• Database Constraints

👩‍💻 Author

Neeli Nikhila