Snowflake offers a cloud-based data storage and analytics service, generally termed “data warehouse-as-a-service”. It allows corporate users to store and analyze data using cloud-based hardware and software.
Unify, integrate, analyze, and share previously siloed data with a near-zero management platform that delivers virtually unlimited scale, concurrency, and performance. Snowflake delivers a single and seamless experience across multiple public clouds and their regions, so customers can execute diverse analytic workloads wherever data lives or wherever users are located.
SnowflakeCourse Content
Table of Contents:
Introduction to Snowflake
- Key Concepts & Architecture
- Cloud Platforms
- Snowflake Editions
- Overview of Key Features
- Overview of the Data Lifecycle
- Continuous Data Protection
Connecting to Snowflake
- Overview of the Ecosystem
- Snowflake Partner Connect
- SnowSQL (CLI Client) – Installation, Configuring and Usage
- Lab – Snowsql Lab & Exercises
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
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
Snowflake Continuous Data Pipelines
- Streams, Tasks & Snowpipe
- Lab – Streams & Tasks Lab & Exercises
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 – Data Sharing Exercises
Managing Your Snowflake Account
- System Usage & Billing
- Understanding Snowflake Credit and Storage Usage
Understanding Snowflake Data Transfer Billing
- Monitoring Credit and Storage Usage
- Resource Monitors
- Parameter Management
- User Management
- Lab – User Management Lab & Exercises
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 – Security and Encryption Exercises
PerformanceTuning
- Query Tuning
- Clustering
- Materialized Views
- Performance Considerations
Duration:1 Monthslong instructor- Online training
Features:
- Lab Exercises
- Real World Scenarios
