Snowflake for Beginners

About Snowflake :

• Snowflake is a Cloud-based Data-Warehousing platform that offers advanced solutions for Organizational Data Storage, Processing and Analytical Needs

• Snowflake is the Trending Platform used by thousands of Companies globally

• Snowflake Enables Most Critical Data Workloads in large Corporations

  
  

  Section 1 : Introduction

• Introduction

• What is a data warehouse?

• Why cloud computing?

• The Snowflake Story

  Section 2 : Getting Started with Snowflake

  • Signup for Snowflake

  • Using Snowflake UI

  • Creating our first Database, Schema & Table

  • Load Data into our first table

  • Setting up Required Snowflake tools

  • Assignment : Create, Load & query a table

    Section 3 : Snowflake Warehouse for Compute

    • Creating our first Virtual Warehouses

    • Virtual Warehouses sizes & Scalability

    • Warehouse - Maximized vs Auto Scale

    • Multi-Cluster Warehouse Scaling Policy's

    • Assignment : Creating a new Virtual Warehouse

      Section 4 : Architecture, Features & Pricing

      • Key Concepts & Architecture

      • Supported Cloud Platforms & Regions

      • Snowflake Editions

      • Snowflake Releases

      • Snowflake Pricing

      • Data Integration

      • Quiz : Snowflake Concepts

      • Section 5 : Loading & Unloading Structured Data

        • Ingestion / Loading Methods

        • Steps to Managing Loads

        • Preparing your data

        • Staging your data

        • Loading data from an Internal stage

        • Loading data from different Internal stages

        • Loading data from External S3 stages

        • What is Snowpipe?

        • Loading data via Snowpipe - high level steps

          Section 6 : Semi Structured Data

          • Loading and Unloading JSON data - high level steps

          • Analytics on JSON data - hands on lab

          • ORC data handling

          • Parquet data handling

          • Assignment : Load JSON data from an S3 bucket

          Section 7 : Stage data transformations

          • Querying Data in Staged Files

          • Querying Metadata for Staged Files

          • Transforming Data During a Load

            Section 8 : Databases, Tables & Views

            • Working with Temporary, Transient & Permanent Tables

            • Working with Externals Tables

            • Overview of Views

            • Working with Materialized Views

            • Table Design Considerations