Count(*) vs Count(1) in SQL.

If you’ve spent any time writing SQL queries, you’ve probably seen both `COUNT(*)` and `COUNT(1)` used to…

Advanced SQL topics for data engineers

Advanced SQL Techniques for Data Engineers: Examples with…

Understanding ETL/ELT Data Pipelines in Data Engineering

Cache vs Persist in Apache Spark: A Detailed Comparison

Exploring cache and persist in Apache Spark…

Predicate Pushdown Optimization in Apache Spark with Databricks

How Netflix Uses Apache Spark: A Technical Deep Dive

Pivot Tables in SQL with Practical Example

A pivot table in SQL is a technique used to transform data from rows into columns, or…

How does Shuffling work in Apache Spark?

Welcome to our beginner’s guide to shuffling in distributed computing! In this blog…

Python Data Structures for Data Engineers

When it comes to working with data in Python, choosing the right data structure is key…

What happens when you Fire SQL Query?

Have you ever wondered what happens behind the scenes when you fire an SQL query? It might…