Intermediate Python: Generators, Decorators & More

Python Intermediate

This is where your Python starts to look like a pro wrote it. Sixteen tutorials cover modules, packages, iterators, generators, closures, decorators, context managers, regex, the collections module, datetime, and logging. These are the tools that show up in every serious codebase.

SQL Basics for Python Developers: SELECT, WHERE, and JOINs

Nearly every backend and data job posting lists the same second skill after Python: SQL. It is how you ask a database a plain question, “show me every customer in Pune,” and get an exact answer in milliseconds. This post covers the SQL basics that do most of the daily work: SELECT, WHERE, ORDER BY, the NULL trap, and the two joins you will actually use. “Data is a precious thing and will last longer than the systems themselves.” Tim ... Read More

SQL GROUP BY, CTEs, and Window Functions, Explained

Your boss never asks for the grand total. They ask which product is number one in each category, and how this month compares to last. Answering that without losing the row-level detail is exactly what SQL window functions are for. This post builds up from GROUP BY and CTEs to ROW_NUMBER, RANK, LAG, and running totals, all on the SQLite that ships with Python. “Programming isn’t about what you know; it’s about what you can figure out.” Chris Pine, Learn ... Read More

Python Project: Build a Log Parser CLI (Regex + argparse)

This Python log parser project takes five separate skills you have met one at a time, regular expressions, dataclasses, the Counter, datetime, and argparse, and welds them into a single command line tool you would actually reach for at work. Server logs are where a lot of real debugging starts, and by the end of this post you will have a tool that reads a ten thousand line access log and answers real questions about it in under a second. ... Read More