ETL SQL

Learn Extract Transform Load using SQL & PySpark

Category: Data Warehouse

  • DataWarehouse Migration Projects – Beginner Guide

    For the past few years I have been involved in many projects where the requirement was to migrate the existing on-premises data warehouse to modern platform. In this post I will share my experience and observation about the migration projects and why it is fun to be part of Migration projects. Wave of Migration Projects…

  • Reverse engineering of SQL queries to generate Data Model

    In this post I will share a quick method which you can use to create a data model from any existing SQLs in your data warehouse environment. Data Model actually plays a very vital role in building understanding of your data warehouse. When you are new to any project, understanding the existing data model can…