Join us on Facebook

 

Snowflake – Cloud ETL - Live Training

Class Start Date Status Price
Snowflake – Cloud ETL
Red Hot!! Class is FREE for Recent College Graduates
Jan 09 Open $1,500.00

Snowflake – Cloud ETL - Online Training

Class Start Date Status Price
Snowflake – Cloud ETL
Red Hot!! Class is FREE for Recent College Graduates
Jan 09 Open $1,500.00

TO RESERVE YOUR SPOT:

Call: (540) 449-5501
E-mail: vijay@vxltraining.com

$500 payment immediately to reserve your spot and balance after the first day of class.

All of our credit card payments are processed by PayPal and are 100% secure.

You MUST EMAIL US with:

1) Name 2) Phone Number and 3) The Course you have signed up for, after you make your payment.

Please select the Option and Click on the Buy Now Button to pay for your class

Please select the Class and Option and Click on the Buy Now Button to pay for your class

Checkout
Please select a Class First:
Select the Option:
Select method of payment:

Curriculum

Unit 1: Introduction

Introduction to Snowflake
Create Free Snowflake Account
Download Resources for this course

Unit 2:Snowflake Fundamentals

Different Roles in Snowflake
Explore - Databases, Schemas and Tables
Snowflake Architecture
Virtual Warehouses (Compute Engine) - Intro
Virtual Warehouses - Standard vs Economy
Scaling policy
Snowflake Pricing
Micro-Partitioning in Snowflake
Clustering in Snowflake
Query History & Caching
Jump into SQL

Unit 3: Resource Monitors - Track

Compute Consumption
Resource Monitors - Introduction
Properties of Resource Monitor
Actions or Triggers of Resource Monitors
Suspension or Resumption
Detailed Example - How Resource Monitors
Create a Resource Monitor using WebUI
SQL queries to Create Resource Monitor

Unit 4: Load data from AWS (Amazon Web Services)

Create Free AWS Account
what is AWS s3 and how to create buckets under IT
what is IAM (Identity & Access
Management)
Create an IAM Group
Create IAM User
Create AWS IAM Role
Upload data to AWS s3 using web console
Load Data - 1st Step | Create Table Schema
Load Data - 2nd Step | Create Integration object - 1
Load Data - 2nd Step | Create Integration object - 2
Loading CSV Data to snowflake using COPY
command
Load Complete CSV data from S3
Load Parquet data - Part 1
Load Parquet data - Part 2
View Stages and File formats
Load JSON Data from AWS S3
Quiz 4: Test your knowledge on Copying Data
from AWS S3
Snowpipe - Continuous Data
Ingestion Service
Different Types of Tables
Time Travel - Work with history
of Objects

Unit 5: Snowflake Streams – Change Data Capture(CDC)

Introduction to Streams
How Streams work under the hood
Capture & Process INSERT Operations
Capture & Process UPDATE Operations
Capture & Process DELETE Operations
How streams work within a Transaction

Unit 6: Snowflake SQL

snowflake SQL - DDL (Data Definition Language)
DML(INSERT/DELETE/UPDATE) & DQL(Q…Section 19: Snowflake SQL - DML(INSERT/DELETE/UPDATE) & DQL(Query Language - SELECT)
Snowflake SQL - Sub-queries &
Case Statements
Snowflake SQL - Set Operators
(UNION, UNION ALL, INTERSECT, EXCEP…Section 21: Snowflake SQL - Set Operators (UNION, UNION ALL, INTERSECT, EXCEPT, MINUS)
Snowflake SQL - Working with
Row Numbers & Information Schema
Snowflake SQL - Functions &

Unit 7: Snowflake Advanced Topics

Work with Snowflake Python
Tableau and Snowflake
Visualizations - Working with
PowerBI and Snowflake

API - Automation stuff
Visualizations - Working with

CERTIFICATION PRACTICE

TESTS

Class Location

22710 Haggerty Road, Suite 190

Farmington Hills, MI 48335

This class is currently Online Only due to COVID!!

Class Timings

Sat-Sun 9am -12 (noon) EST

Tuesday - Thursday - 7pm-9pm EST

Class will be for 5 weeks

Office Location

22710 Haggerty Road, Suite 190

Farmington Hills, MI 48335

Other Information

Any Questions Please call me at 540-449-5501

or 

Email: vijay@vxltraining.com

This class is free for Recent College Graduates!

 

SAP, R/3, SAP NetWeaver, Duet, PartnerEdge, ByDesign, SAP Business ByDesign are trademarks or registered trademarks of SAP AG.