Snowflake Developer Program

Snowflake Developer Program

About the program

This program is a 32-hour Snowflake developer program, which will help you pick up Snowflake a cloud Data warehouse tool – one of the most in demand modern data warehouse tool. This program is brought to you by Agile Testing Alliance (a global leader in bringing cutting edge upskilling programs for the technology professionals)and in association with QAAgility (A leading BI / Cloud DatawareHouse service organization)

Program duration – 32 Hours

Total Days 16 ( 2 hours per day) – 8 PM IST to 10 PM IST

Starting Date : 19th June 2023

Cost : 32000 + Taxes  (This fee includes a course completion certificate from Agile Testing Alliance)

This course introduces participants to the challenges of traditional Data warehouse and helps understands why there is need of a cloud-based Data Warehouse and to snowflake.

Participants are then introduced to snowflake Architecture and its advanced features like time travel, zero copy clone, data share, scheduling utilities like task along with strong emphasis on performance optimization’s. The course emphasizes on practical implementation.

With the case studies, we will explain in a real-life project scenario, how Snowflake as a modern Data warehouse is implemented at an enterprise level.

Why Snowflake

Data warehouse is the core of any organization, as it is important for regulatory reporting and enables business to take key decisions. 

With the sheer size of data warehouse, it is a challenge to scale up the compute and storage capacity of data warehouse. Data storage and compute resource in most of the Data Warehouse are tightly coupled which is also a disadvantage. Hence, there is need to move our Data Warehouse to such a framework wherein compute and storage capacity are decoupled and can be increased or decreased on demand.

Modern Cloud Data Warehouse solutions like snowflake meets the given requirement and offers great flexibility along with other unique features like Time Travel, Zero copy clone, Data Share and Data Market place

Due to data security concerns, there is slight reluctance in moving the data from on premise to cloud. In Snowflake, data is encrypted in each layers at all times. The concept of customized encryption allows to bring your own keys and encrypt the data which further enhances the data security.

In a nutshell Snowflakes clicks most of boxes for modern Data Warehousing needs and the program clicks all the boxes for someone who wants to move to the most in demand data warehouse tool in today’s world.

 

Pre-requisites 

1. Good understanding of database concepts.
2. Need to have an experience/ exposure in Software Development life cycle.
3. Interest to learn new and most cutting edge technology
If you are already into Data Base and/or Data Warehouse technology, this would immediately help you leap frog into one of the most in-demand areas

Hardware / Software Pre-requisites

Participants should preferably carry their own laptops (BYOD) with at least 4GB RAM and good internet bandwidth. Program would be delivered virtually and would require you to attend regularly.

Course Handouts

Participants will be given course notes and lab exercise handouts

Table of contents / Learning Objectives

Introductions

Introduce participants and understand specific learning objectives, if any, from the participants.
Cloud Data Warehousing

  • Definition: Explain the concept of cloud data warehousing and how it differs from traditional on-premise data warehousing.
  • Features: Cover the benefits of cloud data warehousing, including scalability, flexibility, and cost-effectiveness.

Introduction to Snowflake

  1. Provide an overview of Snowflake and its capabilities. Cover the basics of how Snowflake works, including its cloud-based architecture, available cloud platforms, available regions, types of available Snowflake editions.
    Cloud Platforms
    Cloud Regions
    Editions
    Releases
  2.  Eco System
  3.  Architecture
    Describe the key components of Snowflake and provide an overview of Snowflake’s cloud architecture.
  4. Creation of a trial account. Show how to create a trial account to enable participants to have their own Snowflake trial account to perform the labs.
  5. Tools and utilities
    Introduce SnowSQL, WebUI, SnowSight, and discuss supported drivers.

Snowflake Architecture

Get deeper into Snowflake architecture. Cover the key components of Snowflake’s cloud-based architecture, including its separation of storage and compute, virtual warehouses, and the role of metadata.

  1. Compute Layer: Provide details on what the compute layer is, the types of available virtual warehouses, cost, auto-scaling, multi-cluster warehouses, and resource monitors.
  2. Storage Layer: Provide details on what the storage layer is, the data storage process, scaling, cost, columnar storage, micro-partitioning, metadata, clustering, column, and micro-partition pruning.
  3. Cloud Services Layer: Provide details on what the cloud services layer is, services managed in the cloud services layer, authentication, metadata management, access control, and caching.

Snowflake Objects

  1. Account, Databases, and Schemas
  2. Tables (and Data Types), Views, Materialized Views
  3. Stored Procedures, UDF
  4. Stages, File Formats, Pipes, Streams, Tasks
  5. Other Objects

Data Unloading

Discuss how to unload data from Snowflake into multiple platforms.

Snowflake Features

  1. Time Travel
  2. Fail-Safe
  3. Zero-Copy Cloning
  4. Data Sharing
  5. Data Marketplace
  6. Data Replication

Snowflake SQL.

Discuss the SQL supported by Snowflake and some functions that can make our job easier.

UDF and Stored Procedures: 
Discuss UDF, stored procedures (Snowflake scripting) with exception handling, and transactions.

Streams and Tasks

Discuss change data capture by using streams and scheduling with tasks. Make a continuous data pipeline using Snowpipe, stream, procedure, and task.

Security and Compliance: Discuss Snowflake’s security features, including encryption, access controls, and audit trails. Cover how Snowflake complies with various data security and privacy regulations.

Performance Tuning and the cost

Discussion on choosing right warehouse, Query Profile, Pruning and Result Scan. General guidelines on how to identify a bad performing query, queueing and improve the performance. Discussion on saving the cost.
Data Governance:

  • Object Tagging
  • Data Classification
  • Masking Policies
  • Row Access Policies
  • Access History
  • Object Dependencies

Alerts and Notifications

  • Snowflake Alerts
  • Email Notifications

Business Use Cases

Real-world Use Cases: Provide real-world use cases and examples of how Snowflake has been implemented in various organizations across different industries.

Registration

Meeting Details would be shared in the following Telegram group for getting meeting details

Please register on the Townscript form below.

Telegram group: https://t.me/joinchat/LscMmEhEiUj-3PMSFGgCRA

and a WhatsApp group that would be created based on the registrations

Stay in Touch

Get the latest updates. Subscribe now.

Linkedin-in Twitter Youtube Instagram Facebook-f Whatsapp Telegram-plane

Agile Testing Alliance © 2013 - 2024. All rights reserved.