- What is Datawarehouse
- Limitations of Traditional data warehouses
- Evolution of Data warehouses
- Advantages of Cloud over On-Prem
- Create Snowflake trial account
- Snowflake Editions
- Overview of Key Features
Online
₹ 13,499 14,999
Quick facts
particular | details | |
---|---|---|
Medium of instructions
English
|
Mode of learning
Self study, Virtual Classroom
|
Mode of Delivery
Video and Text Based
|
Course and certificate fees
Fees information
₹ 13,499 ₹14,999
certificate availability
Yes
certificate providing authority
Edureka
The syllabus
Introduction of Datawarehouse and Snowflake
Getting Started with Snowflake
- Snowflake CLI installation & Configuration
- Different Roles in Snowflake
- Explore - Databases, Schemas and Tables
- Snowflake Architecture
- Snowflake Virtual warehouses overview
Using Snowflake
- Web Interface
- Virtual Warehouses
- Databases, Tables & Views
- Queries
- Date & Time Data
- Semi-structured Data
Micro-partitioning and Clustering in Snowflake
- Micro partitions in Snowflake
- Advantages of Micro-Partitioning
- Structure of Micro-Partition
- Query Processing in Snowflake
- Clustering Introduction
- How clustering works & It's advantages
- how to Choose the right keys for clustering
- Performance tuning
Table types in snowflake
- Permanent table and fail-safe
- Transient table
- Temporary table
- Transient database in snowflake
Snowflake Continuous Data Pipelines
- Snowflake Continuous stream data integrations
- Streams, Tasks & Snow pipe
- 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
Snowflake Task Feature
- Tasks Intro
- Demo
- SF task Dependency
- Dependency demo
Understanding Snowflake Billing
- Monitoring Credit and Storage Usage
- Resource Monitors
- User Management
Miscellaneous
- Roles and Privileges
- Data Security in Snowflake
- Snowflake as DaaS
- Snowflake Vs Redshift Vs Bigquery
- Snowflake Certification
- Upcoming features in Snowflake
- Final Project Overview