Category: SQL
TikTok Engagement Analysis
What drives engagement on TikTok? A data dive into 19K videos Continue reading on Medium » What drives engagement on TikTok? A data dive into [more…]
Re-Learning SQL — 8 Week SQL Challenge — Week 1
This is my very first post on Medium, and I’ve decided to challenge myself with an 8-week SQL journey. Continue reading on Medium » This [more…]
Comprehensive Analysis of Nike Product Sales in 2020–2021
In 2020–2021, Nike continued to assert its dominance in the global sportswear industry despite the challenges brought on by the pandemic… Continue reading on Medium » [more…]
Why Your Azure MySQL Flexible Server Feels Slow “Out of the Box” — And What You Can Actually Do…
When developers migrate to Azure MySQL Flexible Server, everything looks great — until the app suddenly starts crawling. Pages take longer… Continue reading on Medium » When [more…]
We Accidentally Built a Time Machine in Our Data Pipeline
And it started rewriting production history Continue reading on Medium » And it started rewriting production historyContinue reading on Medium » Read More Sql on Medium #sql
How to solve Invalid Tweets Leetcode Problem
Perfect for beginners: learn how to approach the problem and implement a clean solution without overcomplicating it. Continue reading on Medium » Perfect for beginners: [more…]
The Architect’s Dilemma: Choosing Between SQL and NoSQL on AWS
A Deep Dive into Amazon RDS, Aurora, and DynamoDB for Building Scalable, Resilient Applications Continue reading on Medium » A Deep Dive into Amazon RDS, [more…]
Change Data Capture (CDC) with MySQL: A Practical Guide to Real-Time Data
In the world of modern data architecture, “real-time” is the gold standard 🏆. Batch jobs that run overnight are no longer sufficient for… Continue reading on [more…]
SQL Swiss Knife Part 5: Security, Constraints & Set Operations — The Final Frontier
Here we are at the final frontier! This is where we cover the commands that make your database secure, reliable, and capable of handling… Continue reading [more…]
Top 5 SQL Queries Every Data Analyst Should Know
Real-world examples that go beyond SELECT Continue reading on Medium » Real-world examples that go beyond SELECTContinue reading on Medium » Read More Sql on Medium #sql
Why I’m Choosing to Go Deep
Instead of Just Knowing a Bit of Everything Continue reading on Said Differently » Instead of Just Knowing a Bit of EverythingContinue reading on Said [more…]
This Is How SQL Keeps Transactions Safe Without Killing Performance
Introduction Continue reading on Medium » IntroductionContinue reading on Medium » Read More Sql on Medium #sql
Master the most frequently asked 100+ SQL questions in technical interviews
Master the most frequently asked SQL questions in technical interviews Continue reading on Javarevisited » Master the most frequently asked SQL questions in technical interviewsContinue [more…]
Master the most frequently asked 100+ SQL questions in technical interviews
Master the most frequently asked SQL questions in technical interviews Continue reading on Javarevisited » Master the most frequently asked SQL questions in technical interviewsContinue [more…]
SQL Swiss Knife Part 4: Advanced Schema Management & Database Evolution ️
Welcome to the schema evolution playground! This is where we learn to gracefully evolve database structures in production without breaking… Continue reading on Medium » [more…]
Subqueries and Correlated Subqueries in SQL
Continue reading on Medium » Continue reading on Medium » Read More Sql on Medium #sql
How Excel Users Are Quietly Becoming Data Engineers (Thanks to dbt)
If you still think Excel users are “just spreadsheet people,” you’re missing what’s happening behind the scenes. Continue reading on Medium » If you still [more…]
SQL Behind the Scenes: Understanding Query Execution Order
I’ve noticed that a lot of junior teammates and honestly, even experienced folks sometimes get tripped up by how SQL actually works. Not… Continue reading on [more…]
Beyond Basic Queries: Essential SQL Best Practices for Cleaner Code and Faster Performance
By Harsh Gupta Continue reading on Medium » By Harsh GuptaContinue reading on Medium » Read More Sql on Medium #sql
Understanding the Real Cost of Nested SQL Loops
Nested loops can ruin SQL performance at scale — learn what they are, when they’re dangerous, and how to replace them. Continue reading on Medium » Nested [more…]