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.
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
Setup Requirements
Data Engineer students need...
- to bring a laptop
- a Snowflake compatible browser (see options HERE)
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 |