# Dimensional Data Modeling - Complex Data Types Arrays and Structs with Iceberg (Day 1 Lab)

> In this lab, we explore Slowly Changing Dimensions (SCDs) and design Cumulative Tables using the nba_players dataset. This is our first stress test of our web-based interface linked to a Presto/Trino database running in Starburst. Presto (formerly PrestoSQL) or Trino are both query engines that all…

- Web page: https://www.dataexpert.io/lesson/dimensional-data-modeling-day-1-lab-v3
- Program: [Data Engineering Boot Camp V2 Combined Track](https://www.dataexpert.io/program/data-engineering-boot-camp-v2-combined-track)
- Module: Week 1: Dimensional Data Modeling in Iceberg
- Access: Requires enrollment in Data Engineering Boot Camp V2 Combined Track
- Length: 55 min video
- Skills: SQL, Data Modeling, Apache Iceberg
- Academy: DataExpert.io Academy

## About this lesson

In this lab, we explore Slowly Changing Dimensions (SCDs) and design Cumulative Tables using the `nba_players` dataset. This is our first stress test of our web-based interface linked to a Presto/Trino database running in Starburst. Presto (formerly PrestoSQL) or Trino are both query engines that allow users to query and analyze data in a data lake using SQL, while Starburst offers a distribution of Presto/Trino. During this session, attendees executed 1742 queries in one hour and Starburst handled the workload without any issues! This lab not only demonstrates how to design cumulative tables but also showcases the power of running analytics in the data lake! [Recorded Nov 7, 2023]

## Navigation

- Previous lesson: [Dimensional Data Modeling - Complex Data Types Arrays and Structs with Postgres (Day 1 Lecture)](https://www.dataexpert.io/lesson/dimensional-data-modeling-day-1-lecture-v2.md)
- Next lesson: [Dimensional Data Modeling - Complex Data Types Arrays and Structs with Iceberg (Day 1 Lecture)](https://www.dataexpert.io/lesson/dimensional-data-modeling-day-1-lecture-v3.md)