Master Snowflake with Hands On (Sep 2023)

Name: Master Snowflake with Hands On (Sep 2023)
Rating: 3.9 (4 reviews)

Unfolding Snowflake: Unlocking the Art of Cloud Data Warehousing

Created byProton Expert Systems & Solutions

Last updated 9/2023

English

What you'll learn

Utilize Snowflake's scalable architecture to efficiently manage and analyse large volumes of data.
Perform advanced data loading techniques, including batch loading and real-time streaming.
Execute complex SQL queries to extract meaningful insights from diverse datasets
Maximize Snowflake's performance by optimizing query execution and resource allocation
Implement robust security measures to protect data and ensure compliance with industry standards
Implement data governance practices, including access controls, permissions, and data lineage
Implement best practices for data governance and compliance in Snowflake
Leverage the power of stored procedures and user define functions
Execute Streams on top of table to leverage change data capture feature and tasks to ingest changes
Utilize Snowflake's time travel and data versioning features for historical data analysis and auditing

Course content

7 sections • 18 lectures • 2h 19m total length

Overview5:50
In this lesson, you will have information about Detailed Course Objectives, the Course Description based on the Objectives, the Course Target Audience, the Prerequisites for taking up this course, the detailed Course Schedule, and the Practice Environment used in the course to do the activities.

Lesson 1 : Introduction to snowflake and its architecture13:48
In this Lesson, you will learn to create a Snowflake account, and understand its interface and Components. You will also learn create Virtual Warehouse and perform scaling.
Practice 1-1: Creating a Snowflake account, knowing the interface and components5:15
In this practice, you will learn to create a Snowflake account, understand its interface and Components.
Practice 1-2: Creating and Using Virtual Warehouses, altering the warehouse and8:06
In this practice, you will learn to create a Virtual Warehouse and perform scaling on it.

Lesson 2: Introduction to Snowflake Database Objects11:10
In this lesson, you will learn to create a Snowflake objects like database, schema, table, views, file format, stages, stored procedure, UDFs. You will also learn to insert data into Snowflake tables.
Practice 2.1 - Creating database, schema, and table from UI and using command9:48
In this practice, you will learn to create Snowflake objects like databases, schema, and tables using UI and SQL commands. You will also learn to create file format and stage.
Practice 2.2 - Insert data into table, perform SQL queries with joins8:38
In this practice, you will learn to load data into a Snowflake table. You will also learn to query tables from multiple tables using join.
Practice 2.3 - Creating views, stages and file formats. Creating simple UDF and4:35
In this practice, you will learn to create Snowflake Database Objects like view, UDF, and Stored Procedure.

Lesson 3 Query Development, Data Types, Data Loading & Unloading10:43
In this lesson, you will learn to load data into Snowflake tables using the external stage and Snowpipe. You will also learn about data unloading.
Practice 3.1 - Data Loading using External stage (bulk loading) and Snowpipe (co17:11
In this practice, you will learn to load data into Snowflake tables using external stage (Bulk Loading) and Snowpipe (Continuous Loading).
Practice 3.2 – Data Unloading1:56
In this practice, you will learn to unload data from Snowflake tables to Snowflake stages.

Lesson 5 Snowflake Security & Governance11:38
In this lesson, you will learn to enable multifactor authentication, apply data masking to table data, and explore columns of ACCESS_HISTORY view.
Practice 5.1 - Enable multifactor authentication, apply data masking to table da5:39
In this practice, you will learn to enable multifactor authentication, apply data masking to table data, and explore columns of ACCESS_HISTORY view.

Lesson 6 : Snowflake Account Costs4:26
In this Lesson, you will learn to check the cost incurred and calculate charges based on credit consumed. You will also learn to trigger alerts based on credit quota and resource monitor.
Practice 6.1 - Check the cost incurred and calculate charges based on credit con2:41
In this practice, you will learn to check the cost incurred and calculate charges based on credit consumed.
Practice 6.2 - Trigger alerts based on credit quota and resource monitor.3:25
In this practice, you will learn to trigger alerts based on credit quota and resource monitor.

Requirements

Basic Knowledge of SQL and databases
Understanding of Data Warehousing
Familiarity with Cloud Computing

Description

Explore the power of Snowflake, the cutting-edge cloud data warehousing platform that changes the way you manage and analyze your data. With its unparalleled scalability, lightning-fast performance, and secure architecture, Snowflake empowers businesses to unlock valuable insights and make data-driven decisions like never before. Join our Snowflake course today and embark on a transformative journey to harness the full potential of this game-changing technology.

Discover the immense power and versatility of Snowflake, the cutting-edge cloud data warehousing platform, through our comprehensive and immersive course. Designed for data professionals and enthusiasts alike, this course takes you on a deep dive into Snowflake's features and functionalities.

In this course, you will gain hands-on experience in harnessing Snowflake's unparalleled scalability, allowing you to seamlessly handle massive volumes of data with ease.

By the end of this course, you will be equipped with the skills and knowledge needed to become a proficient Snowflake user, capable of leveraging its power to drive data-driven innovation within your organization.

The course teaches you everything you need to know about Snowflake.

This course gives details about Mastering Snowflakes with an emphasis on its activity lessons and hands on experience.

What are you waiting for?

Every day is a missed opportunity.

Enroll No!

Hurry up!

Who this course is for:

Data Analysts
Data Engineers
Database Administrators
Business Intelligence Professionals

Master Snowflake with Hands On (Sep 2023)

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 6min

Lesson 13 lectures • 27min

Lesson 24 lectures • 34min

Lesson 33 lectures • 30min

Lesson 42 lectures • 15min

Lesson 52 lectures • 17min

Lesson 63 lectures • 11min

Requirements

Description

Who this course is for: