Sign in to view content

Sign in to view this lesson and continue learning.

Complex Data Types Lab

Bonus
31 mins
SQLData Modeling

Description

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.