Module 1 : Introduction to Cloud Data Warehousing

• Cloud Data warehouses introduction
• Advantages of Cloud data warehousing.
• Describe about various popular cloud data warehouses
  • Redshift (AWS)
  • Snowflake
  • Azure synapse (Microsoft)
  • Big Query (Google)

Module 2 : Snowflake General

• • Introduction
  • Pricing
  • Supported Regions
  • Snowflake Editions
    • Standard Edition
    • Enterprise Edition
    • Business Critical Edition
    • Virtual Private Snowflake (VPS)
  • Supported Cloud Platforms
    • Amazon Web Services (AWS)
    • Google Cloud Platform (GCP)
    • Microsoft Azure (Azure)

Module 3 : Connected to Snowflake

• • • How to create snowflake account
    • Different features in Snowflake.
    • Web interface overview and how to use
    • SnowSql tool introduction and Usage.

Module 4 : Snowflake Architecture

• • • Overview
    • Architecture layers – Storage, Query Processing and Cloud Services

Module 5 : Loading / Unloading Data Into/From Snowflake

• • • Overview of Data Loading
    • Summary of Data Loading Features
    • Data Loading Considerations
    • Preparing to Load Data
    • Bulk Loading Using COPY
    • Loading Continuously Using Snowpipe
    • Loading Using the Web Interface (Limited)
    • Querying Data in Staged Files
    • Querying Metadata for Staged Files
    • Transforming Data During a Load

Module 6 :  Queries — Key concepts and tasks for executing queries in Snowflake

• • • Working with Subqueries
    • Querying Hierarchical Data
    • Working with CTEs (Common Table Expressions)
    • Querying Semi-structured Data
    • Using Window Functions
    • Using Sequences
    • Using Persisted Query Results
    • Estimating Number of Distinct Values
    • Estimating Similarity of Two or More Sets
    • Estimating Frequent Values
    • Estimating Percentile Values
    • Analyzing Queries Using Query Profile
    • Canceling Statements

Module 7 : Semi-structured Data — Key concepts and tasks for working with JSON and other types

• • • Introduction to Semi-structured Data
    • Semi-structured Data Considerations
    • Tutorial: JSON Basics

Module 8 : Virtual warehouses

• • • Overview of Warehouses
    • Multi-cluster Warehouses
    • Warehouse Considerations
    • Working with Warehouses
    • Monitoring Warehouse Load

Module 9 :  Databases, Tables & Views

• • • Understanding Snowflake Table Structures
    • Working with Temporary and Transient Tables
    • Working with External Tables
    • Overview of Views
    • Working with Secure Views
    • Working with Materialized Views
    • Table Design Considerations
    • Cloning Considerations
    • Data Storage Considerations

Module 10:  Timetravel and Fail Safe

• • • Understanding & Using Time Travel
    • Understanding & Viewing Fail-safe
    • Storage Costs for Time Travel and Fail-safe

Module 11 : Sharing Data In Snowflake

• • • Introduction to Secure Data Sharing
    • Overview of the Product Offerings for Secure Data Sharing
    • Granting Data Exchange Administrator Privileges to Other Roles
    • Secure Direct Data Share
    • Data Providers
    • Working with Shares
    • Sharing Data from Multiple Databases
    • Sharing Data Securely Across Regions and Cloud Platforms
    • Using Secure Objects to Control Data Access
    • Managing Reader Accounts
    • Configuring a Reader Account
    • Enabling Sharing from a Business Critical Account to a non-Business Critical Account

Module 12: Managing Your Snowflake Account

• • • System Defined roles
      • ACCONTADMIN
      • SECURITYADMIN
      • SYSADMIN
      • PUBLIC
    • Custom Roles

Module 13 : Data security within Snowflake. Access Control within Snowflake. Use Cases

• • How to extract data from Snowflake to Power BI.
  • How to use ETL tools to pull data from sources to Snowflake.