1. Introduction of Data warehouse
Topics:
● What is a Data Warehouse?
● Limitations of Traditional Data Warehouses
● Evolution of Data Warehouses
● Advantages of Cloud over On-Prem
2. Introduction to Snowflake
Topics:
● Create Snowflake Trial Account
● Snowflake Editions
● Overview of Key Features
3. Getting Started with Snowflake
Topics:
● Snowflake CLI Installation & Configuration
● Different Roles in Snowflake
● Explore – Databases,
● Schemas and Tables
● Snowflake Architecture
● Snowflake Virtual warehouses overview
4. Using Snowflake
Topics:
● Web Interface
● Virtual Warehouses
● Databases, Tables & Views Queries
● Date & Time
● Handling Structured & Semi-structured Data
● Lab & Exercises
Snowflake Course Content
5. Snowflake DDL commands
Topics:
● Create Database and Table
● Insert and Select Statement
● Deleting data Updating the data
● Altering tables
6. Caching in Snowflake
Topics:
● Introduction
● Types of Cache in Snowflake
● Caching Demo with examples
● Lab Exercises
7. Micro-Partitioning in Snowflake
Topics:
● Micro partitions in Snowflake
● Advantages of Micro-Partitioning
● Structure of Micro-Partition
● Query Processing in Snowflake
● Lab – Exercises
8. Clustering in Snowflake
Topics:
● Clustering Introduction
● How clustering works & its advantages
● How to choose the right keys for clustering Performance tuning
● Lab – Exercises
9. Amazon S3
Topics:
● Create an Amazon Trail account
● S3 Overview
● Create AWS S3 bucket
● Create AWS policy & Role
● Create AWS Snowflake Integration
● Loading data into S3 bucket using AWS CLI
● Lab – Exercises
10. Table types in Snowflake
Topics:
● Permanent table and fail-safe Transient table
● Temporary table
● Transient database in snowflake
11. Loading / Unloading Data into/from Snowflake
Topics:
● Overview of Data Loading/Unloading
● Data Loading/Unloading Considerations
● Preparing to Load/Unload Data
● Bulk Loading/Unloading from a Local File System
● Bulk Loading/Unloading from Amazon S3
● Bulk Loading /Unloading from Microsoft Azure
● 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
● Troubleshooting Bulk Data Loads
● Lab – Data Loading / Unloading Lab & Exercises
12. Copy Data into Snowflake
Topics:
● Introduction
● Validating data before loading it into a table
● Collecting rejected records
● Force Copy & Purge options
● Lab – Preparing and Loading data into Snowflake Lab – Exercises
13. Fail safe & Time Travel
Topics:
● Time Travel
● An access fail safe from the web console
● Relation between fail-safe and retention period’
14. Snowflake Continuous Data Pipelines
Topics:
● Snowflake Continuous stream data integrations Streams
● Tasks & Snow pipe
● Lab – Streams & Tasks Lab & Exercises
15. Sharing Data in Snowflake
Topics:
● Introduction to Data Sharing Data Providers
● Data Consumers Working with Shares
● Using Secure Objects to Control Data Access
16. Snowflake Task Feature
Topics:
● Tasks Intro Demo
● Snowflake task Dependency
● Dependency demo
17. Understanding Snowflake Data Transfer Billing
Topics:
● Monitoring Credit and Storage
● Usage Resource Monitors
● User Management
18. Snowflake Stored procedure
Topics:
● Intro Javascript-based stored procedure
● Branching and Looping
● Error handling
19. Snowflake User-Defined Functions
Topics:
● Snowflake SQL based UDF
● SF Javascript UDF’s
● Table functions
● Error handling
20. Features:
Topics:
● Lab Exercises
● Real-World Scenario
Additional Content: IICS – Bonus (Self-Paced)
Topics Covered:
● Informatica Intelligent Cloud Services (IICS) – Introduction
● IICS Trail account set-up
● Installing IICS Secure Agent
● IICS – Snowflake Connection setup
● Mapping transformation
● Joiner transformation
● Expression transformation
● Hierarchical Schema in IICS
● Hierarchy Parser
● Using Query in a Mapping
● Normalizer, Aggregator, and Rank Transformations in a Mapping
● Mapping using Unconnected Lookup Transformation
● Mapplet Transformation in a Mapping
● Mapping Parameters Lab 6-1: Performing Complete Parameterization
● Using Parameter File in a Mapping Task
● Using In-Out Parameters for Incremental Data Loading
Additional Course features:
● SnowPro certification clearance assistance
● Interview Preparation
● Resume Preparation
● Career Guidance.
● 2 live projects