Day 15 of #21DaysSQLChallenge by @IndianDataClub & @dpdzero 🔹 Topic: Multiple Joins Learned how to combine 3+ tables, use INNER/LEFT joins together, handle join order, and avoid duplicates while building multi-table reports. #SQLWithIDC #LearnSQL #IDCChallenge

Day 14 of #21DaysSQLChallenge by @IndianDataClub & @dpdzero 🔹 Topic: LEFT JOIN & RIGHT JOIN Learned how to include unmatched records using LEFT/RIGHT JOIN, handle NULLs with COALESCE, and identify missing data across tables. #SQLWithIDC #LearnSQL #IDCChallenge

Day 13 of #21DaysSQLChallenge by @IndianDataClub & @dpdzero 🔹 Topic: INNER JOIN Learned how to combine data from multiple tables using INNER JOIN, match records through common columns, and create meaningful cross-table reports. #SQLWithIDC #LearnSQL #IDCChallenge

Day 12 of #21DaysSQLChallenge by @IndianDataClub & @dpdzero 🔹 Topic: NULL Handling Learned how to work with missing data using IS NULL, IS NOT NULL, and COALESCE() to replace NULLs and ensure accurate filtering and calculations. #SQLWithIDC #LearnSQL #IDCChallenge

Day 11 of #21DaysSQLChallenge by @IndianDataClub & @dpdzero 🔹 Topic: DISTINCT & Removing Duplicates Learned how to fetch unique values, count distinct entries, and handle duplicate records efficiently using DISTINCT and COUNT(DISTINCT). #SQLWithIDC #LearnSQL #IDCChallenge

Day 10 of #21DaysSQLChallenge by @IndianDataClub & @dpdzero 🔹 Topic: CASE Statements Learned how to add conditional logic in SQL using CASE WHEN to create categories, custom labels, and conditional aggregations. #SQLWithIDC #LearnSQL #DataAnalytics #IDCChallenge

Day 9 of #21DaysSQLChallenge by @IndianDataClub & @dpdzero 🔹 Topic: Date Functions Learned to work with dates in SQL — from calculating stay duration to filtering patients by month/year. #SQLWithIDC #LearnSQL #DataAnalytics #SQLDeveloper #IDCChallenge

Day 8 of #21DaysSQLChallenge by @indiandataclub & @dpdzero Topic: String Functions (UPPER, LOWER, LENGTH, CONCAT, SUBSTRING) Learned how to clean & format text data, create summaries, and filter by string length. Each function adds a layer of clarity to raw data #SQLWithIDC

Day 7 of #21DaysSQLChallenge by @indiandataclub & @dpdzero Topic: HAVING Clause Learned how HAVING filters aggregated results after grouping — unlike WHERE, which filters rows before grouping. #SQL #DataAnalytics #SQLWithIDC #LearningInPublic

Day 6 of #21DaysSQLChallenge by @indiandataclub & @dpdzero Topic: GROUP BY Clause Learned how to group data by categories and apply aggregate functions like COUNT(), SUM(), and AVG() to each group. #21DaysSQLChallenge #SQL

Day 5 of #21DaysSQLChallenge by @indiandataclub & @dpdzero Topic: Aggregate Functions (COUNT, SUM, AVG, MIN, MAX) Learned how to summarize data using aggregate functions. Used SUM() for totals and AVG() for averages, and rounded results for readability. #21DaysSQLChallenge

Day 4 of #21DaysSQLChallenge by @indiandataclub & @dpdzero Topic: LIMIT & OFFSET Used OFFSET and FETCH to get the 3rd to 7th highest distinct satisfaction scores. To fetch full patient details for these ranks, we will use DENSE_RANK() in upcoming lessons. #21DaysSQLChallenge

Day 3 of #21DaysSQLChallenge by @indiandataclub & @dpdzero Topic : Sorting Data with ORDER BY Focused on sorting data using the ORDER BY clause. Learned how to sort in ascending/descending order and use multiple column sorting. #indiandataclub #SQLWithIDC #21DaysSQLChallenge

Day 2 of #21DaysSQLChallenge Focused on filtering data using the WHERE clause. comparison operators, AND/OR, IN, BETWEEN, and NULL values. SELECT id, name, age, score FROM patients WHERE service = 'Surgery' AND satisfaction_score<70 #dpdzero #indiandataclub #SQLWithIDC

Day 1 of the #21DaysSQLChallenge completed. Learned how to use SELECT and DISTINCT to retrieve specific and unique records along with Top, Limit clause. Query used: SELECT DISTINCT service FROM services_weekly; #DPDzero #indiandataclub #SQLWithIDC #DataAnalytics

Day 28 of #30DaysOfPython by @indiandataclub Covered: • Clean Code principles • Naming, formatting, & structure • DRY, meaningful functions, readable logic → Revisited my Book API & improved code quality now future-me won’t cry while reading it #IDC30DaysChallenge #Python

Day 27 of #30DaysOfPython by @indiandataclub Covered: • What is an ORM • Intro to SQLAlchemy • SQLAlchemy models & session • Connected FastAPI API to SQLite → Extended Book Library API to store & retrieve data using a real database #IDC30DaysChallenge #Python #FastAPI

Day 26 of #30DaysOfPython by @indiandataclub Covered: • REST API basics with FastAPI • CRUD: POST, GET, PUT, DELETE • Request & Response models with Pydantic • Tested endpoints using Postman → Built a Book Library API with full CRUD functionality #IDC30DaysChallenge

Day 25 of #30DaysOfPython by @indiandataclub Covered: • Basics of Pydantic • Creating models with validation • Using EmailStr, strict types • Custom validators with @field_validator → Built a UserProfile model that validates name, email & age #IDC30DaysChallenge #python

Day 24 of #30DaysOfPython by @indiandataclub Covered: • @dataclass basics • Type hints & default values • Adding methods to dataclasses • Cleaner data models with less code → Built a CLI Library Manager to add, borrow & return books #IDC30DaysChallenge #Python #Dataclass