Author:  Raghava

Duration: 40 days

 

Snowflake Course Content

Table of Contents:

 

1. Introduction to Cloud
2. Data Warehousing Concepts
3. Introduction to Snowflake
4. Connecting to Snowflake
5. Loading / Unloading Data into/from Snowflake
6. Using Snowflake
7. Snowflake Continuous Data Pipelines
8. Sharing Data in Snowflake
9. Managing Your Snowflake Account
10. Understanding Snowflake Data Transfer Billing
11. Managing Security in Snowflake
12. Performance Tuning
13. Real Time Scenarios, Real Time Interview Questions & FAQs

 

1. Introduction to Cloud

• What is Cloud
• Different Cloud Vendors
• Advantages of Cloud over On-Premise

 

2. Data Warehousing Concepts

• What is a Data Warehouse
• Data Base Vs Data Warehouse
• Data Ware House Architecture
• Why do we need Data Warehouse
• OLTP Vs OLAP
• What is ETL

 

3. Introduction to Snowflake

• Key Concepts & Architecture
• Cloud Platforms
• Snowflake Editions
• Overview of Key Features
• Overview of the Data Lifecycle
• Continuous Data Protection

 

4. Connecting to Snowflake

• Overview of the Ecosystem
• Snowflake Partner Connect
• SnowSQL (CLI Client) - Installation, Configuring and Usage
• Lab – Snowsql Lab & Exercises

 

 

 

 

 

 

 

 

 

5. Loading / Unloading Data into/from Snowflake

• 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

 

6. Using Snowflake

• Web Interface
• Virtual Warehouses
• Databases, Tables & Views
• Queries
• Date & Time Data
• Semi-structured Data
• Binary Data
• Snowflake Time Travel & Fail-safe
• Lab & Exercises

 

7. Snowflake Continuous Data Pipelines

• Streams, Tasks & Snowpipe
• Lab – Streams & Tasks Lab & Exercises

 

8. Sharing Data in Snowflake

• Introduction to Data Sharing
• Data Providers
• Data Consumers
• Working with Shares
• Using Secure Objects to Control Data Access
• Configuring a Reader Account
• Managing Reader Accounts
• Lab – Streams & Tasks Lab & Exercises

 

9. Managing Your Snowflake Account

• System Usage & Billing
• Understanding Snowflake Credit and Storage Usage

 

10. Understanding Snowflake Data Transfer Billing

• Monitoring Credit and Storage Usage
• Resource Monitors
• Parameter Management
• User Management
• Lab – Streams & Tasks Lab & Exercises

 

 

 

 

 

 

 

11. Managing Security in Snowflake

• Summary of Security Features
• Network Policies
• AWS Private Link & Snowflake
• Multi-Factor Authentication (MFA)
• Federated Authentication & SSO
• Access Control in Snowflake (DAC & RBAC)
• Data Encryption
• Lab – Streams & Tasks Lab & Exercises

 

12. Performance Tuning

• Query Tuning
• Clustering
• Materialized Views
• Performance Considerations

13. Real Time Scenarios, Real Time Interview Questions & FAQs