EncartaLabs

SnowFlake

( Duration: 4 Days )

This SnowFlake training course covers the fundamental concepts, design considerations, and best practices intended for key stakeholders who will be working on the SnowFlake Platform.

By attending SnowFlake workshop, attendees will learn to:

  • Illustrate the unique and differentiated architecture of the Snowflake Platform
  • Discuss how Snowflake provides a unique approach to caching
  • Load and transform data
  • Examine the various ways to connect and interact with the Snowflake Platform
  • Evaluate Query Constructs and DDL & DML Operations
  • Employ Snowflakes method for continuous data protection
  • Review Snowflakes broad SQL support for data analysis
  • Utilize Data Sharing to send your data in real-time to Customers and Partners
  • Describe how user and application access can be easily managed
  • Scale your Virtual Warehouse for performance and concurrency
  • Demonstrate best practices for working with semi-structured data
  • Explain the different ways you can manage and monitor your Snowflake account

  • Previous Data Warehouse knowledge is assumed
  • Data Analysts
  • Data Engineers
  • Data Scientists
  • Database Architects
  • Database Administrators

COURSE AGENDA

1

Snowflake Architecture and Overview

  • Snowflake Technical Overview
  • Cloud Services Layer
  • Compute Layer
  • Storage Layer
2

Data Movement

  • Data Loading
  • Unloading
  • Best Practices
3

Snowflake Objects & Commands

  • Query Constructs
  • Data Description Language (DDL)
  • Data Manipulation Language (DML)
4

Snowflake SQL Support for Data Analysis

  • SQL Support and Query Best Practices
  • SQL Analytic Functions
  • High Performing Estimation Functions
  • UDF and Stored Procedure
  • Demo Query Profile
5

Managing Security

  • Data Encryption
  • Authentication
  • Role-Based Access Control
6

Semi-structured Data

  • Capabilities and Best Practices for working with semi-structured data in Snowflake
7

Caching

  • Caching Features in Snowflake
  • Best Practices of using caching for performance and cost optimization
8

Snowflake Clients and Ecosystem

  • Snowflake Clients and Connectors Overview
  • SnowSQL – Snowflake CLI
9

Continuous Data Protection

  • Time Travel in Snowflake
  • Cloning in Snowflake
10

Data Sharing

  • Snowflake Data Sharing Overview
11

Performance & Concurrency

  • Query Profile
  • Micro-Partitions & Data Clustering
  • Scaling a Virtual Warehouse
12

Account and Resource Management and Monitoring

  • System Resource Usage and Billing
  • Managing Virtual Warehouses
  • Workload independence and segmentation
  • Monitoring Tool: Resource Monitors
  • Monitoring Tools: Information Schema and Account Usage

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 4,000 Modules on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top