Name: Snowflake SnowPro Core Certification Preparation - COF-C02
Rating: 4.7 (2259 reviews)

Udemy Business

Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Created byHamid Qureshi

Last updated 11/2023

English

What you'll learn

Prepare for the Snowflake SnowPro Core certification exam
Attempt a mock SnowPro Core practice exam
Build understanding of all of the foundations and functionalities offered by Snowflake
Learn Snowflake basics, it's unique architecture & its differentiation

Course content

12 sections • 106 lectures • 6h 21m total length

Introduction to this Course2:24
Introduction to the instructor1:24
How is this course structured2:27
Snowpro Core Certification2:19
Snowpro Core Domains8:59
Introduction to Snowflake3:10
Snowflake Editions1:44
Signup for a Snowflake Trial6:26
Sign up for a Snowflake Trial. Choose a Snowflake Edition and a Platform provider for your Snowflake Trial.
Signup for a Snowflake Trial
Create a virtual warehouse
First impressions of Snowflake WebUI7:56
Explore the Snowflake Web UI at a high level, understanding various sections of the UI and what does each section does.
Hands-on: Create our first database & table and load with data5:06
Create our first table & load with data
Downloading the resources for this course1:06
First Quiz

Snowflake Architecture is its differentiator1:56
This lecture is an introduction to the section and explains what will be covered in this section.
Traditional Database Architecture3:55
A look at the architectural approaches taken by the traditional database engines
Snowflake Architecture3:28
Overview of the hybrid architecture adopted by Snowflake and how it differs from traditional architectures
Compute Layer aka Virtual warehouse1:51
Snowflake can have multiple compute engines, also known as Virtual Warehouses
Hands-on: Creating a new Virtual Warehouse5:32
Let's create a new virtual warehouse and find out how easy it is to create a new compute engine in Snowflake
Lab: Creating a new Virtual Warehouse
Snowflake Storage - Micro partitions3:34
Cloud Services - the brain of the operations2:33
A glimpse of the critical cloud services layer in Snowflake. Cloud Services layer controls authentication, authorization, metadata, query compilation, amongst other things
Compute Layer - Virtual Warehouses In Depth5:42
Dive deeper into the workings of a virtual warehouse, learn about scaling a virtual warehouse up and down, suspending and resuming a virtual warehouse, and get introduced to the virtual warehouse cache
Query Execution & Caching in Snowflake4:00
Snowflake Pricing2:31
Summary2:19
Quiz: Architecture

Section Introduction1:50
Birds eye view of data loading3:29
The use of Stage during data loading2:45
External Stage2:15
Data Ingestion using named External Stage12:49
Assignment: Loading data using an External Stage
Data Ingestion via named Internal Stages2:10
Hands-on: Data Loading from on-premises via internal stage9:44
Lab: Data Loading from on-premises via internal stage
Table Stage & User Stage2:13
Lab: Data Loading using a Table Stage
Assignment: Load JSON data
External Tables3:18
Unloading Data from Snowflake4:13
Basic Data Transformations0:55
Snowpipe2:52
Quiz: Data Loading

Continuous data protection in Snowflake3:03
How Time Travel works in Snowflake2:59
Time Travel SQL Extensions2:16
Hands-on: Time Travel in Action8:06
Lab: Time Travel in Action
Time Travel UNDROP SQL extension1:05
Hands-on: Undrop using Time Travel3:34
Lab: Undrop using Time Travel
Failsafe Storage3:03
Time Travel & Fail-safe storage costs2:07
Types of tables in Snowflake3:29
Hands-on: Demonstrating Temporary & Transient tables5:27
Lab: Create Temporary and Transient tables
Summary2:16
Quiz: Time Travel & Failsafe

Data Sharing in Snowflake2:41
How Data Sharing works in Snowflake2:30
Snowflake offerings for Data Sharing2:32
Direct Sharing Process3:01
Hands-on: Share a table with another Snowflake Account7:58
Lab: Direct Sharing using SQL
Hands-on: Direct Sharing using the User Interface6:31
Lab: Direct Sharing using User Interface
Hands-On: Share a table with a non-Snowflake customer5:16
Snowflake Marketplace4:46
Hands-on: Explore Snowflake Marketplace9:05
Lab: Explore Snowflake Marketplace
Data Exchange2:56
Quiz: Data Sharing

Introduction to Snowflake Performance Features & Optimizations2:22
Query Execution in Snowflake2:13
Hands-on: Access Query Profile7:07
Lab: Access and Explore Query Profile
Caching in Snowflake2:18
Query Result Cache3:47
Hands-on: Demonstrate Query Result Cache3:47
Assignment: Demonstrate Query Result Cache
Metadata Cache1:26
Hands-on: Demonstrate Metadata Cache2:54
Lab: Demonstrate Metadata Cache
Virtual Warehouse Cache1:21
Hands-on: Demonstrate Virtual Warehouse Cache5:27
Lab: Virtual warehouse cache reuse
Partition Pruning & Clustering Keys5:09
Clustering Depth3:36
Scaling up and down a virtual warehouse2:55
Multi-cluster virtual warehouse / Scaling out3:51
Scaling Policies3:46
Materialized Views2:51
Search Optimization Service2:01
Summary5:34
Quiz: Snowflake Performance Features & Optimizations

Security in Snowflake3:05
This lecture discusses several Snowflake capabilities that provide security at various levels.
Data Encryption at Rest1:39
This lecture discusses how all client data in Snowflake is encrypted at rest.
Multifactor Authentication or MFA3:45
This lecture elaborates on Snowflake's support for multi-factor authentication, which adds an extra layer of protection when users log in
Other Authentication Aspects1:49
Authentication control in Snowflake is not limited to MFA. This lecture talks about key-pair authentication, SSO / federated authentication, and password policies
Access Control in Snowflake (DAC & RBAC)4:10
Snowflake's access control is built on role-based access control (RBAC) and discretionary access control (DAC). This lecture explains both.
Other Authorization Aspects5:02
Out of the Box Roles in Snowflake2:34
This lecture talks about the system roles that come out of the box with every Snowflake instance
Network Security3:32
This lecture discusses how administrators can use network policies to enable or prevent access to specific IP addresses.
Summary5:08
Let's go through the summary of what we have learned so far about security in Snowflake
Quiz : Security in Snowflake

Requirements

Some familiarity with database concepts

Description

This course will help you prepare for the Snowflake SnowPro Core certification exam COF-C02, which is a foundational exam in the SnowPro certification exam series. Being a foundational certification exam, this exam covers all the basics including Snowflake architecture, virtual warehouses, storage, security, Time Travel, cloning, data sharing, and data loading. So even if you are not aiming to sit in the exam, preparing for the certification is a great way to get familiarized and become an expert at Snowflake. Please note that this course assists in preparing for the exam but does not guarantee exam success.

This course is organized into several sections. Each section focuses on a particular area related to the exam. As we progress through this course, we will first go through a very important section covering Snowflake’s architecture. Once we have understood the architectural and foundational basis of Snowflake, we will explore user interfaces & connectivity options to understand how we can connect to our Snowflake instance and which tools we can use. Continuing in a logical manner, we will then have a series of sections covering data loading into Snowflake, processing of semi-structured and unstructured data, and the data pipelines in Snowflake. Then we will cover some features unique to Snowflake such as Failsafe, Time Travel, Zero copy cloning, and data sharing. We then look into performance optimization techniques and management of account costs through resource monitors before embarking on our second last section on Security.

Towards the end of each section, we have lectures that summarize the learnings of the section and, finally, a quiz to test and reinforce your knowledge.

The final section that you wouldn’t want to miss are two Practice Exams which will test your knowledge of the concepts learned in this course. The practice exams included in this course are not a guarantee of exam success, but they will give you an assessment of your preparedness.

Snowflake offers a variety of certifications. SnowPro Core certification is at the foundation level and is a prerequisite for other advanced certifications such as data engineering, administration, and data science certification. Because the SnowPro Core certification is a prerequisite for advanced certifications, it’s the perfect way to start your Snowflake adventure.

Who this course is for:

Anyone aiming to undertake SnowPro Core Certification exam
Anyone new to Snowflake can learn the fundamentals and get on track for future certification
Data Engineers & Administrators moving from other technologies and aiming to apply their skills to Snowflake based data warehouses
Solution Architects & Designers aiming to understand Snowflake so that can design and architect appropriately

What you'll learn

Explore related topics

Course content

Introduction & Overview11 lectures • 43min

Snowflake Architecture11 lectures • 37min

Web UI, Tools & Drivers6 lectures • 27min

Data Loading in Snowflake12 lectures • 49min

Continuous Data Protection11 lectures • 37min

Cloning in Snowflake7 lectures • 26min

Data Sharing in Snowflake10 lectures • 47min

Snowflake Performance Features & Optimization18 lectures • 1hr 2min

Security in Snowflake9 lectures • 31min

Extending Snowflake Functionality5 lectures • 11min

Requirements

Description

Who this course is for: