Pipeline To Insights

Pipeline To Insights

Home
Notes
Data Engineering Lifecycle
SQL Optimisation
DE Interview Preperation
Data Quality
Data Career Transition
data build tool (dbt) series
Archive
Leaderboard
About

SQL Optimisation

Data Compression in SQL
How to Store More and Query Faster in SQL
Mar 14 • 
Erfan Hesami
30
Week #9: 100 Days of SQL Optimisation
Optimising query performances in DuckDB
Jan 16 • 
Erfan Hesami
16
3
Week #8: 100 Days of SQL Optimisation
Optimising query performances in DuckDB
Jan 7 • 
Erfan Hesami
10
Week #7: 100 Days of SQL Optimisation
Improving query performances in DuckDB
Dec 31, 2024 • 
Erfan Hesami
11
Week #6: 100 Days of SQL Optimisation
Exploring DuckDB and Its Capabilities
Dec 17, 2024 • 
Erfan Hesami
13
Week #5: 100 Days of SQL Optimisation
Tips for maximising SQL query efficiency
Dec 5, 2024 • 
Erfan Hesami
15
Week #4: 100 Days of SQL Optimisation
How to optimise SQL queries for maximum efficiency
Nov 28, 2024 • 
Erfan Hesami
19
Week #3: 100 Days of SQL Optimisation
Fine-Tuning SQL: Writing Efficient Queries for Better Performance
Nov 21, 2024 • 
Erfan Hesami
17
SQL Behind the Curtain: How Are Queries Executed?
Explore the journey of our SQL query guided by execution plans
Nov 19, 2024 • 
Erfan Hesami
41
Week #2: 100 Days of SQL Optimisation
How Well-Designed Query Structures Can Boost SQL Query Efficiency
Nov 14, 2024 • 
Erfan Hesami
27
Week #1: 100 Days of SQL Optimisation
How Small Tweaks Transformed Our Queries, Saving Time and Resources
Nov 7, 2024 • 
Erfan Hesami
97
12
© 2025 Erfan Hesami
Privacy ∙ Terms ∙ Collection notice
Start your SubstackGet the app
Substack is the home for great culture