Snowflake Fundamentals
Course Description
Snowflake is a cloud-based data warehouse and analytical tool. With so many SaaS Data warehouse solutions available competing against one another, Snowflake stands out among the crowd for its uniqueness in design and approach. This course helps candidates prepare for the SnowPro Core Certification.
| Duration | Delivery Method | Mandatory Prerequisites | Who Should Attend |
|---|---|---|---|
| 4 days | Virtual – Intructor led |
|
The audience for this class is Data Analysts, Data Engineers, Data Scientists, Data Architects, and Database Administrators. |
Course Objectives:
Attendees will leave understanding the Snowflake architecture, how to load and transform data, and how to evaluate query constructs, DDL and DML Operations. They will also learn how to manage application and user access, learn best practices for working with semi-structured data, and employ Snowflake’s method for continuous data protection. This course will also serve as preparation for the SnowPro Core Certification.
Agenda:
|
Data Warehousing Overview
Architecture and Overview
Architecture Deep Dive
Data Movement
Objects and Commands
|
SQL Support for Data Analysis
Managing Security
Semi-structured data
Caching
|
Clients and Ecosystem
Security
Performance and Concurrency
Account and Resources Management and Monitoring
|