Data Engineer

Description

This 3-day role specific course covers the Snowflake key concepts, features, considerations, and best practices intended for key stakeholders who will be accessing, developing, querying datasets for analytic tasks and building data pipelines in Snowflake. These stakeholders often are in the role of database application developer and data engineer. This course will consist of lectures, demos, labs, and discussions. Prerequisite Snowflake Foundations is a prerequisite for this course. The prerequisite is estimated to take about 5 hours to complete. If you have previously completed Snowflake Fundamentals, Data Engineer, Data Science, or Administering Snowflake you do not have to take the Foundations prerequisite course. Questions? Submit a Case

Objectives

View the COURSE DATASHEET

• •Overview of Snowflake key features and architecture
• •Performance and cost optimization techniques using caching and high performing functions
• •Learn different UI and application methods of accessing Snowflake
• •Use the capabilities and best practices for working with semi-structured data in Snowflake Load, unload data sets and best practices
• •Tune queries and performance using advanced techniques such as data clustering and materialized views
• •Develop application for Snowflake including using comprehensive ANSI standard SQL support
• •Leveraging Snowflake SQL extensibility features such as time travel capabilities, user-defined functions and stored procedures

Prerequisites

• •Basic knowledge of SQL and Python is helpful.
• •Snowflake Foundations On-Demand (estimated to take 5 hours to complete)

Setup Requirements

• •to bring a laptop
• •a Snowflake compatible browser (see options HERE)

Audience

• •Data Analysts
• •Data Engineers
• •Data Scientists
• •Database Architects
• •Database Administrators