How to format Zipcode / Postal Code in Oracle
Sometimes , in the applications , zipcodes are stored as numbers . That means , the leading zeros for some of the postal codes will not be… Continue reading on…
Data Analysis Help with Expert Tools — 20% Discount ✨
📊 Data Analysis Help with Expert Tools — 20% Discount ✨ Continue reading on Medium » 📊 Data Analysis Help with Expert Tools — 20% Discount ✨Continue reading on Medium…
Leetcode 1148 Article Views 1
In this Question we need to find The Author who has read their own article. Continue reading on Medium » In this Question we need to find The Author who…
ICA VM Write-Up: Complete Walkthrough from Enumeration to Root
In this walkthrough, we will tackle the ICA: 1 vulnerable machine from VulnHub. This boot-to-root challenge provides an excellent hands-on… Continue reading on Medium » In this walkthrough, we will…
Leetcode 1683 Invalid Tweets
The Problem is very simple as we need to find the tweet_id Continue reading on Medium » The Problem is very simple as we need to find the tweet_idContinue reading…
One Data Thing A Day: CTEs Done Right (And the Trap That Almost Got Me)
This week’s theme is CTEs. Not just how to write them — but the one thing about them that nobody explains until it’s already cost you a… Continue reading on…
What I Wish I Knew Before Passing the New DP 800 Microsoft SQL AI Developer Associate Certification
I recently passed the DP-800 SQL AI Developer Associate exam. Since it is a new certification, I want to share some tips that I would have… Continue reading on Medium…
Master SQL from Scratch : A Beginner’s Roadmap to Databases, Data Analysis and Tech Careers
Data is at the centre of almost every modern organisation. Every customer interaction, online purchase, financial transaction, employee… Continue reading on Medium » Data is at the centre of almost…
Marketing Campaign Analysis Using Power BI: Transforming Campaign Data into Business Insights
Introduction: Continue reading on Medium » Introduction:Continue reading on Medium » Read More Sql on Medium #sql
From Spatial Index Join to Eval Data Pipelines
Over June and July 2026, Databend shipped 182 changes across query optimization, spatial analytics, open lakehouse integration, data… Continue reading on Medium » Over June and July 2026, Databend shipped…
From Million-Token Agents to Eval-Ready Data
From Kafka ingestion and schema-flexible raw storage to incremental processing, Evals, and governed analytics for million-token AI… Continue reading on Medium » From Kafka ingestion and schema-flexible raw storage to…
The Ultimate SQL Cheat Sheet for Handling Missing and Duplicate Data
You can write a beautiful query with perfect joins, clean CTEs, and carefully selected columns. But if the underlying table contains… Continue reading on Medium » You can write a…
What Happens When Your Join Meets a Skewed Key
The average looks fine. The average is lying to you. Continue reading on Medium » The average looks fine. The average is lying to you.Continue reading on Medium » Read…
Mastering Oracle Fusion Payables: Invoice Types and End-to-End Database Table Hits
In Oracle Fusion Cloud Financials (Payables), understanding how different invoice types travel through the lifecycle — from initial… Continue reading on Medium » In Oracle Fusion Cloud Financials (Payables), understanding…
OLTP ve OLAP Nedir? Aynı Veri Neden İki Farklı Dünyada Yaşar?
Bir sistem veriyi saniyeler içinde kaydedebiliyorsa, neden aynı sistem üzerinden analiz yapmak çoğu zaman iyi bir fikir değildir? OLTP ve… Continue reading on Medium » Bir sistem veriyi saniyeler içinde…
The “Specified Key Was Too Long” Laravel Migration Error — And the One-Line Fix Nobody Talks About
If you’ve ever run php artisan migrate:fresh on a fresh WAMP/MySQL setup and hit this wall, you know the frustration: Continue reading on Medium » If you’ve ever run php…
My First Java Web Project: What I Learned Building an Election Campaign Management System
When I started my first Java web project, I knew the basics of Java, but I didn’t really understand how all the pieces of a web… Continue reading on Medium…
If you’re preparing for a Data Analyst interview, there’s one skill you simply can’t ignore: SQL.
Whether you’re interviewing at a startup, a healthcare company, a bank, or a tech giant like Amazon or Microsoft, SQL is almost always… Continue reading on Medium » Whether you’re…
How I Designed a Schema That Scaled to 1 Billion Rows
Every decision below looks obvious in isolation and was learned the hard way, usually after the wrong version had already been running in… Continue reading on Medium » Every decision…
You Chose Synchronous Replication for Everything Because “Data Loss Is Bad.”
“We can’t lose any data,” the engineering lead said. Correct, this is a reasonable position. “So we set up synchronous replication to all… Continue reading on Medium » “We can’t…