infyni

Snowflake Data Warehouse II

This is a live, online class taken by an industry expert. You will have the focused attention of the trainer because group sizes are deliberately kept small. Doubts are cleared on the spot, assignments are discussed and any challenges are addressed.

Live Course

Live Class: Monday, 04 Mar

Duration: 25 Hours

Enrolled: 0

Offered by: infyni

Live Course

About Course

Previously, big data stores were built by organizations in-house. Data engineers used open-source software, like Apache Hadoop to do this. But you needed a team of data engineers to develop and support this kind of a system. Plus, these specialists are in high demand and low supply.

Snowflake provides an enterprise solution that makes the gathering, processing, using big data easy. Its most remarkable feature is the ability to bring up an unlimited number of virtual warehouses. This makes it possible to run an infinite number of independent workloads against the same data without any risk of contention.

6 reasons you need to learn Snowflake :

1. Snowflake puts data warehousing onto the cloud, without locking customers into any vendor. Therefore, Snowflake is seen as a neutral vendor.

2. Snowflake separates compute and storage requirements, so you can scale them up or down independently. This allows greater flexibility.

3. Snowflake is a better platform to start and grow with because it is an overall easier software to approach.

4. It a relational database management system (RDBMS), which uses an SQL database engine designed for the cloud. And doesn’t work on top of an existing database.

5. Snowflake’s architecture enables data sharing among Snowflake users. This allows the provider to create and manage a Snowflake account for a consumer, say users.

6. You could experience concurrency issues (such as delays or failures) when too many queries compete for resources, in a traditional data warehouse. Snowflake on the other hand addresses concurrency issues with its unique multi-cluster architecture.

Skills You Will Gain

Snowflake Architecture DATA Loading Virtual Warehouses Performance Tuning Snowflake Tables Time Travel Hands on JSON Snow CLI Streams and Tasks

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)
  • Know your instructor

  •  
  • Snowflake Introduction

  • Snowflake edition
  • Snowflake signup for free trail
  • Snowflake WebUI Walkthrough
  • Snowflake Architecture
  • Virtual Warehouse
  • Scalability
  • Snowflake pricing
  • Snowflake roles
  • Caching
  • Database, Schema
  • Table, View
  • Hands On - DW Objects
  • Loading methods
  • Understand Stages
  • Hands on - create stage
  • Copy Command and options
  • Transform data
  • File format
  • Hands on - COPY, File Format
  • Snowpipe
  • Snow CLI
  • Hands On - Snow CLI
  • Understanding Unstructured data and its types
  • High level steps
  • Parsing
  • Hands on - JSON, Parquet Data
  • Performance in snowflake
  • Options for optimization
  • Hand On - Optimization options
  • Clustering
  • Hands On - Clustering
  • Time Travel
  • Fail-Safe
  • Zero copy clone
  • Hands On - Time Travel, zero clone copy
  • Streams and Tasks
  • Hands On - Streams and Tasks
  • Materialized View
  • Hands On - MV
  • User Defined Functions
  • Stored Procedure
  • Hands on -SP, UDF
  • Data Masking (Scenarios)
  • Secure data sharing in snowflake
  • Data Replication
  • High level steps
  • Hands On – Secure Data Share
  • Study Material and Lab dumps
  • Practice Assignments and quiz
  • Industry Best practices
  • Certification guidance

Snowflake Data Warehouse II students also learn