Snowflake for Developers Training
Level
IntermediateDuration
16h / 2 daysDate
Individually arrangedPrice
Individually arrangedSnowflake for Developers Training
Snowflake is a modern, relational cloud-based database that allows efficient work with unlimited data size and queries. It is ideal for creating large, scalable data warehouses and is characterized by a very high level of security.
What You Will Learn
- Understand the architecture and capabilities of Snowflake for building scalable data warehouses
- Work with ecosystems and connections to Snowflake for efficient data integration and management in the cloud
- Master SQL in the context of Snowflake, including practical exercises with Snowflake structures
- Model and handle semi-structured data (e.g. JSON) with SQL in Snowflake
- Automate tasks in Snowflake, including Q&A sessions, security, and permissions management
- Load data with Snowpipe, use SnowSQL, and perform integration and data loading
- Manage data protection, sharing, performance, scaling, and optimization in Snowflake
- Explore Snowlight (new UI) and its analytical capabilities through practical exercises
Who is this training for?
Developers working with databases-
UI designers, administrative analysts, and developers
Training Program
-
Overview and Architecture
- General description of Snowflake architecture
-
Ecosystems and Connections
- Layers of the Snowflake platform
- Available connection methods
-
SQL in Snowflake
- SQL overview
- Practical SQL exercises in Snowflake structures
-
Semi-structured Data
- Modeling semi-structured data
- Practical SQL exercises with JSON and non-tabular data
-
Task Automation in Snowflake
- Automating common operations
-
Security and Permissions
- Roles in Snowflake
- Practical exercises for queries and access control
-
Data Loading
- Loading data with Snowpipe
- SnowSQL administration basics
- Integration and loading tasks
-
Data Protection and Sharing
- Protecting data
- Sharing data with practical exercises
-
Performance and Scaling
- Performance optimization methods
- Hands-on optimization tasks
-
Account & Resource Management (Snowlight)
- Using Snowlight as a modern UI for analytics
- Hands-on administrative analytics exercises
-
Additional
- Q&A sessions throughout the course
