Snowflake Fundamentals 4-Day

Course Outline

Week 1:

Snowflake Architecture and Overview

• Snowflake Technical Overview

• Cloud Services Layer

• Storage Layer

• Compute Layer

Snowflake Clients & Ecosystem

• Snowflake Clients and Connectors Overview

• SnowSQL – Snowflake CLI

Caching

• Caching Features in Snowflake

• Best Practices of using caching for performance and cost optimization

Week 2:

Snowflake Objects & Commands

• Data Description Language (DDL)

• Data Manipulation Language (DML)

• Querying and Filtering

• Collations

• Subqueries

• The Query Profile

Data Movement

• Data Loading

• Unloading

• Best Practices

Streams & Tasks

Week 3:

Snowflake SQL Support for Data Analysis

• SQL Support and Query Best Practices

• SQL Analytic Functions

• High Performing Estimation Functions

• UDF and Stored Procedure

• Demo Query Profile

Managing Security

• Access

• Authentication

• Authorization

• Data Protection and Encryption

Access Control and User Management

• System Roles

• Custom Roles and Inheritance

• Ownership

• Configure and Manage Access

Semi-Structured Data

• Query Semi-Structured Data

• Load and Unload Semi-Structured data

Week 4:

Continuous Data Protection

• Cloning

• Time Travel

• Database Replication and Failover

Data Sharing

• Data Providers

• Data Consumers

• Reader Accounts

• The Data Marketplace

Performance & Concurrency

• Data Clustering

• Scaling a Virtual Warehouse

• SQL Performance Tips

Account and resource management & monitoring

• System Resource Usage and Billing

• Managing Virtual Warehouses

• Workload independence and segmentation

• Monitoring Tools: Resource Monitors

• Monitoring Tools:  Information Schema and Account Usage