Snowflake Certification Training

BY
Edureka

Mode

Online

Fees

₹ 13499 14999

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

The fees for the course Snowflake Certification Training is -

HeadAmount in INR
Original priceRs. 14,999
Discounted priceRs. 13,499

  *No Cost EMI starts at Rs. 4,500 / month

certificate availability

Yes

certificate providing authority

Edureka

The syllabus

Introduction of Datawarehouse and Snowflake

  • 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

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

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books