# Advanced Snowflake: Data Modeling and UDFs Lab

> Explore the advanced capabilities of Snowflake in this lab focused on data modeling and User Defined Functions (UDFs). Participants will learn how to effectively implement UDFs for complex SQL queries, particularly in scenarios involving consecutive data streaks, such as tracking NBA player perform…

- Web page: https://www.dataexpert.io/lesson/advanced-snowflake-data-modeling-and-udfs-lab
- Program: [Analytics Engineering Boot Camp starting October 2024](https://www.dataexpert.io/program/analytics-engineering-boot-camp)
- Module: Advanced Snowflake
- Access: Requires enrollment in Analytics Engineering Boot Camp starting October 2024
- Length: 50 min video
- Skills: SQL, Data Modeling, Snowflake
- Academy: DataExpert.io Academy

## About this lesson

Explore the advanced capabilities of Snowflake in this lab focused on data modeling and User Defined Functions (UDFs). Participants will learn how to effectively implement UDFs for complex SQL queries, particularly in scenarios involving consecutive data streaks, such as tracking NBA player performance. The session covers practical coding techniques, including window functions and array handling, while also demonstrating the integration of external APIs for enhanced data insights. Ideal for data engineers and analysts looking to deepen their Snowflake expertise.

## Navigation

- Previous lesson: [Advanced Snowflake: Data Modeling and UDFs Lecture](https://www.dataexpert.io/lesson/advanced-snowflake-data-modeling-and-udfs-lecture.md)
- Next lesson: [SQL](https://www.dataexpert.io/lesson/sql-intereview.md)