Class | Start Date | Status | Price |
---|---|---|---|
Snowflake – Cloud ETL Red Hot!! Class is FREE for Recent College Graduates |
Jan 09 | Open | $1,500.00 |
Class | Start Date | Status | Price |
---|---|---|---|
Snowflake – Cloud ETL Red Hot!! Class is FREE for Recent College Graduates |
Jan 09 | Open | $1,500.00 |
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
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
22710 Haggerty Road, Suite 190
Farmington Hills, MI 48335
This class is currently Online Only due to COVID!!
Sat-Sun 9am -12 (noon) EST
Tuesday - Thursday - 7pm-9pm EST
Class will be for 5 weeks
22710 Haggerty Road, Suite 190
Farmington Hills, MI 48335
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.