Snowflake Snowpro Advanced: Architect

Overview: Snowflake Advanced Architect

2.85 (17 reviews)
Udemy
platform
English
language
Other
category
Snowflake Snowpro Advanced: Architect
102
students
2 hours
content
Jan 2024
last update
$39.99
regular price

What you will learn

Advance Concept Of Snowflake

Description

Learning Snowflake and its advance features step by step

Snowflake Inc. is a cloud computing-based data warehousing company based in Bozeman, Montana. It was founded in July 2012 and was publicly launched in October 2014. Snowflake was natively designed for Cloud, where thousands of organizations have seamless access to explore, share, and unlock the true value of their data. Snowflake has the best UX out of all the cloud-hosted options, with a fast and responsive UI console and great JSON handling. This makes it easy to get started and transition to structured tables later, or just stick with JSON for flexibility.


As mentioned above Snowflake is built specifically for the cloud, and it’s designed to address many of the problems found in older hardware-based data warehouses, such as limited scalability, data transformation issues, and delays or failures due to high query volumes.


Snowflake is a public facing multi-tenant SaaS service. It provides a Cloud Data Platform that spans AWS, Azure, and GCP. It helps customers move the following six workloads to the Cloud: Data Engineering, Data Warehouse, Data Lake, Data Applications, Data Exchange, and Data Science. The benefit of Snowflake is that it can do this with a single managed platform rather than many different products.


This course is designed for those who are interested in learning the advance features of Snowflake along with preparing for Snowpro Advance certification . Here is the agenda based on the Snowpro advance certification exam


  • Introduction Of Snowflake

  • Free Account creation

  • Snowflake Architecture

  • Introducing Web Interface

  • Account And Security In Snowflake

  • Best practices for using warehouse in Snowflake

  • Connectors And Drivers In Snowflakle

  • Data Loading And Unloading

  • Continuous Data Loads Using Snowflake

  • Working With Streams And Task

  • Data Sharing In Snowflake

  • Performance Tuning In Snowflake

  • Clustering In Snowflake

  • Materialized Views In Snowflake

  • Query Profiles In Snowflake

  • Account_Usage Views In Snowflake

  • Time Travel In Snowflake

  • Cloning In Snowflake

  • Data Replication And Failover In Snowflake

  • Semi Structured Data In Snowflake

  • Python And Snowflake

Content

Introduction

Introduction
Snowflake Free Account
Snowflake Architecture

Web Interface And Basic Understanding

Introducing Web Interface
Basic SQL Commands

Account And Security

Account And Security In Snowflake
Best practices for using warehouses in Snowflake

Connector And Drivers

Connector And Drivers In Snowflake

Data Movement

Data - Loading And Unloading
Continuous Data Loads Using Snowpipe
Working with Streams and Tasks
Stream And Task Demo

Data Sharing

Data Sharing In Snowflake

Performance Tuning

Performance Tuning In Snowflake
Clustering
Materialized Views
Query Profiles
ACCOUNT_USAGE Views

Storage And Protection

Time Travel In Snowflake
Cloning In Snowflake
Data Replication and Failover
Semi Structured Data

Python And Snowflake

Jupyter Notebook & Python
Basic Of Python
Snowflake With Python

Reviews

Rishabh
December 24, 2021
The course is just basics of snowflake. No i depth discussions here. Unnecessarily long pauses are added to increase the length of session. I am going to ask for a refund. The content is good for basics and pro perspective.

Charts

Price

Snowflake Snowpro Advanced: Architect - Price chart

Rating

Snowflake Snowpro Advanced: Architect - Ratings chart

Enrollment distribution

Snowflake Snowpro Advanced: Architect - Distribution chart
4174508
udemy ID
7/9/2021
course created date
8/17/2021
course indexed date
Bot
course submited by