Snowflake Architecture and Overview

Overview

Snowflake Technical Overview

Overview + Hands-On

Cloud Services Layer

Overview

Compute Layer

Overview Hands on

Storage Layer

Overview Hands on

Data Movement

Overview Hands on

Data Loading

Hands on

Unloading

Hands on

Best Practices

Overview

Snowflake Objects & Commands

Hands on

Query Constructs

Hands on

Data Description Language (DDL)

Hands on

Data Manipulation Language (DML)

Hands on

Snowflake SQL Support for Data Analysis

Hands on

SQL Support and Query Best Practices

Hands on

SQL Analytic Functions

Hands on

Demo Query Profile

Managing Security

Hands on

Data Encryption

Overview

Authentication

Overview

Role-Based Access Control

Hands on

Loading New Data Sets

Hands on

Ingesting new data into Snowflake tables

UsingTalend or Matillion or Stitchon demo hands on ingestion

Hands on

Working with various SQL data types

Hands On

Streaming data Ingestion/Continuous data ingestion

Snowpipe example simulation.

Hands On

(Available on request-Optional)

Loading data from S3 using Snowpipe

Hands on

Automated data ingestion into Snowflake table using Snowpipe

Hands on

Near Real Time data ingestion  techniques

Hands on

Ingestion best practices and anti-patterns

Overview

Querying Data and Best Practices

Hands on

Filtering data examples and best practices

Hands on

Grouping / Joining and sorting data and performance considerations

Hands On

Working with Semi-Structured Data

Hands on

Data source formats (few different heterogeneous data input will be used such as files (delimited/CSV/jsonetc.) , RDBMS (Mysql-optional), REST API (optional) etc

Hands On

Caching

Hands On

Caching Features in Snowflake

Hands on

Result set cache

Overview

Metadata cache

Overview

Query data cache

Hands on

Best Practices of using caching for performance and cost optimization

Overview

Snowflake Clients and Ecosystem

Overview

Snowflake Clients and Connectors Overview

Overview

SnowSQL ? Snowflake CLI

Hands on

Continuous Data Protection

Overview

Time Travel in Snowflake

Overview + Hands On

Cloning in Snowflake

Overview-Hands on

 IAM Roles

Overview

Data Sharing

Handson & overview

Introduction to SSO and MFA

Overview

Data Ingestion using etl pipeline

Hands on*

Performance monitoring and management of query and ETL workloads

Overview

Query profiling

Overview

Virtual warehouse (compute resource) management

Handson & overview

Tuning workloads

Overview

Monitoring functions

Overview and Hands On

Optimization of storage & compute

Admin module. Overview

Optimizing cost

Overview

Scaling a Virtual Warehouse

Overview & Hands on

Account and Resource Management and Monitoring

Overview

System Resource Usage and Billing

Overview

Managing Virtual Warehouses

Overview

Migration use case (on premise to cloud DWH)

Overview

Two Industry use cases using snowflake – data storytelling and scenario explanation

Overview

Connect with PowerBI after data loaded (sample) for visualization – demo purpose only

Overview & hands on

Snowflake performance benchmarks against other cloud DB/DWH and approach to test

overview