Home

All courses

Snowflake Certification: SnowPro Core COF-C02 Exam Prep

Snowflake SnowPro Core Certification

IT & Software

IT Certifications

Snowflake Certification: SnowPro Core COF-C02 Exam Prep

Full Practice Exam | Master the SnowPro Core COF-C02 Exam & Get Snowflake Certified!

4.7

(3882)

23120 enrolled on this course

Last updated 11/2021

None

₹ 799.0

₹ 2299.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

Looking to become a Snowflake Certified professional?
This comprehensive course is designed to help you ace the SnowPro Core COF-C02 certification exam and become a certified Snowflake professional.
This course covers everything you need to know to pass the SnowPro Core COF-C02 exam!
Why this is the only course needed to clear the exam?
Always 100% up-to-date
Every single topic is covered in depth
Full practice exam incl. explanations
Many quizzes to test your knowledge
Expert instructor
Fun & Easy to watch with a lot of hands-on
This course will guide you through each topic with clear explanations, hands-on exercises, and real-world examples. You'll also get access to a variety of resources and practice exams to help you prepare for the SnowPro Core COF-C02 exam and become a Snowflake Certified professional.
By the end of this course, you'll have the knowledge and skills needed to confidently take and pass the SnowPro Core COF-C02 exam and become a certified Snowflake professional. Whether you're a data engineer, analyst, or scientist, this certification is a valuable addition to your resume and can open doors to new career opportunities.
Enroll now and get:
Lifetime access including all future updates
Full practice exam with explanations
8+ hours of video lectures
Exam Prep made fun and easy
All slides available for download
Expert level support
30-days-money back guarantee - no questions asked!
Enroll now and start your journey to becoming a SnowPro Core COF-C02 certified professional today!
Not provided by, affiliated with, or sponsored by Snowflake Inc.
Who this course is for:
Anyone that wants to take the SnowPro Core exam and get Snowflake Certified

What you'll learn

The only course you need to PASS the SnowPro Core exam!

Full Practice Exam including explanations!

Always 100% up-to-date!

Get Snowflake Certified with ease

All Slides available for download

Quizzes & Hands-on: Learning by doing

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

1.1-Welcome!

1.2-About the course

1.3-About the exam

1.4-All Slides

1.5-Snowflake Free Trial Signup

1.6-Snowsight Interface

1.7-Sample Database

1.8-Worksheets & Interface

1.9-What is Snowflake?

2-Snowflake Architecture

2.1-Multi cluster shared-disk

2.2-Three distinct layers of Snowflake

2.3-Snowflake fundamental architecture

2.4-Hands-on: First Data Loading

2.5-Snowflake Editions

2.6-Snowflake Editions

2.7-Compute Cost

2.8-Storage & Data Transfer Cost

2.9-Cost in Snowflake

2.10-Storage Monitoring

2.11-Resource Monitors

2.12-Hands-on: Resource Monitors

2.13-Resource Monitors & Storage Monitoring

2.14-Warehouses & Multi-Clustering

2.15-Hands-on: Create a Warehouse

2.16-Warehouses

2.17-Snowflake Objects

2.18-SnowSQL

2.19-SnowSQL

3-Data Loading & Unloading

3.1-Internal Stages

3.2-External Stages

3.3-Hands-on: Stages

3.4-Stages

3.5-COPY INTO (Bulk Loading)

3.6-Hands-on: COPY INTO

3.7-COPY INTO

3.8-File Format

3.9-Hands-on: File Format

3.10-INSERT & UPDATE

3.11-Hands-on: Storage Integration

3.12-Loading data

3.13-Snowpipe

3.14-Snowpipe

3.15-Copy Options

3.16-Hands-on: Copy Options

3.17-VALIDATION_MODE

3.18-VALIDATE

3.19-Copy Options

3.20-Unloading

3.21-Hands-on: Unloading

3.22-Unloading

4-Data Transformation

4.1-Transformations & Functions

4.2-Estimation functions

4.3-Transformations & Functions

4.4-UDFs

4.5-Stored Procedures

4.6-UDFs & Stored Procedures

4.7-External functions

4.8-Secure UDFs & Procedures

4.9-Sequences

4.10-External functions & Secure UDFs & Sequences

4.11-Semi-structured data

4.12-Hands-on: Load semi-structured data

4.13-Query semi-structured data

4.14-Hands-on: Query semi-structured data

4.15-Flatten hierarchical data

4.16-Insert JSON data

4.17-Semi-structured data

4.18-Unstructured data

4.19-Directory tables

4.20-Unstructured data

4.21-Data Sampling

4.22-Tasks

4.23-Streams

4.24-Hands-on: Tasks & Streams

4.25-Sampling, Tasks & Streams

5-Additional Snowflake Tools & Connectors

5.1-Connectors, Drivers & Partner Connect

5.2-Snowflake Scripting

5.3-Snowpark

5.4-Additional Tools & Connectors

6-Continuous Data Protection

6.1-Time Travel

6.2-Hands-on: Time Travel

6.3-Hands-on: UNDROP

6.4-Retention period

6.5-Hands-on: Retention period

6.6-Time Travel

6.7-Fail Safe

6.8-Hands-on: Storage Cost

6.9-Table Types

6.10-Fail Safe & Table Types

7-Zero-Copy Cloning & Sharing

7.1-Zero-Copy Cloning

7.2-Hands-on: Cloning

7.3-Data Sharing

7.4-Hands-on: Create the share

7.5-Hands-on: Consume the share

7.6-Database replication

7.7-Data Sharing & Cloning

8-Account & Security

8.1-Access Control in Snowflake

8.2-Roles

8.3-Privileges

8.4-Hands-on: Roles & Privileges

8.5-Roles & Privileges

8.6-Multi-factor authentication

8.7-Federated Authentication (SSO)

8.8-Key Pair Authentication

8.9-Authentication

8.10-Column-Level Security

8.11-Hands-on: Column-Level Security

8.12-Row-Level Security

8.13-Hands-on: Row-Level Security

8.14-Column & Row-level security

8.15-Network policies

8.16-Data Encryption

8.17-Network policies & Encryption

8.18-Account Usage & Information Schema

8.19-Release Process

8.20-Important Schemas & Release Process

9-Performance Concepts

9.1-Query Profile & History

9.2-Caching

9.3-Hands-on: Caching

9.4-Caching & Query Profile

9.5-Micro-partitions

9.6-Understanding Clustering Keys

9.7-Defining Clustering Keys

9.8-System functions for clustering information

9.9-Hands-on: Clustering Keys

9.10-Micro-partitions & Clustering

9.11-Search Optimization Service

9.12-Materialized Views

9.13-Hands-on: Materialized views

9.14-Warehouse Considerations

9.15-Search Optimization, Materialized Views & Warehouses

10-Final Exam

10.1-Final Practice Exam

10.2-Claim your badge & share it on LinkedIn

10.3-Bonus

Course Categories

Popular Courses

Snowflake Certification: SnowPro Core COF-C02 Exam Prep

Description

What you'll learn

Requirements

Course Content

You May Like