nageen20.bsky.social
@nageen20.bsky.social
Check out my latest blog on introduction to database indexes - learn2infiniti.com/database-ind...
Database indexes: The key to faster queries - CONNECTING DOTS
In this blog, we discuss about database indexes, how they work, the different types of indexes and trade-offs in uisng them.
learn2infiniti.com
January 28, 2025 at 1:29 PM
Incremental loading is essential for efficient ETL pipelines, enabling you to process only the changes instead of entire datasets.

In my latest blog, I explain the key strategies and challenges.

Read more here: learn2infiniti.com/incremental-...

#DataEngineering #ETL #IncrementalLoading #BigData
Incremental Loading: Concepts - CONNECTING DOTS
In this blog, we discuss what incremental loading is in data engineering, when to use and the strategies to implement incremental loading.
learn2infiniti.com
January 11, 2025 at 8:59 AM
Fascinated by DuckDB 🦆? Check out my blog post comparing DuckDB and Pandas on medium sized datasets (24 million and 110 million rows).

No surprises - DuckDB wins by a margin.

learn2infiniti.com/experimentin...

#DuckDB #Pandas #DuckDBWins #DataEngineering
DuckDB - Exploring and Experimenting
This blog compares the DuckDB performance with Pandas and tests DuckDB on anime dataset and bitcoin datasets.
learn2infiniti.com
November 21, 2024 at 9:28 AM
Just starting in analytics? SQL Window Functions are must-know for analyzing datasets. These functions simplify complex queries and provide deep insights. 🚀

Check out the blog to get started on window functions
learn2infiniti.com/window-funct...
#SQL #DataAnalytics
SQL Window functions: Understanding PARTITION BY - I - CONNECTING DOTS
In this blog post, we introduce SQL window functions and how they work. We explain how to use PARTITION BY to define windows with an example.
learn2infiniti.com
November 19, 2024 at 12:25 PM
🚀 Curious about DuckDB? It's like SQLite but designed for analytics! A lightweight, in-process database that handles massive datasets with ease. 🌟

Check out my blog to get started with DuckDB!

learn2infiniti.com/using-duckdb...
#DuckDB #DataAnalytics #SQL
Using DuckDB for Ad-Hoc Analysis: A SQL-Lover's Alternative to Pandas - CONNECTING DOTS
In this blog, we give a quick introduction to DuckDB and discuss how we can get started with DuckDB using Dbeaver.
learn2infiniti.com
November 18, 2024 at 8:36 AM
Want to understand how Parquet file structure & metadata boost query performance? Dive into my latest blog post to explore row groups, columnar storage, and metadata magic that powers fast analytics. 🚀 Read here: learn2infiniti.com/apache-parqu...

#DataEngineering #Parquet
Apache Parquet - File structure and metadata - CONNECTING DOTS
This blog discusses Apache Parquet file structure and metadata and how it uses columnar storage and metadata for quick reads.
learn2infiniti.com
November 17, 2024 at 2:49 PM