📝 Parottasalna Blog
248 practical articles on backend engineering, system design, databases, Docker, Python, AI and DSA, explained simply.
3 articles in SQL · Clear filters
SQL
Introduction to DDL (Data Definition Language) in SQL
When we talk about databases, we usually think of inserting, updating, or deleting data. But before doing any of that, we must first define the struc…
SQLUnderstanding Common Table Expressions (CTE) in SQL — Simplifying Complex Queries
In SQL, we often deal with queries that involve multiple subqueries, aggregations, or recursive lookups. When these start to get long and unreadable,…
SQLLearning Notes #74 - Understanding Count(*) and Count(1) for counting rows
When working with SQL, counting rows in a table is a common task. Two widely used methods for this are COUNT(*) and COUNT(1). While both seem similar…