Visão Geral

Este Curso Snowflake Foundations, cobre a arquitetura Snowflake e ensina as práticas recomendadas para configurar e implantar um banco de dados Snowflake baseado em nuvem.

Objetivo

Após realizar este Curso Snowflake Foundations você será capaz de:

• Descrever os conceitos básicos de nuvem, data warehouse, ETL/ETL e análise de dados
• Examine a arquitetura do Snowflake
• Examine os principais recursos do Snowflake
• Conecte-se ao Snowflake e atribua funções
• Crie objetos de banco de dados no Snowflake
• Ingerir dados estruturados e não estruturados no Snowflake
• Ingerir dados de streaming usando Snowpipe
• Clonar objetos de banco de dados
• Compartilhe dados usando a UI da Web
• Remova objetos do banco de dados usando comandos SQL

Materiais

Conteúdo Programatico

Introduction to Cloud and Data Warehouses

1. Introduction to Cloud
2. Why Cloud?
3. Cloud Providers
4. SaaS, PaaS, IaaS
5. What is a Data Warehouse
6. Why Data Warehouse
7. Data Warehouse Basic

Data Integration and Analytics

1. ETL/ELT
2. Batching vs. Streaming
3. Data Analytics & Visualizations
4. On-Prem Vs. Cloud

Introduction to Snowflake

1. What is Snowflake
2. Snowflake History
3. Datawarehouse as a Service
4. Supported Cloud platforms & Regions

Snowflake UI

1. Query Pane
2. Result Pane
3. Object Navigation Pane
4. Different Tabs
5. Examine Snowflake UI

Snowflake Architecture

1. Introduction to Snowflake Architecture
2. 3 Tier Architecture
3. Data Storage
4. Query Processing
5. Cloud Services

Snowflake Feature

1. Security & Data Protection
2. Standard & Extended SQL
3. Tools & Interfaces
4. Connectivity
5. Data Import & Export
6. Data Sharing
7. Database Replication & Failover
8. Continuous Data Protection

Connecting to Snowflake and Assigning Roles

1. Connecting to Snowflake
2. Snowflake Roles
3. Snowflake Editions

Creating Database Objects

1. Create Database objects
2. Stage Files
3. Create Objects in Snowflake

Structure Data Ingestion

1. Structured Data Ingestion
2. Data Staging
3. Bulk load from Cloud Storage
4. Bulk load from Local Storage
5. Query Data

Unstructured Data Ingestion

1. Unstructured Data Ingestion
2. JSON Ingestion
3. Query Data

Stream Data Ingestion

1. Introduction to Snowpipe
2. How to Create Pipe
3. How to Load Streaming Data
4. How Query Data
5. Ingesting Streaming Data

Clone Database Objects

1. Zero Copy Cloning
2. How to Clone a Database
3. How to Clone a Schema
4. How Clone Tables and Views
5. Cloning a Database

Data Sharing

1. What is Data Share
2. Data Providers
3. Data Consumers
4. Share with Snowflake users
5. Using Wed UI to Share
6. Share Data with Snowflake and Non-Snowflake

Un-drop Database Objects

1. Un-drop Database Objects
2. SQL Commands