SQL

All Blogs

I Tried chDB for Analytics — Here’s What I Learned

Hello everyone! Welcome to another Interesting Tech Update on Analytics! Recently, I came across an interesting update about chDB in the TDLR Newsletter, which motivated me to explore it further. Until now, I’ve mostly worked with server‑based SQL engines such as PostgreSQL, MySQL, and SQL Server. I’ve also used serverless SQL engines on many challenge platforms like DataLemur, LeetCode, and HackerRank. These platforms typically use in‑process SQL engines, which don’t

Mukilyavimali

Jan 145 min read

SQL Explained: Understanding the Language That Powers Databases

In today’s digital world, almost every application relies on data — and SQL is one of the most important tools used to manage it. From small websites to global enterprises, SQL enables systems to store, organize, and retrieve information efficiently. If you’re stepping into technology, analytics, or data-driven decision-making, learning SQL is an essential first step.

Rajyalakshmi Mannem

Jan 136 min read

Understanding PostGIS: The Spatial Extension for PostgreSQL

Geospatial Data in modern digital systems Geospatial data has become a cornerstone of modern digital systems. From ride‑sharing apps and logistics platforms to urban planning tools and environmental monitoring systems, location‑aware data powers decisions across industries. Geospatial data represents objects, events, or phenomena that have a location on Earth. This location can be expressed in many ways: Points (e.g., a store location) Lines (e.g., a road or river) Polygon

ctsanthafl2024

Jan 134 min read

PostgreSQL Indexes: From Beginner to Production Ready

PostgreSQL indexes are like the index at the back of a book—they help you find information fast without reading every page. When your database tables grow large (think thousands of rows), queries without indexes force PostgreSQL to scan every single row looking for matches. This "sequential scan" takes seconds or even minutes. Indexes create a separate, sorted reference structure that points directly to matching rows, dropping query times from seconds to milliseconds. Think o

uzmafarheen

Jan 134 min read

Data Analysis with PostgreSQL Window Functions: A Titanic Case Study

Learn how PostgreSQL window functions enable advanced data analytics without collapsing rows. This blog uses the Titanic dataset to demonstrate ranking, running totals, segmentation, and trend analysis using real-world SQL examples.

Neetu Rathaur

Jan 126 min read

From Chaos to Context: Making Sense of Unstructured Data in Postgres

Why Regex? - A Smart Filter Standard SQL search tools like LIKE or ILIKE as a simple "Ctrl+F" on your computer. They are great if you are looking for a specific word or a simple prefix, but they are clumsy when things get messy. For example, if you need to find every email address in a database, a simple search can't distinguish between a valid email format and a random string containing an "@" symbol. This is where PostgreSQL Regular Expressions (POSIX) comes in. Regex is l

Sudha Ravi

Jan 125 min read

Switching Gears: How Non-IT Professionals Can Become Data Analysts

From NON - IT to Data Analytics... Could This Be Your Story Too? Photo by Deng Xiang on Unsplash Have you ever sat at your desk and thought, “I’m doing my job well… but is this really what I want to do long term?” If yes, trust me you’re not alone. I was working in the financial sector , handling daily operations, transactions, and reports. Everything was stable. Everything was familiar. But somewhere along the way, I started noticing something interesting, every decision wa

Abirami Ramasubramanian

Jan 94 min read

Storing, Accessing, and Retrieving JSON Data in PostgreSQL: A Practical Guide

What is JSON: The Universal Language of Data Exchange In today’s digital world, applications constantly communicate with each other—mobile apps talk to servers, websites fetch data from APIs, and backend systems integrate with third‑party services. At the heart of much of this communication is JSON, short for JavaScript Object Notation. Despite its name, JSON is not limited to JavaScript; it has become a universal, language‑independent format for storing and exchanging data.

ctsanthafl2024

Jan 95 min read

Descriptive Statistics and Beyond: A Clinical SAS Programmer’s Journey into PostgreSQL

Introduction: The Analytical Pivot In my previous post, we treated the Student Performance Dataset like a digital training ground. We focused on the "how" of data cleaning—scrubbing text, fixing nulls, and standardizing schemas. It was the perfect exercise for a data "workbench" setup. However, as a former Clinical SAS Programmer, I know that cleaning is only half the battle. The true value of a database isn't just in its cleanliness; it’s in its ability to act as an analyti

jagarapujeevani

Jan 85 min read

From SQL Queries to Dashboards: Turning Raw Data into Insights with Power BI

Power BI turns that data into insights that can be put to use, while SQL serves as the framework for data management. This blog describes how combining the two platforms creates robust, interactive enterprise reporting dashboards.

Divya Elangovan

Oct 13, 20253 min read