Snowflake - Intermediate Course

Overview

✓ Master more advanced features of Snowflake ✓ Explore Continuous Data Loading with Snowpipe, Continuous Data Protection including Time Travel and Fail Safe ✓ Explore Acess Control and Roles, Snowflake Editions and Pricing, Zero-Copy Cloning Welcome to this intermediate course on Snowflake, where you'll learn how to take your Snowflake skills to the next level with some of the platform's more advanced features and capabilities. In this course, we'll cover Continuous Data Loading with Snowpipe, Continuous Data Protection including Time Travel and Fail Safe, different table types, Zero-Copy Cloning, Access Control, and User Management. This course is highly practical and hands-on, with quizzes and real-world examples to help you apply your knowledge in practical ways. By the end of this course, you'll have a deep understanding of Snowflake's more advanced features and be equipped with the skills you need to work professionally with Snowflake. With Snowflake's Continuous Data Loading, you'll be able to load data into Snowflake in real-time, ensuring that your data is always up-to-date and accessible. Continuous Data Protection, including Time Travel and Fail Safe, provides you with advanced data recovery options, allowing you to recover from data loss or corruption quickly and easily. With our course, you'll also learn how to optimize your data storage and processing with different table types and Zero-Copy Cloning. Access Control and User Management ensure that your data is secure and accessible only to authorized users. By mastering these advanced features, you'll be able to use Snowflake to its fullest potential, enabling you to work more efficiently and effectively with your data. So enroll today and take your Snowflake skills to the next level! Not provided by, affiliated with, or sponsored by Snowflake Inc.

Syllabus

Continuous data loading with Snowpipe

In this module, you will learn how to set up Snowpipe to continuously load data files from Azure.

Continuous Data Protection in Snowflake

Continuous Data Protection includes a comprehensive set of features in Snowflake that are aimed to protect the data against different types of failures.

Zero-Copy Cloning

Zero-Copy Cloning is an advanced feature in Snowflake that makes copying data much easier. When developing, you often want to quickly create a copy of a table or a database. Traditionally, this involves a lot of steps and can be a tedious process. Now in Snowflake, it lets you create copies of tables, or entire databases or schemas, including all the metadata, data, and structure with just one single command.

Roles and User Management in Snowflake

In this module, you will learn the key aspects and concepts of access control in Snowflake. This encapsulates Discretionary Access Control (DAC) and Role-based Access Control.