🚀 SQL Learning Journey

Welcome to my SQL Learning Journey repository. This repository documents my step-by-step practice and progress while learning SQL for Data Analytics.

The goal of this repository is to build a strong foundation in SQL, understand database concepts, and practice analytical queries used in real-world data analysis.

---

📊 Topics Covered

🗄️ Database Concepts

• DBMS and RDBMS concepts
• SQL basics
• Tables, Rows, Columns
• Primary Key and Foreign Key
• Relationships (One-to-One, One-to-Many, Many-to-Many)
• Database schema and normalization

Data Types & Table Design

• INT, FLOAT, DECIMAL
• CHAR vs VARCHAR
• DATE and DATETIME
• BOOLEAN / BIT
• Auto Increment / Identity Columns

SQL Operations

• Creating tables (DDL)
• Inserting data (INSERT)
• Updating data (UPDATE)
• Deleting data (DELETE)

Analytical SQL (Upcoming)

• SELECT and WHERE
• GROUP BY and HAVING
• SQL Joins
• Subqueries
• Window Functions
• Common Table Expressions (CTE)

---

Repository Structure

This repository is organized day-by-day as I progress through different SQL concepts.

Example structure:

Day1_Database_Foundation Day2_Select_Where Day3_Aggregations Day4_Joins Day5_Subqueries Day6_Window_Functions

Each folder contains SQL practice queries and exercises related to that topic.

---

💻 Tools Used

• SQL Server
• SQL Server Management Studio (SSMS)
• GitHub

---

🎯 Learning Goal

My goal is to master SQL for data analytics and apply these skills to real-world datasets and projects.

---

👩‍💻 Author

Chandana

Aspiring Data Analyst