SQL WHERE Clause: I Thought I Knew It… Until It Asked Me About LIKE 😭
What is the WHERE Clause? The WHERE clause is basically SQL's filter button. You don't want all rows – you want specific rows. sql SELECT FROM students; All ro...
What is the WHERE Clause? The WHERE clause is basically SQL's filter button. You don't want all rows – you want specific rows. sql SELECT FROM students; All ro...
Day three was all about reinforcing the basics, not rushing forward, but getting comfortable with SQL by practicing it repeatedly on real data. I spent most of...
Practicing SQL with LeetCode SQL 50 Challenge As a side quest today, I started the SQL 50 Challenge on LeetCode, focusing on the SELECT section. I was able to...
Interview Overview Yesterday I attended an interview for a Fresher React Developer role. It was a great learning experience that covered JavaScript, CSS, SQL,...
What Is a Database? A database is a structured collection of related data stored electronically and organized so it can be easily accessed, managed, and update...
The Problem Every Fresher Faces A few months ago, I was in the exact position many of you are in right now. 47,000 results. 🫠 One night at 2 AM, fueled by Mag...
Article URL: https://www.cs.cmu.edu/~pavlo/blog/2026/01/2025-databases-retrospective.html Comments URL: https://news.ycombinator.com/item?id=46496103 Points: 39...
What is a Relational Database? A relational database organizes data into tables, with each table having rows and columns—much like an Excel spreadsheet. This s...
Article URL: https://sqlnet.cc Comments URL: https://news.ycombinator.com/item?id=46483657 Points: 23 Comments: 2...
Reflection A silent struggle in data work that frustrates many people and no one talks about it: “I’m learning a lot… but everything feels disconnected.” Today...
!Cover image for The N+1 Insert Loop That Slowed Our API to a Crawlhttps://media2.dev.to/dynamic/image/width=1000,height=420,fit=cover,gravity=auto,format=auto/...
SQL vs NoSQL Trade‑offs When we talk about SQL vs. NoSQL in system design, we move past syntax to the core trade‑offs. In a real‑world system you choose a data...