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 | Jun 2021 | Jul 2021 | Aug 2021 | Sep 2021 | Oct 2021 | Nov 2021 | Dec 2021 | Jan 2022 | Feb 2022 | Mar 2022 | Apr 2022 | May 2022 | Jun 2022 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Virtual Classroom (AMER/CT) |
Jul 7 – Jul 9 |
Aug 10 – Aug 12 |
Sep 28 – Sep 30 | ||||||||||
| Virtual Classroom (EMEA/GMT) |
Jul 27 – Jul 29 |
Oct 19 – Oct 21 | |||||||||||
| Virtual Classroom (APAC/IST) |
Aug 2 – Aug 4 | ||||||||||||
| Virtual Classroom (APAC/Sydney) |
Aug 23 – Aug 25 |
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 CDT$ 3000.00 USD
-
9:00 AM - 5:00 PM CDT$ 3000.00 USD
Virtual Classroom (EMEA/GMT)
-
9:00 AM - 5:00 PM BST$ 3000.00 USD
-
9:00 AM - 5:00 PM BST$ 3000.00 USD
Virtual Classroom (APAC/IST)
-
9:00 AM - 5:00 PM IST$ 3000.00 USD
Virtual Classroom (APAC/Sydney)
-
9:00 AM - 5:00 PM AEST$ 3000.00 USD
Classes marked with are confirmed to run. Sign up now while there is still space available!
Don't see a date that works for you?