Home

All courses

Snowflake SnowPro Core Certification Preparation - COF-C02

Snowflake SnowPro Core Certification

IT & Software

IT Certifications

Snowflake SnowPro Core Certification Preparation - COF-C02

Includes practice exam (300 questions), focused quizzes for each section & practical assignments.

4.3

(1964)

11119 enrolled on this course

Last updated 11/2021

None

₹ 2999.0

₹ 4499.0

Buy Now

30-Day Money-Back Guarantee

Lessons

Quizzes

Duration

13 Hours

Skill level

Beginner

Language

English

Certificate

Yes

Full lifetime access

Yes

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

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

Requirements

You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
No previous design experience is needed.
No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures

Expand All Sections

1-Introduction & Overview

1.1-Introduction to this Course

1.2-Introduction to the instructor

1.3-How is this course structured

1.4-Snowpro Core Certification

1.5-Snowpro Core Domains

1.6-Introduction to Snowflake

1.7-Snowflake Editions

1.8-Signup for a Snowflake Trial

1.9-Signup for a Snowflake Trial

1.10-Create a virtual warehouse

1.11-First impressions of Snowflake WebUI

1.12-Hands-on: Create our first database & table and load with data

1.13-Create our first table & load with data

1.14-Downloading the resources for this course

1.15-First Quiz

2-Snowflake Architecture

2.1-Snowflake Architecture is its differentiator

2.2-Traditional Database Architecture

2.3-Snowflake Architecture

2.4-Compute Layer aka Virtual warehouse

2.5-Hands-on: Creating a new Virtual Warehouse

2.6-Lab: Creating a new Virtual Warehouse

2.7-Snowflake Storage - Micro partitions

2.8-Cloud Services - the brain of the operations

2.9-Compute Layer - Virtual Warehouses In Depth

2.10-Query Execution & Caching in Snowflake

2.11-Snowflake Pricing

2.12-Summary

2.13-Quiz: Architecture

3-Web UI, Tools & Drivers

3.1-Snowflake Connectivity – Drivers & Interfaces

3.2-Classic Snowflake Web UI

3.3-Worksheet view Walkthrough

3.4-Hands-on: SnowSQL installation & connection to your Snowflake Instance

3.5-Lab: SnowSQL installation & connection to your Snowflake Instance

3.6-The new Web UI

3.7-Summary

3.8-Quiz: Web UI, Tools & Drivers

4-Data Loading in Snowflake

4.1-Section Introduction

4.2-Birds eye view of data loading

4.3-The use of Stage during data loading

4.4-External Stage

4.5-Data Ingestion using named External Stage

4.6-Assignment: Loading data using an External Stage

4.7-Data Ingestion via named Internal Stages

4.8-Hands-on: Data Loading from on-premises via internal stage

4.9-Lab: Data Loading from on-premises via internal stage

4.10-Table Stage & User Stage

4.11-Lab: Data Loading using a Table Stage

4.12-Assignment: Load JSON data

4.13-External Tables

4.14-Unloading Data from Snowflake

4.15-Basic Data Transformations

4.16-Snowpipe

4.17-Quiz: Data Loading

5-Continuous Data Protection

5.1-Continuous data protection in Snowflake

5.2-How Time Travel works in Snowflake

5.3-Time Travel SQL Extensions

5.4-Hands-on: Time Travel in Action

5.5-Lab: Time Travel in Action

5.6-Time Travel UNDROP SQL extension

5.7-Hands-on: Undrop using Time Travel

5.8-Lab: Undrop using Time Travel

5.9-Failsafe Storage

5.10-Time Travel & Fail-safe storage costs

5.11-Types of tables in Snowflake

5.12-Hands-on: Demonstrating Temporary & Transient tables

5.13-Lab: Create Temporary and Transient tables

5.14-Summary

5.15-Quiz: Time Travel & Failsafe

6-Cloning in Snowflake

6.1-Cloning in Snowflake

6.2-How Cloning works in Snowflake

6.3-Some caveats related to Cloning

6.4-Hands-on: Clone a Table

6.5-Lab: Clone a Table

6.6-Hands-on: Clone a complete schema & a complete database

6.7-Lab: Clone a complete schema & a complete database

6.8-Hands-on: Cloning with Time Travel

6.9-Lab: Cloning with Time Travel

6.10-Summary

6.11-Quiz: Cloning

7-Data Sharing in Snowflake

7.1-Data Sharing in Snowflake

7.2-How Data Sharing works in Snowflake

7.3-Snowflake offerings for Data Sharing

7.4-Direct Sharing Process

7.5-Hands-on: Share a table with another Snowflake Account

7.6-Lab: Direct Sharing using SQL

7.7-Hands-on: Direct Sharing using the User Interface

7.8-Lab: Direct Sharing using User Interface

7.9-Hands-On: Share a table with a non-Snowflake customer

7.10-Snowflake Marketplace

7.11-Hands-on: Explore Snowflake Marketplace

7.12-Lab: Explore Snowflake Marketplace

7.13-Data Exchange

7.14-Quiz: Data Sharing

8-Snowflake Performance Features & Optimization

8.1-Introduction to Snowflake Performance Features & Optimizations

8.2-Query Execution in Snowflake

8.3-Hands-on: Access Query Profile

8.4-Lab: Access and Explore Query Profile

8.5-Caching in Snowflake

8.6-Query Result Cache

8.7-Hands-on: Demonstrate Query Result Cache

8.8-Assignment: Demonstrate Query Result Cache

8.9-Metadata Cache

8.10-Hands-on: Demonstrate Metadata Cache

8.11-Lab: Demonstrate Metadata Cache

8.12-Virtual Warehouse Cache

8.13-Hands-on: Demonstrate Virtual Warehouse Cache

8.14-Lab: Virtual warehouse cache reuse

8.15-Partition Pruning & Clustering Keys

8.16-Clustering Depth

8.17-Scaling up and down a virtual warehouse

8.18-Multi-cluster virtual warehouse / Scaling out

8.19-Scaling Policies

8.20-Materialized Views

8.21-Search Optimization Service

8.22-Summary

8.23-Quiz: Snowflake Performance Features & Optimizations

9-Security in Snowflake

9.1-Security in Snowflake

9.2-Data Encryption at Rest

9.3-Multifactor Authentication or MFA

9.4-Other Authentication Aspects

9.5-Access Control in Snowflake (DAC & RBAC)

9.6-Other Authorization Aspects

9.7-Out of the Box Roles in Snowflake

9.8-Network Security

9.9-Summary

9.10-Quiz : Security in Snowflake

10-Extending Snowflake Functionality

10.1-Extending Snowflake Functionality

10.2-Secure UDFs

10.3-Stored Procedures

10.4-Snowpark

10.5-Snowflake Scripting

10.6-Quiz : Extending Snowflake Functionality

11-Account & Resource Management

11.1-Account & Resource Management in Snowflake

11.2-Resource Monitors

11.3-Usage & Billing Views

11.4-Account Usage Schema

11.5-Information Schema

11.6-Snowflake Release Process

12-Practice Exams & other resoruces

12.1-Mock SnowPro Core Exam 1

12.2-Mock SnowPro Core Exam 2

Course Categories

Popular Courses

Snowflake SnowPro Core Certification Preparation - COF-C02

Description

What you'll learn

Requirements

Course Content

You May Like