YSYash Sakhareliyainlearn-pgsql.hashnode.dev·Jul 17, 2025 · 2 min readSQL Essentials: ORDER BY, LIMIT, OFFSET, UNION, INTERSECT, and More1. ORDER BY — Sorting Results Used to sort query output in ascending (ASC, default) or descending (DESC) order. -- Sort products by price ascending SELECT * FROM products ORDER BY price; -- Sort by price descending SELECT * FROM products ORDER BY pr...00
YSYash Sakhareliyainlearn-pgsql.hashnode.dev·Jul 16, 2025 · 7 min readSQL Joins, Grouping and Aggregation Demystified: A Complete Practical GuideUnderstanding SQL Joins — With Examples Joins are used in SQL to combine rows from two or more tables based on a related column between them. We’ll use two sample tables throughout: 📘 Table: students student_idname 1Alice 2Bob 3Charlie 4Da...00
YSYash Sakhareliyainlearn-pgsql.hashnode.dev·Jul 15, 2025 · 3 min readUnderstanding SQL Table Relationships And KeysIn relational database design, understanding how tables relate to each other is critical. Whether you're building a social media platform, e-commerce system, or blog site, you’ll encounter different types of relationships. In this article, I’ll walk ...00
YSYash Sakhareliyainlearn-pgsql.hashnode.dev·Jul 14, 2025 · 4 min readAll-in-One SQL & PostgreSQL Revision Notes with Real QueriesThis blog is a complete guide that covers essential SQL and PostgreSQL queries, functions, and practical examples. It's designed to be a one-stop reference for preparing for interviews, exams, or real-world database tasks. It includes everything from...00
YSYash Sakhareliyainbunapiguide.hashnode.dev·Jan 23, 2025 · 3 min readGetting Started with API Development Using Bun.jsWhat is Bun? Develop, test, run, and bundle JavaScript & TypeScript projects—all with Bun. Bun is an all-in-one JavaScript runtime & toolkit designed for speed, complete with a bundler, test runner, and Node.js-compatible package manager. Bun aims fo...00
