infyni

Snowflake Data Warehouse & Analytics Concepts

You will have gained a comprehensive understanding of Snowflake's data warehousing and analytics capabilities, enabling you to efficiently manage, analyze, and derive insights from data in the cloud. Whether you're a data engineer, analyst, or decision-maker. It will boost your potential.

Live Course

Live Class: Monday, 25 Dec

Duration: 25 Hours

Enrolled: 0

Offered by: infyni

Live Course
$1875 60% off

$750

Enroll Now

About Course

Welcome to the Snowflake Data Warehouse & Analytics Concepts course, where you will explore the innovative world of cloud-based data warehousing and analytics with Snowflake. This course is designed for individuals seeking to understand the fundamentals of Snowflake, from its architecture to key analytics concepts, empowering you to efficiently manage and analyze data in the cloud.

Course Objectives:

  1. Introduction to Snowflake:

    • Understand the basics of Snowflake, its cloud-based architecture, and its advantages.
    • Explore the key features that make Snowflake a leading data warehousing solution.

  2. Snowflake Architecture:

    • Dive into the architecture of Snowflake, including virtual warehouses, storage, and metadata.
    • Understand how Snowflake handles data storage and compute resources.

  3. Data Loading and Unloading:

    • Learn how to load data into Snowflake from various sources.
    • Explore techniques for unloading and exporting data from Snowflake.

  4. Data Modeling and Warehousing:

    • Understand how to model data within Snowflake, including schema design and best practices.
    • Explore the concept of virtual warehouses and how they enable scalable and concurrent processing.

  5. Querying and Analytics in Snowflake:

    • Gain proficiency in writing SQL queries in Snowflake.
    • Explore advanced analytics capabilities, including window functions and aggregations.

Skills You Will Gain

Best Practices Advanced Concepts Performance Optimization Data Sharing Collaboration

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 Snowflake Overview & Architecture

  • About Snowflake

    How Snowflake is different

    Different Snowflake Editions, Pricing &

  • Regions

    Snowflake Architecture (3 Layers – Storage, Compute, Services)

  • Creation of Snowflake Trial Account Creating required users/roles/databases for hands On Lab Walkthrough of Snowflake Web UI SnowSQL (CLI) Hands On Lab
  • Warehouses & Types Warehouse Sizing & Scaling Credit Usage Warehouse Monitoring Hands On Lab
  • Storage Micro Partitions Data Storages – Cost & Retention Table Types Storage Monitoring Continuous Data Protection Time Travel Fail Safe Zero Copy Cloning Hands On Lab
  • Data Loading Stages, file format Bulk load using COPY Continuous Load Options – Snowpipe Hands On Lab Data Unloading Unloading data from Snowflake to Internal Snowflake Storage Unloading data from Snowflake to local / Network Drive Unloading data from Snowflake to external cloud storage (AWS S3) Hands On Lab
  • Account Management Managing your snowflake account Warehouse & Storage Credit Usage Account Usage Schema Information Schema Security Role based Access Control Privilege Inheritance Multi Factor Authentication (MFA) Network Policies

...
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

4

Courses