UrbanPro
true

Snowflake Masterclass

LIVE
10 Hours

Just Pay ₹500 to Register

- OR -

Course offered by Ashish

0 review
  • Introduction to SQL and Advance analytics functions.
  • Introduction to Data warehouse.
  •  Snowflake Masterclass

Section 1 : Introduction
What is a data warehouse?
Why cloud computing?
The Snowflake History

Section 2 : Getting Started with Snowflake
Signup for Snowflake
Using Snowflake UI
Creating our first Database, Schema & Table
Load Data into our first table
Setting up Required Snowflake tools
Assignment & Quiz

Section 3 : Snowflake Warehouse for Compute
Creating our first Virtual Warehouses
Virtual Warehouses sizes & Scalability
Warehouse - Maximized vs Auto Scale
Multi-Cluster Warehouse Scaling Policy's
Assignment & Quiz

Section 4 : Architecture, Features & Pricing
Key Concepts & Architecture
Supported Cloud Platforms & Regions
Snowflake Editions
Snowflake Releases
Snowflake Pricing
Data Integration
Assignment & Quiz

Section 5 : Loading & Unloading Structured Data
Ingestion / Loading Methods
Steps to Managing Loads
Preparing your data
Staging your data
Loading data from an Internal stage
Loading data from different Internal stages
Loading data from External S3 stages
What is Snowpipe?
Loading data via Snowpipe - high level steps
Unloading of data
Assignment & Quiz

Section 6 : Semi Structured Data
Loading and Unloading JSON data - high level steps
Analytics on JSON data - hands on lab
ORC data handling
Parquet data handling
Assignment & Quiz

Section 7 : Stage data transformations
Querying Data in Staged Files
Querying Metadata for Staged Files
Transforming Data During a Load
Assignment & Quiz

Section 8 : Databases, Tables & Views
Working with Temporary, Transient & Permanent Tables
Working with Externals Tables
Overview of Views
Working with Materialized Views
Table Design Considerations
Assignment & Quiz

Section 9 : Time Travel, Failsafe & Zero Copy Clones
Back to the future with Snowflake
Travel to a specific time or before a query
Assignment : Time Travel to a point in time
Undrop databases, schema & tables
Assignment : Un-drop tables, schemas & databases
Assignment : Test drive the time travel
Failsafe in Snowflake
Lab : View storage used by Fail-safe
Assignment : Understanding storage used by Fail-safe
Zero Copy Clone
Cloning with Time Travel
Assignment & Quiz

Section 10 : Performance Optimization
Performance Optimization in Snowflake
Using Dedicated Virtual Warehouses
Multi-cluster virtual warehouse or Scaling Out
Maximize Cache Usage
Lab : Query Caching in Action
Clustering large tables & improve partition elimination
Lab : Cluster keys for large tables
Search Optimization
Assignment & Quiz

Section 11 : Secure Data Sharing
Secure Data Sharing in Snowflake
Sharing with other Snowflake users
Assignment : Share a table with another Snowflake user
Sharing - Who's compute is used?
Sharing - Data always up-to date
What is a share?
Sharing with non Snowflake users
Lab : Sharing with non Snowflake users
Assignment : Share a table with non Snowflake user
Lab : Sharing entire schemas & databases
Lab : Sharing views
Assignment : Share a view, combining data from multiple tables
Assignment & Quiz

Section 12 : Snowflake Access Management
Snowflake Approach to Access Control & Key Concepts
Role Hierarchy in Snowflake
ACCOUNT ADMIN role
Outline of the IAM hands on lectures
SECURITY ADMIN role
SYSADMIN role
Custom roles
PUBLIC roles
Assignment & Quiz

Section 13 : Advanced Features
Change Tracking Using Table Streams
Schedule Using Tasks
UDF
Stored Procedures
Column-level Security
Row-level Security
Working with Resource Monitors

Milestone project

 

Gallery (2)

About the Trainer

Avg Rating

0 Reviews

9 Students

5 Courses

Ashish

B.E(ENTC)

9+ years of experience in ETL and DWH technology.
Worked on various ETL tools such as Informatica Powercenter, DMX ETL tool.
Cloud-based technology: AWS, Informatica Intelligent cloud services.
Big data technology: Hive, Oozie, HDFS file system,scoop

Students also enrolled in these courses

LIVE
2 reviews
40 Hours
10,000 Group Class (max 10)
60,000 1-on-1 Class

Course offered by Vikash K

251 reviews
LIVE
6 reviews
25 Hours
25,000 1-on-1 Class

Course offered by Jitendra Chauhan

34 reviews
LIVE
30 Hours
15,000 1-on-1 Class

Course offered by Big Classes Online It Training Center

0 review
LIVE
10 Hours
20,000 Group Class (max 20)

Course offered by Bindesh K

20 reviews

Tutor has not setup batch timings yet. Book a Demo to talk to the Tutor.

Different batches available for this Course

No Reviews yet!

Reply to 's review

Enter your reply*

1500/1500

Please enter your reply

Your reply should contain a minimum of 10 characters

Your reply has been successfully submitted.

Certified

The Certified badge indicates that the Tutor has received good amount of positive feedback from Students.

Different batches available for this Course

tickYou have successfully registered

Snowflake Masterclass by Ashish

Ashish picture
LIVE

Class
starts in

00

Days

01

Hour

01

Min

01

Sec

Select One

Register Now

Do you want to Register for this Free class?

Yes, Register No, not right now

Tell us a little more about yourself

Snowflake Masterclass by Ashish

Ashish picture
LIVE

Class
starts in

00

Days

01

Hour

01

Min

01

Sec

Please enter Student name

Please enter your email address.

Please enter phone number.

Verify Your Mobile Number

Please verify your Mobile Number to book this free class.

Update

Please enter 10 digit phone number.

Please enter your phone number.

Please Enter a valid Mobile Number

This number is already in use.

Resend

Please enter OTP.

Or, give a missed call and get your number verified

080-66-0844-42

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more