Materiais

Conteúdo Programatico

Snowflake Architecture and Overview

1. Snowflake Technical Overview
2. Cloud Services Layer
3. Compute Layer
4. Storage Layer 

Data Movement

1. Data Loading
2. Unloading
3. Best Practices

Snowflake Objects & Commands

1. Query Constructs
2. Data Description Language (DDL)
3. Data Manipulation Language (DML)

Snowflake SQL Support for Data Analysis

1. SQL Support and Query Best Practices
2. SQL Analytic Functions
3. High Performing Estimation Functions
4. UDF and Stored Procedure
5. Demo Query Profile

Managing Security

1. Data Encryption
2. Authentication
3. Role-Based Access Control

Semi-structured Data

1. Capabilities and Best Practices for working with semi-structured data in Snowflake
2. Caching
3. Caching Features in Snowflake
4. Best Practices of using caching for performance and cost optimization

Snowflake Clients and Ecosystem

1. Snowflake Clients and Connectors Overview
2. SnowSQL – Snowflake CLI
3. Continuous Data Protection
4. Time Travel in Snowflake
5. Cloning in Snowflake

Data Sharing

1. Snowflake Data Sharing Overview
2. Performance & Concurrency
3. Query Profile
4. Micro-Partitions & Data Clustering
5. Scaling a Virtual Warehouse

Account and Resource Management and Monitoring

1. System Resource Usage and Billing
2. Managing Virtual Warehouses
3. Workload independence and segmentation
4. Monitoring Tool: Resource Monitors
5. Monitoring Tools: Information Schema and Account Usage