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 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 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 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