A.A
Home Projects Blog
Blog

Insights and tutorials on data engineering, analytics, and modern data stack technologies.

Learnings from Pursuing High Data Quality: A Reflective Piece
Mar 05, 2026 4 min read
Learnings from Pursuing High Data Quality: A Reflective Piece

Cover Photo by Claudio Schwarz on Unsplash Before diving in, let us discuss what data quality...

datalearningdiscussdatascience
Read More
The evolution of the Modern Data Stack: From RDBMS to the LakeHouse
Jan 13, 2026 11 min read
The evolution of the Modern Data Stack: From RDBMS to the LakeHouse

This post aims to provide a historical picture of the evolution of the typical data stack over a span...

learningdiscussarchitecturedataengineering
Read More
Data Compression, Types and Techniques in Big Data
Feb 25, 2025 11 min read
Data Compression, Types and Techniques in Big Data

Cover Photo by Tim Mossholder on Unsplash Introduction This article will discuss...

datalearningdiscussdatascience
Read More
Custom Data Types in SQL
Feb 04, 2025 6 min read
Custom Data Types in SQL

Cover Photo by Xavi Cabrera on Unsplash Before, we dive in, this post focuses on Oracle databases....

SQLdatalearningoracle
Read More
Understanding Database Indexes And Their Data Structures: Hashes, SS-Tables, LSM Trees And B-Trees
Mar 05, 2024 10 min read
Understanding Database Indexes And Their Data Structures: Hashes, SS-Tables, LSM Trees And B-Trees

There's often a huge fuss about making data-driven decisions, leveraging data analytics, using data...

databaseprogrammingtutorialarchitecture
Read More
Functions in SQL
Feb 27, 2024 3 min read
Functions in SQL

Functions are very similar to procedures in databases. In this article, I will try to break down...

SQLdatabaseprogrammingtutorial
Read More
Database Triggers in PostgreSQL: A Deep Dive using AWS RDS
Feb 20, 2024 5 min read
Database Triggers in PostgreSQL: A Deep Dive using AWS RDS

Photo by Jr Korpa on Unsplash Database triggers are special types of objects. They look like...

databaseprogrammingpostgresaws
Read More
How to write Database Procedures
Feb 15, 2024 4 min read
How to write Database Procedures

What are Database Procedures Procedures are commonplace across several different...

SQLdatabaseprogrammingoracle
Read More
Mastering Common Database Objects - Series 1 .. n
Feb 15, 2024 1 min read
Mastering Common Database Objects - Series 1 .. n

In the series, I hope to cover some common database objects such as procedures, functions, triggers...

SQLdatabaseprogrammingawsbigdata
Read More
Energy Forecasting with LSTM Neural Network
Feb 12, 2024 1 min read
Energy Forecasting with LSTM Neural Network

Several methods have been used in energy forecasting over the years. Methods from different...

Pythondatasciencelstmmachinelearning
Read More
What to think about when designing, building, managing and operating data systems.
Feb 10, 2024 8 min read
What to think about when designing, building, managing and operating data systems.

This post draws extensively from a book I am currently reading and my experience managing data...

learningdiscussdataengineeringsystemdesign
Read More