• This course is designed for anyone interested to get started with using Snowflake – Developers, DBA, Architects.

• Have taken Kick start Snowflake in a day or understand basics of Snowflake architecture.

Topic Outline:

1. Build An RBAC Hierarchy

• Role hierarchies
• Multifactor Authentication and Authorization
• Security Best Practices
• Lab: Connecting Snowflake

2. Data Sharing And Disaster Recovery

• Overview of Time Travel and Copy Cloning
• Data Sharing
• Overview of Disaster Recovery
• Disaster Recovery with Snowflake
• Lab: Data Sharing and Disaster Recovery

3. Performance Tuning And Resource Management

• Designing High Performance Tables and Queries
• Resource Usage and Billing
• Multi-clustering and Clustering Keys
• Lab: Clustering

4. Caching To Improve Performance

• Table Types – Temp, Transient and Permanent
• Snowflake caching features
• Lab: Caching

5. Tasks And Scheduling Management

• Integrating Store Procedures, Views and Functions
• Tasks and Scheduling
• Lab: Stored Procedure

Training material provided: Yes (Digital format)