Advanced Snowflake Course Syllabus
Enrolled
Snowflake Course Outline
The Snowflake platform is a cloud-based data warehousing solution that offers a unique architecture, enabling high performance, scalability, and concurrency. Whether you're a data analyst, database administrator, or IT professional, mastering Snowflake can significantly enhance your career prospects. The Snowflake course syllabus is designed to cover all essential aspects of the platform, ensuring that learners gain a thorough understanding of its functionalities and applications.
Snowflake training covers cloud data warehousing, architecture, and features. It includes data loading, querying, performance optimization, security, and integration with various tools. The course blends theoretical concepts with practical exercises, preparing participants for efficient Snowflake implementation and management.
- Introduction
- Roles
- Snowflake Pricing
- Resource Monitor – Track Compute Consumption
- Micro-Partitioning in Snowflake
- Clustering in Snowflake
- Query History & Caching
- Load Data from AWS – CSV / JASON / PARQUET
- Load Data from Azure
- Snow pipe – Continuous Data Ingestion Service
- Different Type of Tables
- Time Travel – Work with History of Objects & Fail Safe
- Task in Snowflake – Scheduling Service
- Snowflake Stream – Change Data Capture (CDC)
- Zero-Copy Cloning
- Snowflake SQL – DDL
- Snowflake SQL – DML & DQL
- Snowflake SQL – Sub Queries & Case Statement
- Snowflake SQL – SET Operators
- Snowflake SQL – Working with ROW NUMBER
- Snowflake SQL – Functions & Transactions
- Procedures
- Data Masking
- Row level security
- Shares
- ALL TYPE OF VIEW
- User defined function
- External Tables
- Working with power BI
- Migration project – On-Premises to Snowflake
- Mock Interview sessions
Snowflake Differentiating Real-time Content
- Data Warehousing Basics/Recap
- OLTP VS OLAP
- Key Cloud Computing Concepts
- Cloud Introduction
- On-Premises vs IaaS vs PaaS vs Saas
- Snowflake Introduction
- Getting started with snowflake
- Cloud providers that Snowflake supports
- Snowflake editions
- Connecting to Snowflake
- Snowflake Architecture
- Shared Disk & Shared Nothing Architectures
- Deep dive on Layers in snowflake architecture
- Centralized Storage
- Compute
- Cloud Services and Cloud Agnostic Layer
- Building a Snowflake Virtual Warehouse
- Creating a warehouse
- Deep dive on properties of warehouses
- Warehouse Sizes
- Multi-Cluster Warehouses
- Compute Cost optimization
- Scale Up vs Scale-Out
- Multi-warehouse modes
- Maximized
- Auto-Scale
- Scaling policy
- Standard policy
- Economy policy
- Auto Suspend & Auto Resume
- Real challenges in Warehouse perspective
- SNOWFLAKE OBJECTS
- Account Level
- Warehouse
- Database
- Schema level
- Tables
- Views
- Stages
- File Formats
- Sequences
- Pipes
- Stored Procedures
- User Defined Functions
- Tables & Views
- Deep dive into Permanent, Transient, Temporary, and External tables
- Managing external tables and stages
- Views
- Regular, Materialized, secure views
- Storage features
- Time Travel (UNDROP)
- Fail-Safe
- Zero-Copy Cloning (Deep dive on how it actually works)
- Snowflake Administration
- Roles in Snowflake
- ACCESS MANAGEMENT KEY CONCEPTS
- Discretionary Access Control (DAC)
- Role-Based Access Control (RBAC)
- RBAC vs DAC
- Default Roles in Snowflake.
- ROLES ENCAPSULATION
- ROLES COMMANDS
- Network policies in Snowflake
- PRICING - COSTS IN SNOWFLAKE
- Storage Costs
- Compute Costs
- Cloud Services Costs and Data Transfer Costs
- Capacity options (in terms of buying snowflake service)
- On-Demand
- Pre-paid
- Data Organization in Snowflake storage
- SNOWFLAKE MICRO-PARTITIONS
- SNOWFLAKE PRUNING PROCESS
- Clustering
- DATA CLUSTERING
- CLUSTERING DEPTH
- CLUSTER KEYS
- RECLUSTERING
- AWS for Snowflake
- Stages
- External Stages
- Internal stages
- User stage
- Table stage
- Named internal stage
- Storage Integration
- File Formats
- Structured Data
- Semi-structured Data
- Sequences
- Creating sequences
- Difference in the behavior of sequences with respect to RDBMS
- Getting Started with SnowSQL
- Data Loading
- Staging the data
- How to access/load data from cloud storage (AWS S3, Azure Blob and Google cloud storage)
- BULK LOADà
- Deep dive into COPY INTO command with all options and their project usage scenarios
- Real Issues that we encounter in copy into implementation with solution
- Error handling in data loads
- Bulk Data Loading Recommendations
- File Preparation (Sizing, splitting)
- CONTINUOUS LOADà
- Snowpipe
- Snowpipe configuration
- Integrating with cloud storage
- Real issues with snowpipe and how we overcome them
- Error handling and monitoring
- Data unloading from snowflake
- Bring data into snowflake stage and download
- Working with Semi-structured Data
- Cache
- METADATA CACHE
- QUERY RESULT CACHE
- WAREHOUSE CACHE
- Deep dive on all caches
- Optimize Snowflake Query Performance
- Stored Procedures and Functions
- Tasks
- TREE OF TASKS
- TASK HISTORY
- Limitations of tasks
- Transactions in Snowflake
- Nested transactions
- Issues encountered with transactions
- Streams
- Types of Streams
- Practical examples that covers all stream use cases
- Building Data Pipelines in Snowflake
- Incremental/Delta and Historical data load implementation in real world (SCD scenarios)
- Error handling in data pipelines
- Generic stored procedure frame work for Data loads
- Migration to Snowflake
- Advanced SQL Techniques
- Snowflake Connector for python
- Secure Data Sharing
- PRODUCERS
- CONSUMERS
- Full Account
- Reader Account
- INBOUND & OUTBOUND SHARES
- Setting Up Load Monitoring
- Best Practices for Load Monitoring
- Resource Monitors
- Resource Monitors Assignment
- Resource Monitors Parameters
- Snowflake Security
- SNOWFLAKE COMPLIANCE
- COLUMN LEVEL SECURITY
- Dynamic Data Masking
- External Tokenization
- Overview on End to End Snowflake Project implementation
- SNOWFLAKE DATA MARKETPLACE
- Standard Data Listing
- Personalized Data Listing (Premium)
- SNOWFLAKE ECOSYSTEM
- Partner Connect
- Technology partners
- Solution partners
- Partner classification
- Matillion or Informatica Cloud (IICS) for Snowflake
- Snowpark Overview
- Expected features in future/preview features
Hands-On Experience and Real-world Applications
One of the most valuable aspects of the Snowflake course syllabus is the focus on practical, hands-on experience. Learners are typically required to complete projects and assignments that simulate real-world scenarios, enabling them to apply what they've learned in a controlled environment. This practical approach helps to solidify the theoretical concepts covered in the course and ensures that learners are well-prepared for the challenges they will face in the workplace.
Certification and Beyond
Upon completing the Snowflake course content, learners are usually well-prepared to pursue Snowflake certification. Certification not only validates your knowledge and skills but also enhances your employability in the competitive job market. The course often includes reviewing potential exam questions and scenarios, ensuring you are fully equipped to pass the certification exam.
The Snowflake course curriculum is comprehensive and designed to equip you with all the necessary skills to excel in data warehousing and cloud computing. By covering both foundational and advanced topics, the syllabus ensures that learners understand Snowflake's capabilities deeply. Whether you're looking to advance your career or switch to a role that leverages the power of Snowflake, this course is an excellent investment in your future.
Snowflake Course Overview
Key Features
Who All Can Attend This Snowflake Course?
Aspiring data professionals, analysts, and IT enthusiasts seeking proficiency in Snowflake are welcome to join our comprehensive training program. Elevate your skills and career prospects today.Prerequisites To Take Snowflake Training
An individual has to meet certain eligibility criteria to attend the Snowflake course. The prerequisites for Snowflake training are:
Basic understanding of SQL, Database concepts, knowledge of database schema.
- Upskill or reskill your teams
- Immersive Learning Experiences
- Private cohorts available
- Advanced Learner Analytics
- Skills assessment & benchmarking
- Platform integration capabilities
- Dedicated Success Managers
- Upskill or reskill your teams
- Immersive Learning Experiences
- Private cohorts available
- Advanced Learner Analytics
Play Intro Video
Seeking Placement Assistance?
Explore the perks of Snowflake with our comprehensive training. Streamline your architecture effortlessly, speeding up feature delivery—whether it's embedded analytics or generative AI. Extend your applications to thousands via Snowflake Marketplace or private listings. Ease operational tasks with automatic scaling, ensuring responsiveness without compromising margins. Scale seamlessly, avoid over-provisioning, and pay per second. Benefit from Snowflake's managed service for constant availability, automated processes, and security across clouds and regions. Code in any language, utilizing configurable hardware like GPUs. Experience simplicity in deployment, be it LLMs, UIs, or APIs, via an integrated image registry. With exciting features like Hybrid Tables and Native App Framework, discover a world of possibilities in Snowflake training.
We conduct Snowflake training in all the cities across the globe and here are a few listed for your reference:
India, Bangalore, Hyderabad, Pune, Chennai, Mysore, Cochin, Vishakapatnam, Delhi, Mumbai, Gurgaon, Kolkata, Coimbatore, Ahmedabad, Noida, USA, Canada
Skills Focused
OLTP VS OLAP
Cloud Introduction
On-Premises vs IaaS vs PaaS vs Saas
Getting started with snowflake
Cloud providers that Snowflake supports
Snowflake editions
Connecting to Snowflake
Shared Disk & Shared Nothing Architectures
Deep dive on Layers in snowflake architecture
- Centralized Storage
- Compute
- Cloud Services and Cloud Agnostic Layer
Creating a warehouse
Deep dive on properties of warehouses
Warehouse Sizes
Multi-Cluster Warehouses
Compute Cost optimization
Scale Up vs Scale-Out
Multi-warehouse modes
- Maximized
- Auto-Scale
Scaling policy
- Standard policy
- Economy policy
Auto Suspend & Auto Resume
Real challenges in Warehouse perspective
Account Level
- Warehouse
- Database
- Schema level
- Tables
- Views
- Stages
- File Formats
- Sequences
- Pipes
- Stored Procedures
- User Defined Functions
Deep dive into Permanent, Transient, Temporary, and External tables
- Managing external tables and stages
Views
- Regular, Materialized, secure views
Time Travel (UNDROP)
Fail-Safe
Zero-Copy Cloning
Roles in Snowflake
- ACCESS MANAGEMENT KEY CONCEPTS
- Discretionary Access Control (DAC)
- Role-Based Access Control (RBAC)
- RBAC vs DAC
- Default Roles in Snowflake
- ROLES ENCAPSULATION
- ROLES COMMANDS
Network policies in Snowflake
Storage Costs
Compute Costs
Cloud Services Costs and Data Transfer Costs
Capacity options (in terms of buying snowflake service)
- On-Demand
- Pre-paid
SNOWFLAKE MICRO-PARTITIONS
SNOWFLAKE PRUNING PROCESS
Clustering
- DATA CLUSTERING
- CLUSTERING DEPTH
- CLUSTER KEYS
- RECLUSTERING
External Stages
Internal stages
- User stage
- Table stage
- Named internal stage
Structured Data
Semi-structured Data
Creating sequences
Difference in the behavior of sequences with respect to RDBMS
Data Loading
Staging the data
How to access/load data from cloud storage (AWS S3, Azure Blob and Google cloud storage)
BULK LOAD
Real Issues that we encounter in copy into implementation with solution
- Error handling in data loads
- Bulk Data Loading Recommendations
- File Preparation (Sizing, splitting)
CONTINUOUS LOADà
- Snowpipe
- snowpipe configuration
- Integrating with cloud storage
- Real issues with snowpipe and how we overcome them
- Error handling and monitoring
Data unloading from snowflake
Bring data into snowflake stage and download
METADATA CACHE
QUERY RESULT CACHE
WAREHOUSE CACHE
Deep dive on all caches
TREE OF TASKS
TASK HISTORY
Limitations of tasks
Nested transactions
Issues encountered with transactions
Types of Streams
Practical examples that covers all stream use cases
Incremental/Delta and Historical data load implementation in real world (SCD scenarios)
Error handling in data pipelines
Career Path
Certification Process
Connect With Reps
Frequently Asked Questions
