Snowflake Snowpark Dataframe Programming Course Overview

Course Prerequisites

• Basic Computer Knowledge.

Target Audience for Snowflake Snowpark Dataframe Programming

Snowflake Snowpark Dataframe Programming is a one-day course designed for practitioners with basic Java, Scala, or Python skills to build DataFrame solutions in Snowflake, covering key concepts, features, and implementation.

Job Roles and Audience:

• Data Engineers
• Data Scientists
• Data Analysts
• Software Developers
• Business Intelligence Developers
• IT Professionals working with Snowflake
• Cloud Engineers
• Database Administrators
• ETL Developers
• Big Data Engineers

Learning Objectives - What you will Learn in this Snowflake Snowpark Dataframe Programming?

Introduction: The Snowflake Snowpark DataFrame Programming course is designed to equip practitioners with essential skills in building DataFrame data solutions on Snowflake. This intensive one-day course covers key concepts, features, and programming constructs through lectures, demos, labs, and discussions.

Learning Objectives and Outcomes:

• Understand the Snowpark technical overview and API to start efficiently on Snowflake.
• Learn to set up Snowflake connections, including various authentication methods.
• Gain knowledge about DataFrames in Snowpark and their execution on Snowflake’s Elastic Compute Engine.
• Explore multiple methods to create a DataFrame object and understand schemas, data types, and lazy evaluation.
• Apply column operations for data filtering and transformation using scalar functions and operators.
• Perform sorting, limiting, and aggregate operations on DataFrames.
• Transform semi-structured data within DataFrames.
• Differentiate between DataFrame actions and transformations; practice evaluating transformations with actions that return data.
• Publish logical DataFrame operations as views and learn to create and append Snowflake tables with DataFrame results.
• Write, register, and share user-defined functions (UDFs) in Snowpark.
• Author and deploy stored procedures using Python worksheets.

This comprehensive training will provide students with a robust understanding and practical skills to harness