IT, Techno, Auto, Bike, Money
Imagine you’re building a sales dashboard. The total revenue looks correct, the number of orders matches the source system, and every… Continue reading on Medium » Imagine you’re building a…
How to Master SQL by Learning 7 Commands in the Right Order Continue reading on The Common Room » How to Master SQL by Learning 7 Commands in the Right…
Week 7 of my DataraFlow journey was about working with data that wasn’t perfectly organised. I spent time cleaning messy data, creating… Continue reading on Medium » Week 7 of…
Summarize, combine and reshape data, with simple examples and real output Continue reading on Medium » Summarize, combine and reshape data, with simple examples and real outputContinue reading on Medium…
When analysing data, we don’t always need every record in a database. Sometimes, we only need specific information. Continue reading on Medium » When analysing data, we don’t always need…
Last Tuesday, a VP of Product sent me a Slack message with an AI-generated SQL query attached. He had asked an LLM to calculate our Net… Continue reading on Medium…
Introduction Continue reading on Medium » IntroductionContinue reading on Medium » Read More Sql on Medium #sql
Inspired by the “Is this a pigeon?” meme. The dates and scenario are illustrative. Continue reading on Medium » Inspired by the “Is this a pigeon?” meme. The dates and…
Every RFP I’ve seen in the last year has a line item asking for “performance benchmarks.” What the client actually wants to know, if you… Continue reading on Medium »…
PostgreSQL Partial Indexes: Kısmi İndekslerle Disk Kullanımını ve Sorgu Maliyetini Azaltma Continue reading on Medium » PostgreSQL Partial Indexes: Kısmi İndekslerle Disk Kullanımını ve Sorgu Maliyetini AzaltmaContinue reading on Medium…
A PostgreSQL index is a separate structure that lets the database find rows without reading the whole table. Continue reading on Code Your Own Path » A PostgreSQL index is…
Part 1: Starting with SQL Continue reading on Medium » Part 1: Starting with SQLContinue reading on Medium » Read More Sql on Medium #sql
Subquery Continue reading on Medium » SubqueryContinue reading on Medium » Read More Sql on Medium #sql
Learn how to compare individual orders, rank products, and calculate running metrics while preserving row-level detail. Continue reading on Medium » Learn how to compare individual orders, rank products, and…
Learn how to compare individual orders, rank products, and calculate running metrics while preserving row-level detail. Continue reading on Medium » Learn how to compare individual orders, rank products, and…
Lets make shopping and learning more interesting with this blog. At first, managing these orders in notebooks or spreadsheets may seem… Continue reading on Medium » Lets make shopping and…
Lets make shopping and learning more interesting with this blog. At first, managing these orders in notebooks or spreadsheets may seem… Continue reading on Medium » Lets make shopping and…
Learning SQL: Using Queries to Answer Business Questions Continue reading on Medium » Learning SQL: Using Queries to Answer Business QuestionsContinue reading on Medium » Read More Sql on Medium…
Learning SQL: Using Queries to Answer Business Questions Continue reading on Medium » Learning SQL: Using Queries to Answer Business QuestionsContinue reading on Medium » Read More Sql on Medium…
Check-in, project timers, daily reports and live dashboards for every role, connected to Slack. Continue reading on Medium » Check-in, project timers, daily reports and live dashboards for every role,…