Build a turbo-powered Cloud Data Warehouse using Snowflake!

Cloud Data Warehouse is the next big thing. Learn What is Snowflake Cloud Data Warehouse and its architecture. Build highly scalable, high performance next-gen modern data warehouse for you company. The course is designed in beginner friendly, helping you to understand the basics of cloud, SAAS and it all works together in the background.

Requirements

  • Previous knowledge of SQL would be nice but not mandatory

Who this course is for:

  • Data science
  • Data Warehouse
  • Cloud Data Warehouse
  • Snowflake
  • Teradata

5 Day Virtual Course overview:

Day 1
Cloud Data Warehousing – Concepts
 Data warehousing: past to present
 Understanding the benefits of a cloud data warehouse
Introduction to Snowflake
 Key Concepts
 Snowflake Architecture
 Cloud Platforms
 Snowflake Editions
 The Data Lifecycle
 Continuous Data Protection
 Different connection types
Registration, Installation and Configuration
 Creating an account in Snowflake
 Install and Configure Connection tools
 Install drivers and Compatible Diagnostic tool
 Download sample files

Day 2
Using Snowflake
 A look into the Web Interface
 Virtual Warehouses
o Create Warehouse
o Scaling up and out
o Clusters
 Databases, Schemas, Tables & Views
o Create Database
o Create Schema
o Create table using SQL and Web Interface
o Creating and using Views
 Stages, File format & Sequences
o Type of Stages
o Using Stages
o Creating Stages
o Creating File Formats
o Working with Sequences
 Loading Data using Web Interface (Limited)
Connecting to Snowflake
 Connecting Through SnowSQL (CLI Client)
 Configuring and Using the JDBC Driver
 ODBC Configuration and Connection Parameters
 ODBC Driver Diagnostic Service
 Diagnosing Common Connectivity Issues

Day 3
Loading / Unloading Data into/from Snowflake
 Preparing to Load/Unload Data
 Overview of Data Loading/Unloading
 Data Loading/Unloading Considerations
o Loading from local system
o Loading form external stages AWS & Azure
o Unloading from tables into stages
 Bulk Loading/Unloading
Working with roles
 Creating Users
 Assigning Roles
 Create Roles from existing Roles
 Restricting access for users
Query Performance and Credit Usage
 Understanding Snowflake Credit and Storage Usage
 Understanding Snowflake Data Transfer Billing
 Monitoring Account-level Credit and Storage Usage
 Getting the query execution details
 Estimating the credits used

Day 4
Snowflake Special Features
 Working with Semi-structured Data
 Materialized Views
 Cloning
 Time Travel & Fail-safe
 Querying Data in Staged Files
 Querying Metadata for Staged Files
Automatic Continuous Load
 Loading Continuously Using Snowpipe
o Using Notification Service in AWS
o Create Queuing in Snowflake
o Triggering external stage for loading
 Transforming Data During a Load
Sharing Data in Snowflake
 Introduction to Data Sharing
 Data Providers
 Getting Started with Data Sharing
 Working with Shares
 Using Secure Objects to Control Data Access
 Managing Reader Accounts
 Configuring a Reader Account
 Data Consumers

Day 5
Managing Your Snowflake Account
 System Usage & Billing
 Working with Resource Monitors
 Parameter Management
 User Management
Security in Snowflake
 Summary of Security Features
 Multi-Factor Authentication (MFA)
 Federated Authentication & SSO
 Data Encryption
Connecting from other applications
 Connecting and executing queries from Python
 Using Snowflake as a source in Tableau
 Loading data to Snowflake using ETL tool
Additional
 Create User Defined Functions
 Notification Integration
 Migration from Hive
 Stream and Tasks
 External Schedulers