infyni

About Course

Snowflake Data Warehouse & Analytics course covers advanced Data Movement, Performance, Security, Agile Development and Data Sharing design considerations and best practices in the Snowflake Cloud Data Platform. It enables you to build data-intensive applications without operational burden. Trusted by fast growing software companies, Snowflake handles all the infrastructure complexity, so you can focus on innovating your own application.

The data engineer’s role is changing quickly. As new tools and self-service data pipelines eliminate traditional tasks such as manually writing ETL code and cleaning data, companies are asking data engineers to provide guidance on data strategy and pipeline optimization.

Course shall be interactive with lecture, demos, and labs.

Skills You Will Gain

Business Intelligence Data Warehousing Expected Return Sap Hana

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 Module 1 - Snowflake Architecture 1.0

Creating Snowflake Account
Testing Snowflake
Introduction
Understanding the Web UI Components
Installing SnowSql
Using Command Line Interface
In-Dept Snowflake Architecture 2.0

2 Module 2 - Refresher on DDL / DML SQL Command Line Operations

DDL Commands Refresher
DDL Creating VW
DDL Create DB, Schemas
DDL Creating Materialized Views
DDL Alter, Drop Etc.
DML - Select Statements
DML - Operators
DML - Group By, Order By, Having Clause
DML - Joins, Right, Inner & Outer

3 Module 3 - Subqueries, Case Statements

Sub-query with From Clause, Where, Having Clause
Case Statements

4 Module 4 - Snowflake SQL - Set

Operators (UNION, UNION ALL, INTERSECT, Minus)

5 Module 5 - Snowflake SQL - Functions & Transactions

ABS, Ceil, Floor, Coalesce
String, Date, Time
System, Rollback

6 Module 6 - Introduction to DATA Loading in Snowflake

Bulk Loading DATA / Big Data
Data Load - Copy - Bulk Load
Apply transformation while Loading
Loading COMPRESSED file from AWS S3 to Snowflake
Additional Data Load and Transformations

7 Module 7 - Stages in Snowflake

Internal Stages
Types of Internal Stages (User, Table)
External Stages

8 Module 8 - Caching in Snowflake

Results Cache
Local Cache
Disk Cache

9 Module 9 - Micro-Partitioning and Clustering

Creating Cluster Tables
Cluster Tables with expressions
Order By Clause
Manual re-clustering
Best practices in Micro-Partitioning and Clustering

10 Module 10 - Working Virtual Warehouses

Multi-Cluster Virtual Warehouses
Launching New Clusters
Using Dedicated Virtual Warehouses
Scale Out - Auto Scale

11 Module 11 - Performance Tuning

Query Management and Optimization
Concurrency Control

12 Module 12 - Integrating Snowflake with Amazon Web Services (AWS)

Establishing Secure Connection AWS-Snowflake
AWS Roles
Loading data to AWS S3 Buckets
Creating Table, External Stage Objects
File Format Objects
Creating INTERGATION Objects

13 Module 13 - Data Loading from AWS to Snowflake

CSV Data Loading from AWS to Snowflake
Parquet Data Loading from AWS to Snowflake
JSON Data Loading from AWS to Snowflake
Nested Data Loading from AWS to Snowflake
XML Data Loading from AWS to Snowflake

14 Module 14 - Continuous Data Loading

SNOWPIPES
Configure AWS S3 for Snowpipe
AWS Events
SQS Queue

15 Module 15 - Working with Different Snowflake Tables

Permanent Tables
Transient Tables
Temporary Tables

16 Module 16 - TIME-TRAVEL in Snowflake

Set Data Retention Timings
Query Historical Data
Cloning Historical Objects
Time Travel for Data Recovery

17 Module 17 - FAILSAFE in Snowflake

Detailed Overview
Features by Snowflake

18 Module 18 - Tasks in Snowflake

What is a Tree of Tasks?
Implement a Standalone Task
Stored Procedures using Tasks

19 Module 19 - ZERO-COPY Cloning in Snowflake

Clone Database, Pipes, Streams, Tasks& Stages
Clone Schema & Tables
Cloning Table Storage Metrics
Cloning Using Time Travel
Swap Tables

20 Module 20 - Data Sharing in Snowflake

Secure data Sharing
Sharing with other Snowflake users
Sharing with non-Snowflake Users

21 Module 21 - Security in Snowflake

Snowflake Approach to Access Control & Key Concepts
Role Hierarchy in Snowflake

22 Module 22 - Visualization - Integrating Snowflake with Tableau

Connect Tableau with Snowflake

23 Module 23 - Visualization - Integrating Snowflake with PowerBI

Connect Power BI with Snowflake
Creating Graphs and Chartsl

24 Module 24 - Snowflake best practices

Best practices while doing clone.
Best practice while creating database and tables.
Best practice while using virtual warehouse.
Best practice while using retention period and time travel

Yogesh Agrawal

About Instructor

10+ years of experience in Business Intelligence domain with core experience in design and implementation of Data Warehousing and Data Integration Solutions.

0

Rating

0

Review

217

Students

3

Courses

Snowflake Data Warehouse & Analytics

$0