Raj

DB Ticket - Data Model

SQL Case Study – 1 (DB Ticket)

Leave a Comment / SQL Case Study / Raj

Problem Statement In this case study, you have joined as junior Data Engineer as part of Data Engineering team that develops & maintains a data warehouse for a ticketing business. The data model and tables with sample records are available in DEV environment for you to explore. SQL Level : *Hard As part of this […]

SQL Case Study – 1 (DB Ticket) Read More »

Timestamp & Timezone

Leave a Comment / Teradata / Raj

Timestamp & Timezone Read More »

Aggregate Fact Tables in Data Warehouse

Leave a Comment / Teradata / Raj

Aggregate Fact Tables in Data Warehouse Read More »

Different Types of Script to create in etl pipeline

Leave a Comment / Data Warehouse / Raj

Different Types of Script to create in etl pipeline Read More »

SQL Query – Find customer ID that are present in customers table and not in order tables

Leave a Comment / SQL / Raj

One of the very common business scenario in SQL is to find the record that exists in one table and does not exists in the other table. You can solve such questions in 4 different manners. Problem Statement You are running an online business in which customers can register on your website. As soon as

SQL Query – Find customer ID that are present in customers table and not in order tables Read More »