Data Engineer

How Netflix Uses Apache Spark: A Technical Deep Dive

Advanced SQL topics for data engineers

Advanced SQL Techniques for Data Engineers: Examples with…

Understanding ETL/ELT Data Pipelines in Data Engineering

Pivot Tables in SQL with Practical Example

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

Predicate Pushdown Optimization in Apache Spark with Databricks

Understanding Spark Locality Levels

Apache Spark is a powerful distributed computing framework that processes large-scale data sets…

Python Data Structures for Data Engineers

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

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

Let’s talk about `COUNT(*)` and `COUNT(1)` in SQL. You’ve probably seen both used to count rows in a table…

What happens when you Fire SQL Query?

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