All Posts
Lag Function: Access data in a previous row in the same result set without having to join the table to itself.
How to use the SQL LAG window function to compare current and previous row values, with practical query and table output.
Intro to Trees Theory with Python
An introduction to Tree's theory using Leet Code problems and Python
Algorithms: Priority Queues
A review of problems which involve using a Priority Queue to solve efficiently.
Data Structures: Pointers in C
Developing a better intuition on pointers & references.
Top 10 MongoDB CLI Commands Every Developer Should Know
Master MongoDB’s CLI with these essential commands for exploring databases, managing collections, and running queries like a pro.
Mastering PostgreSQL: Beyond Basic SQL
Learn how PostgreSQL extends standard SQL with advanced features, reliability, and open-source flexibility. This guide covers practical commands, differences from generic SQL, and tips for effective database work.