Data Practice Repository

A curated repository focused on strengthening data fundamentals and progressively scaling toward real-world analytics, data science, and engineering projects.

This space is not about volume, but about intentional practice, clear reasoning, and continuous improvement.

---

Purpose

This repository serves as a personal learning and portfolio space where I:

• Practice core SQL and Python concepts through selected coding challenges
• Document reasoning, assumptions, and analytical thinking
• Transition gradually from platform-based exercises to real data projects, including:
  • Data manipulation and transformation workflows
  • Analytical case studies
  • Introductory Machine Learning models

---

Scope & Philosophy

What you will find here:

• Carefully selected challenges with strong learning value
• Clear, readable, and well-documented solutions
• Emphasis on correctness, edge cases, and analytical thinking

What you will NOT find here:

• Massive dumps of solved problems
• Copy-paste or auto-generated solutions
• Speed-focused or context-free answers

Quality over quantity. ALWAYS.

---

Languages & Tools

• SQL (MS SQL Server dialect)
• Python (pandas, numpy, matplotlib, scikit-learn)
• Git & GitHub

(Future extensions may include Jupyter Notebooks, BI tools, and cloud-based data platforms like Snowflake or Databricks)

---

Repository Structure

.
├── projects/
├── python/
│   ├── hackerrank/
│   │   ├── easy/
│   │   ├── hard/
│   │   └── medium/
│   └── leetcode/
│       ├── easy/
│       ├── hard/
│       └── medium/
├── sql/
│   ├── hackerrank/
│   │   ├── easy/
│   │   │   ├── average_population_of_each_continent.sql
│   │   │   ├── employee_salaries.sql
│   │   │   ├── higher_than_75_marks.sql
│   │   │   ├── population_census.sql
│   │   │   ├── population_density_difference.sql
│   │   │   ├── the_blunder.sql
│   │   │   ├── top_earners.sql
│   │   │   ├── type_of_triangle.sql
│   │   │   ├── weather_observation_station_12.sql
│   │   │   ├── weather_observation_station_15.sql
│   │   │   ├── weather_observation_station_17.sql
│   │   │   ├── weather_observation_station_2.sql
│   │   │   ├── weather_observation_station_3.sql
│   │   │   ├── weather_observation_station_4.sql
│   │   │   └── weather_observation_station_5.sql
│   │   ├── hard/
│   │   └── medium/
│   │       ├── new_companies.sql
│   │       ├── ollivanders_inventory.sql
│   │       ├── the_competitors.sql
│   │       ├── the_pads.sql
│   │       ├── the_report.sql
│   │       └── weather_observation_station_20.sql
│   └── leetcode/
│       ├── easy/
│       ├── hard/
│       └── medium/
├── templates/
│   ├── python_template.py
│   └── sql_template.sql
├── .gitignore
└── README.md
.

---

Coding Standards

• Consistent formatting and naming conventions
• Clear separation between problem context, approach, and solution
• Readability prioritized over cleverness

---

Final Note

This repository evolves as my skills evolve:

• Early sections focus on fundamentals and structured problem-solving.
• Later sections aim to reflect real-world data analysis, science, anD engineering workflows.

Learning is iterative; this repo documents the journey.

---

If you reached this far, THANK YOU! Feel free to explore the SQL & Python challenges and project cases.