Snowflake Data Engineer Training

Snowflake Data Engineer Training

Snowflake Data Engineer Training

Summary

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.

Duration

3 Days

Objectives

By the end of this course, you will learn:

  • 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

Audience

Who should attend this course?

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

Prerequisites

Basic knowledge of SQL and Python is helpful.

Setup Requirements

Data Engineer students need...

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

Outline

View and download the Data Engineer Course Datasheet.

Upcoming Classes

Online

Instructor-led online training

Location May 2022 Jun 2022 Jul 2022 Aug 2022 Sep 2022 Oct 2022 Nov 2022 Dec 2022 Jan 2023 Feb 2023 Mar 2023 Apr 2023 May 2023
Virtual Classroom (AMER/CT) May 24 – May 26
Jun 28 – Jun 30
Jul 26 – Jul 28
Virtual Classroom (EMEA/GMT) Jun 7 – Jun 9
Jul 5 – Jul 7

Already enrolled in an Instructor-Led class or paid On-Demand course? Log in to your Learner Dashboard.