Snowflake Data Engineer Training

News
NEW ADVANCED CERTIFICATION AVAILABLE ➤  Learn more about the SnowPro Advanced: Architect exam.   NEW PERFORMANCE AUTOMATION & TUNING COURSE ➤  Learn more and sign up for the first public instructor-led class!   COMPLETE YOUR SNOWPRO CORE CERT. PREP WITH OUR ON-DEMAND PREPARATION COURSE➤   Learn more!   COVID-19 UPDATES ➤   Instructor-led classes will be delivered via virtual classroom only.  

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)
  • SNOWSQL installed

Outline

View and download the Data Engineer Course Datasheet.

Upcoming Classes

Online

Instructor-led online training

Location Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 Jun 2021 Jul 2021 Aug 2021 Sep 2021 Oct 2021
Virtual Classroom (AMER/CT) Nov 17 – Nov 19
Jan 19 – Jan 21
Virtual Classroom (EMEA/GMT) Dec 1 – Dec 3
Virtual Classroom (APAC/IST) Jan 5 – Jan 7

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