Theme1
π 50-Day Python Backend Developer Challenge
π Phase 1: Core Python (Day 1β10)
Day 1: Install Python, VSCode, set up virtualenv.
Day 2: Data Types (strings, integers, floats, booleans).
Day 3: Lists, Tuples, Sets, Dictionaries.
Day 4: Conditional Statements (
if-else,match-case) and Loops.Day 5: Functions, *args, **kwargs.
Day 6: Exception Handling (try, except, finally).
Day 7: Classes, Objects,
@classmethod,@staticmethod.Day 8: Inheritance, Polymorphism, Encapsulation.
Day 9: File handling (read/write JSON, CSV, TXT).
Day 10: Pythonic Practices (List Comprehensions, Lambda, Map, Filter).
ποΈ Phase 2: Databases Basics (Day 11β20)
PostgreSQL
Day 11: Install PostgreSQL locally. Understand tables, rows, columns.
Day 12: Create database, tables, insert sample data manually.
Day 13: Learn CRUD in SQL (Create, Read, Update, Delete).
Day 14: Connect PostgreSQL using
psycopg2orasyncpg.Day 15: Write Python scripts to run SQL queries.
MongoDB
Day 16: Install MongoDB locally. Understand collections and documents.
Day 17: Basic CRUD operations manually using MongoDB Compass.
Day 18: Connect MongoDB from Python using
pymongo.Day 19: Write Python scripts to perform CRUD with MongoDB.
Day 20: Understand Schema Design for MongoDB vs PostgreSQL.
π Phase 3: Pandas for Backend (Day 21β25)
Day 21: Install Pandas. Read and explore CSV/Excel files.
Day 22: Data Cleaning: drop nulls, fill missing data.
Day 23: Basic Transformations (groupby, pivot, merge).
Day 24: Save data to PostgreSQL using Pandas.
Day 25: Create REST API to upload CSV β insert into database.
π Phase 4: FastAPI Backend Core (Day 26β40)
Day 26: Install FastAPI, run first "Hello World" API.
Day 27: Create API Endpoints (GET, POST).
Day 28: Path Parameters, Query Parameters.
Day 29: Request Body with Pydantic Models.
Day 30: Response Models (Validation and Schema).
Day 31: CRUD Operations for MongoDB using FastAPI.
Day 32: CRUD Operations for PostgreSQL using FastAPI.
Day 33: Organize FastAPI Project Structure (routers, services, schemas).
Day 34: Dependency Injection in FastAPI.
Day 35: Authentication Basics (API Key / Basic Auth).
ποΈ Phase 5: Mini Projects and Real World (Day 41β50)
Day 41: Project 1: Todo App API (MongoDB backend).
Day 42: Project 2: Book Store API (Postgres backend).
Day 43: Add Validation and Error Handling in Projects.
Day 44: FastAPI Middleware (logging, CORS).
Day 45: Use Alembic for Postgres Migrations (basic intro).
Day 46: API Pagination (limit, skip) in FastAPI.
Day 47: Export Database Records to CSV using FastAPI + Pandas.
Day 48: Create Swagger and Redoc API docs.
Day 49: Host the API on Render or Railway (free hosting).
Day 50: Final Fullstack Project (Backend + Frontend Postman Collection) β Deployment Ready!
β¨ Notes:
Database Choice: Some APIs use Postgres, some MongoDB.
Skills: You will touch CRUD, SQL, NoSQL, REST API, Pandas, FastAPI.
Deploy: Hosting your app on Day 49 ensures you experience real-world DevOps basics too.
Docs: Emphasize OpenAPI/Swagger generation (built-in FastAPI).
Projects: After Day 40, focus more on coding real apps, not just learning.
Last updated