Snowflake Online Training

1. Introduction to data warehouses, cloud computing

• • • Analyze the challenges associated with traditional data warehouses.
    • Understand the fundamentals of cloud computing.
    • Understand the history and evolution of cloud data platforms.

    2. Overview of Snowflake

• • • Understand the industry relevance of Snowflake

    • Analyze “why Snowflake ?”

    3.  Snowflake architecture and UI tour

• • • Understand the Snowflake architecture

    • Play around Snowflake user interface (UI) and understand its different components

1. Getting Started with Snowflake

• • • Understand how data platform performance can be improved with the help of partitions in Snowflake

2. Data loading and transformation

• • • Perform data loading and transformation in Snowflake.

3. Loading data from AWS

• • • Load data from S3 bucket in AWS to Snowflake

4. Transforming data in staged files

• • • Data Transformations and loading using internal stages

5. Loading and querying semi-structured data

• • • Working with Semi-Structured and Unstructured Data

6. Databases, tables, and views

• • • Work with different table types in snowflake
    • Create External tables and load the data
    • Performance tuning on External tables using partition and Materialized View

7. Snowflake Performance Concepts

• • • Maintaining cache and using them for query plan generation and optimization
    • Defining optimization scenarios and approaches to achieve Snowflake performance using Caching,Clustering

8. Administering Roles and Users

• • • Understand authorization and data protection in Snowflake

9. Cloning and Query profile analysis

• • • Understand how clustering reduces the partition count and improve the performance
    • Understand the benefits of Cloning
    • Explore swap

1. Managing Security in Snowflake

• • • Understand how to implement the Security in snowflake and protect unauthorized access to the Snowflake Account

2. Snowsql

• • • Access data platform using command line to develop scripts and test them using CLI

3. Snowflake Credit Administration

• • • Understand the resource monitor in Snowflake that monitors warehouse loads, usage, costs and send alerts

    • Understand Snowflake virtual warehouses credits, usage and cost derivation

1. Data Protection

• • • Understand data protection using time travel, failsafe, data encryption

    • Understand the Data sharing to other accounts and to Reader Accounts

2. Serverless

• • • Understand Snowflake stream loading options using Snowpipe

    • Understand how Snowpipe load data from external stages in real-time

3. Scheduling in Snowflake

• • • Setup and schedule workloads using Snowflake tasks

    • Implement change data capture using streams

4. UDF (user-defined functions) and Stored Procedure

• • • Understand the difference between UDF and Procedures
    • Explore Scalar , Tabular UDF, Stored Procedures

5. Data Recovery and Performance Tuning

• • • Understand how the data can be restored in case of Disaster to current Snowflake Account

    • Understand cloud-agnostic approach of Snowflake

    • Understand some of the performance tuning techniques to improve the Query latency

6. Best Practices

• • • Understand the benefit of splitting the huge file into smaller ones and how it saves the WH credit costs.
    • Evaluate the importance of purging the staged files periodically to improve the COPY performance

1. SnowPro Core Certification Prep

• • • Preparing for the SnowPro Core certification exam and Interviews

2. Capstone project

• • • Work on hands-on project that allows learners to apply the skills learnt throughout the program