SQLCaseStudies-SSMS

A collection of SQL scripts and case studies executed using SQL Server Management Studio (SSMS). These projects focus on real-world business scenarios, data cleaning, budgeting, internship tasks, and data exploration.

---

📂 Project Highlights

File	Description
BUDGET SQL QUIERS.sql	SQL logic to analyze and break down budget allocation scenarios.
Cognifiz Internship task Queries.sql	SQL tasks performed during an internship, covering business-focused querying.
Covid Analysis (Tableau).sql	Backend queries supporting a Tableau COVID-19 dashboard.
Data Cleaning Nashville Housing.sql	Comprehensive SQL-based data cleaning and preprocessing task.
Many More Loading

---

🧠 Skills Applied

• Writing complex SQL queries
• Data cleaning and transformation
• Using JOIN, CTE, WINDOW FUNCTIONS
• Subqueries, Aggregations
• Working with real business datasets
• Preparing backend queries for dashboards

---

🛠 Tools Used

• Microsoft SQL Server Management Studio (SSMS)
• SQL (T-SQL dialect)
• Tableau (in connection with SQL)
• Excel (sometimes for supporting files)

---

🎯 Purpose

• Practice real-life SQL problems
• Build a solid SQL portfolio
• Demonstrate practical data handling with T-SQL
• Prepare for SQL-based data analyst roles

---

📬 Connect

• LinkedIn
• GMail

---

⭐️ If this helped you or inspired you, drop a star and share the repo!