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 | Sep 2021 | Oct 2021 | Nov 2021 | Dec 2021 | Jan 2022 | Feb 2022 | Mar 2022 | Apr 2022 | May 2022 | Jun 2022 | Jul 2022 | Aug 2022 | Sep 2022 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Virtual Classroom (AMER/CT) |
Sep 28 – Sep 30 |
Nov 9 – Nov 11 |
Dec 8 – Dec 10 |
Jan 19 – Jan 21 | |||||||||
| Virtual Classroom (EMEA/GMT) |
Oct 19 – Oct 21 |
Nov 30 – Dec 2 |
Already enrolled in an Instructor-Led class or paid On-Demand course? Log in to your Learner Dashboard.
Public Training
Virtual Classroom (AMER/CT)
-
9:00 AM - 5:00 PM CDT$ 3000.00 USD -
9:00 AM - 5:00 PM CST$ 3000.00 USD
-
9:00 AM - 5:00 PM CST$ 3000.00 USD
-
9:00 AM - 5:00 PM CST$ 3000.00 USD
Virtual Classroom (EMEA/GMT)
-
9:00 AM - 5:00 PM BST$ 3000.00 USD
-
9:00 AM - 5:00 PM GMT$ 3000.00 USD
Classes marked with are full and no additional registrations are accepted.
Don't see a date that works for you?