Archive
20 posts, organised by month.
October 2026
NumPy for Data Engineering: Arrays, Slicing, Broadcasting, and Real Practice
Data Engineering Stage 2: Python for Data Processing
Analyzing 100,000+ Orders: My Olist E-Commerce SQL & OLAP Project
Beyond Classical Search: Minimax, Alpha-Beta Pruning, Expectimax, and Propositional Logic
Database Design & Modeling Part 2: Normalization and Expanding the Schema
Drawing My First Real ER Diagram (And Why I Actually Needed To)
A* Nuances and Local Search in AI: Hill Climbing, Random Restart & Beam Search
Search Algorithms in AI: From BFS and DFS to A*
September 2026
August 2026
SQL Basics Part 6: Subqueries and CTEs (Common Table Expressions)
SQL Basics Part 5: Window Functions, Running Totals, Ranking, LAG/LEAD, and PARTITION BY
SQL Basics Part 4: Numeric, Date, and String Transformations Plus CASE Conditionals
SQL Basics Part 3: INNER JOIN, LEFT JOIN, RIGHT JOIN, UPDATE, and DELETE
SQL Basics Part 2: SELECT, WHERE, Sorting, and GROUP BY
SQL Basics Part 1: DDL, DML, Constraints & Keys