Snowflake: Complete Data Platform Course
Snowflake is a modern data platform built for the cloud, offering a unique architecture and capabilities that differentiate it from traditional data warehouses. This comprehensive course will cover everything from the basics of Snowflake and its architecture to advanced features like data loading, time travel, and data sharing.
Course Modules
- Snowflake Introduction
- History of Snowflake
- Modern Data Architecture & Snowflake
- Value of Cloud Data Platform
- Snowflake Registration
- Understanding Major Cloud Platforms (GCP, Azure, AWS)
- Understanding Pricing Policies
- Walkthrough Of Web Interface
- Snowflake Architecture
- Shared Disk & Share Nothing Architecture
- 3 Layer Service (Storage, Compute, Service Layer)
- Snowflake Capabilities & Unique Features
- Snowflake WebUI in Detail
- Roles in Snowflake
- Complete SQL Worksheet Walkthrough
- Setting Up Warehouse (UI & SQL)
- Creating Database
- Creating Tables, Views, Schemas
- Loading Data into Tables
- Structured Data Loading
- Data Loading Methods
- Creating Stages
- COPY Command
- Validation Mode
- Dealing with Rejected Records
- Size Limit
- Load History
- Steps for Processing Unstructured Data
- Understanding JSON
- Loading JSON File
- Parsing JSON File
- Loading Parsed Data
- Parquet File Format
- Understanding the Difference Between CSV, JSON, Parquet
- Parsing Parquet File
- Loading Parquet File
- Data Loading - AWS
- Account Creation AWS Free Tier
- Creating S3 Bucket
- Creating Trust Policy
- Creating Integration Object
- Data Loading from S3
- Data Loading - Azure
- Sign up for Free Trial
- Create a Storage Account
- Create a Container
- Create Integration Object
- Create Storage Object
- Loading Data from Azure
- Data Loading - GCP
- Create Free GCP Account
- Create Bucket
- Create Integration Object
- Create Stage
- Query & Load Data
- Unload Data
- Snowpipe Introduction
- Create Stage for Snowpipe
- Create Snowpipe
- Configure Pipe & Notifications
- Manage, Alter & Update Pipes
- Using Time Travel
- Restoring Data from Time Travel
- UNDROP Feature
- Retention Time
- Fail Safe
- Types of Tables in Snowflake
- Permanent Tables
- Transient Tables
- Temporary Tables
- Understanding Zero Copy Cloning
- Cloning Tables
- Cloning Stages
- Cloning Databases
- Cloning Schemas
- Swapping Tables
- Introduction to Snowflake Data Sharing
- Data Sharing (Snowflake & Non-Snowflake User)
- Producer & Consumer Account
- Data Sharing (Snowflake User)
- Data Sharing (Non-Snowflake User)
- What is Data Sampling
- Why We Need Data Sampling
- Data Sampling Methods
- BERNOULLI Sampling
- SYSTEM Sampling
- Understanding Task
- Task Scheduling
- Creating Task
- Using CRON
- Understanding Streams
- Streams & ETL Pipelines
- ETL Automation Using Streams
Skills You Will Gain
The students will acquire the following set of skills after completing this Snowflake course:
Cloud Data Platform Proficiency : Understand and utilize Snowflake's cloud-based data platform for efficient data storage and management.
Data Integration : Learn how to integrate data from various sources including AWS, Azure, and GCP into Snowflake.
Advanced Data Loading Techniques : Master different methods for loading structured and unstructured data.
Data Management and Governance : Gain insights into data governance, time travel, and zero-copy cloning for effective data management.
SQL Proficiency : Enhance SQL skills specific to Snowflake's environment.
Data Sharing : Learn how to share data securely and efficiently within Snowflake and with external users.
Career Path
Career paths you could pursue after completing a Snowflake course:
Data Engineer : Design, construct, install, and maintain large-scale processing systems and ensure data is easily accessible.
Data Analyst : Analyze complex datasets to help organizations make informed business decisions using Snowflake.
Database Administrator : Manage and support the database infrastructure, ensuring optimal performance and security.
Cloud Solutions Architect : Design and implement scalable and secure cloud solutions, leveraging Snowflake’s architecture.
This course includes:
- 10 Sessions
- 30 Hours of Hands-on Training
- Multiple Cloud Platforms for Data Integration
- Online Practical Training
- Learn Snowflake Skills
- Practical Tasks, Lectures, and More
- Data Management and Integration Content with Hands-on Training
Get In Touch With Us to start Immediately or learn more
Make a Call
WhatsApp Now
Drop A Mail
Related Courses
- 3-5 Months
- 50 Sessions
- Advanced
- 3-5 Months
- 50 Sessions
- Advanced
- 4 Months
- 40 Sessions
- Advanced