Snowflake Training
ExpertLogix offers instructor-led classes and self-directed learning in Snowflake to build a career in data engineering. Our well planned training gets Data Engineers, Analysts and Architects started on Snowflake and builds skills for advanced data projects.
We explain Snowflake concepts in an easy to understand manner through hands-on labs, exercises and projects. Our goal is to prepare Snowflake experts by providing explanations of Snowflakes basic to advanced concepts.
We strive to guide our candidates for Snowflake Certification and help them ingetting the job of their choice through job search assistance and mock interviews.
Course Includes
Instructor led 24 hours of sessions
One on one interaction
Hands on labs
Certification oriented curriculum
Convenient schedules
Project use cases
Demo class on request
Mock interviews
The course completes in eight sessions and each session includes different content for you to learn and explore.
Sessions 1
- Getting started
- UI overview
- Snowflake warehouse
- Databases and schema
- Snowflake roles
- Access control
Sessions 2
- Snowflake editions
- Ecosystem
- Snowpark
- Metadata, DDL, DML
- Sequences
- Constraints
Sessions 3
- Loading Data – Stages, external tables, integrations
- Unloading Data – UI, programatically
- SnowSQL
- SnowPipe
Sessions 4
- Snowflake architecture
- Tasks and streams
- Stored procedures
Sessions 5
- Security and compliance
- Data sharing
- Cloning
- Secured views
- Materialized views
Sessions 6
- Fail Safe
- Time travel
- Data masking
- Mini project
Sessions 7
- Optimization and performance tuning
- Query profiles
- Clustering
- Materialized views
- Caching
- Search optimization
Sessions 8
- Certification guidance
- Interview preparation