🧠 SQL for Data Analysis

Welcome to my SQL for Data Analysis repository!
This repo contains a curated collection of SQL Server scripts developed during my journey through data analytics training.

🛠️ It includes hands-on exercises and mini-projects that simulate real-world data tasks such as:

• ✅ Data cleaning & transformation
• 🧩 Joins & subqueries
• 📊 Business analysis
• 🔁 Control flow & procedures
• 🔐 Security configurations
• 🧱 Normalization & relational design

All scripts are written in T-SQL and tested in SQL Server Management Studio (SSMS).

---

📁 Project Structure

🔍 1. SQL Analysis Practice (Foundational to Intermediate)

These scripts cover basic queries, control flow, normalization, and logic development for SQL Server learners.

File	Description
basic_sql_practice.sql	Basic syntax: INSERT, CASE, JOINS, IF/ELSE, WHILE, LEN
sql_system_and_insert_practice.sql	System views, table creation, multi-row inserts, language settings
sql_flow_and_union_practice.sql	Loops with GOTO, conditional updates, RAND(), and UNION
restaurant_lab_practice2.sql	Restaurant + HR schema: keys, views, XML, stored procs
sql_lab_practice.sql	Normalization (1NF/2NF), constraints, indexing, user roles

---

🔐 2. SQL Server Security Scripts

Real-world practices in database encryption, auditing, and user management.

File	Description
security_audit.sql	Auditing roles, encryption keys, secure connection verification
security_and_users.sql	TDE, value encryption, role management, user creation

---

✅ Requirements

• Microsoft SQL Server 2016 or later
• SQL Server Management Studio (SSMS)
• Optional: AdventureWorks or personal dataset

---Feel free to fork, adapt, and learn from these scripts. Contributions and feedback are always welcome!