Everything you need to know about the course | Learn From Industry Experts | Online Learning | Live Classes

Snowflake Cloud Data Platform

In this course you will have an expert coach teach you Snowflake, through live interaction after which its difficult to go back to the traditional way of doing data warehousing. All classes will have an additional moderator on standby to assist you with any difficulty.

Live Class: Friday, 21 Oct

Enrolled: 0

Duration: 25 Hours

Offered by: infyni

About Course

What is appealing about Snowflake is that it puts data warehousing in the cloud without locking customers into any cloud vendor. Though Google, Amazon, and Microsoft have their own offerings, Snowflake is seen as a neutral vendor. And it is popular because it's fast, scalable, accessible, secure, and cost-effective.
In this live course you will be taught by our expert Snowflake coach on advanced Data Movement, Performance, Security, and best practices in the Snowflake Cloud Data Platform.
The Snowflake platform can support data analysis at almost any scale. Its patented, cloud-centric approach to data storage means that any amount of data can be stored and analyzed by an unlimited number of people or processes at the same time without resource contention. It enables you to build data-intensive applications without operational burden. Trusted by fast growing software companies, Snowflake handles all the infrastructure complexity.

Here are some of the current job opportunities requiring Snowflake skills :

1. Snowflake Consultant, Resources Valley, with 2-11 yrs experience
2. Snowflake Data Warehouse Application Developer, Accenture, with 4-6 yrs
3. Snowflake Module Lead, Mindtree Limited, with 5-8 yrs
4. Snowflake Technical Lead, Mindtree Limited, with 7-10 yrs
5. Snowflake Data Warehouse Application Developer, Accenture, with 4-6 yrs
6. Snowflake Data Warehouse Software Engineer, Aspire Recruitment Solutions, with 2-7 yrs

Skills You Will Gain

Snowflake Architecture Snow SQL DDL / DML SQL Command Snowflake SQL - Set Snowflake SQL - Functions & Transactions DATA Loading Micro-Partitioning and Clustering Virtual Warehouses Performance Tuning Snowflake Tables Time Travel Integrating Snowflake with Tableau Integrating Snowflake with PowerBI Snowflake Best Practices

Course Offerings

Instructor-led interactive classes
Clarify your doubts during class
Access recordings of the class
Attend on mobile or tablet
Live projects to practice
Case studies to learn from
Lifetime mentorship support
Industry specific curriculum
Certificate of Completion
Employability Opportunity

Topics
Instructor (1)

1 High Level Architecture

Story Behind Snowflake
Snowflake Core Architecture
Cloud Agnostic Layer
Storage Layer
Compute Layer
Cloud Services
Contineous Availability

2 Introduction to web UI

Create Snowflake Trial account
Snowflake Editions
Classic console
Snowsight
Snowflake partner connect
Download resources

3 Virtual Warehouse

Create Virtual Warehouse
Multicluster Virtual Warehouse
Scaling policies
Load Monitoring
Billing

4 Storage Overview

Timetravel and Fail-safe
Permanent table
Transient table
Temporary table
External Table
Snowflake Stage

5 Bulk Data Loading & Unloading

Overview of Data Loading/Unloading
COPY Command
Preparing to Load/Unload Data
Bulk Loading/Unloading from a Local File System
Bulk Loading/Unloading from Amazon S3

6 Continuous Data Loading

Snowflake Streams
Snowpipe
Tasks
Transient database in snowflake
Snowflake Continuous Data Integrations

7 Data Security in Snowflake

Network Security
Authentication and Authorization
Data Encryption
Data Masking

8 Micro Partition and Data Clustering

Micro partitions in Snowflake
Advantages of Micro-Partitioning
Structure of Micro-Partition
Clustering Introduction
How clustering works & It's advantages
how to Choose right keys for clustering

9 Performance Monitoring and Optimization

Caching in Snowflake
Query History
Execution Plan

10 Snowflake Best Practices

Role Based Access Control
Resource Monitors
Virtual Warehouse Sizing
Zero Copy Cloning

11 Additional Module

Upcoming Features - Snowpark, SQL API etc.
Snowflake Certifications
Data Migration to Snowflake

Rahul Jain

About Instructor

As a certified Snowflake professional, I have spent many years working as a Cloud Data Engineer before venturing into the educational field. I focus on practical applications of the platform. This ensures that students can immediately put their newly-learned skills to use, right after completing the course.

0

Rating

0

Reviews

11

Students

1

Courses

Live training in Salesforce CPQ. Starting Sept 9.

Live training in Cybersecurity. Starting Sept 19.