SnowPro Core Certification Preparation - COF-C02

Focused View

Hamid Qureshi

4:23:04

68 View

1 - Introduction & Overview

1 - Introduction to this Course.mp4

02:24

2 - Introduction to the instructor.mp4

01:24

3 - How is this course structured.mp4

02:27

4 - Snowpro Core Certification.mp4

02:19

5 - Snowpro Core Domains.mp4

05:42

6 - Introduction to Snowflake.mp4

03:10

7 - Snowflake Editions.mp4

01:44

8 - Signup for a Snowflake Trial.mp4

06:26

9 - First impressions of Snowflake WebUI.mp4

07:56

10 - Handson Create our first database & table and load with data.mp4

05:06

11 - Downloading the resources for this course.mp4

01:06

2 - Snowflake Architecture

2 - Quiz Architecture.html

12 - Snowflake Architecture is its differentiator.mp4

01:56

13 - Traditional Database Architecture.mp4

03:55

14 - Snowflake Architecture.mp4

03:28

15 - Compute Layer aka Virtual warehouse.mp4

01:51

16 - Handson Creating a new Virtual Warehouse.mp4

05:32

17 - Snowflake Storage Micro partitions.mp4

03:34

18 - Cloud Services the brain of the operations.mp4

02:33

19 - Compute Layer Virtual Warehouses In Depth.mp4

05:42

20 - Query Execution & Caching in Snowflake.mp4

04:00

21 - Snowflake Pricing.mp4

02:31

22 - Summary.mp4

02:19

3 - Web UI Tools & Drivers

3 - Quiz Web UI Tools & Drivers.html

23 - Snowflake Connectivity Drivers & Interfaces.mp4

03:11

24 - Classic Snowflake Web UI.mp4

07:36

25 - Worksheet view Walkthrough.mp4

02:02

26 - Handson SnowSQL installation & connection to your Snowflake Instance.mp4

05:43

27 - The new Web UI.mp4

07:25

28 - Summary.mp4

01:29

4 - Data Loading in Snowflake

29 - Section Introduction.mp4

01:50

30 - Birds eye view of data loading.mp4

03:29

31 - The use of Stage during data loading.mp4

02:45

32 - External Stage.mp4

02:15

33 - Data Ingestion using named External Stage.mp4

12:49

34 - Data Ingestion via named Internal Stages.mp4

02:10

35 - Handson Data Loading from onpremises via internal stage.mp4

09:44

36 - Table Stage & User Stage.mp4

02:13

37 - External Tables.mp4

03:18

38 - Unloading Data from Snowflake.mp4

04:13

39 - Basic Data Transformations.mp4

00:55

5 - Continuous Data Protection

40 - Continuous data protection in Snowflake.mp4

03:03

41 - How Time Travel works in Snowflake.mp4

02:59

42 - Time Travel SQL Extensions.mp4

02:16

43 - Handson Time Travel in Action.mp4

08:06

44 - Time Travel UNDROP SQL extension.mp4

01:05

45 - Handson Undrop using Time Travel.mp4

03:34

46 - Failsafe Storage.mp4

03:03

47 - Time Travel & Failsafe storage costs DEL.mp4

02:07

48 - Types of tables in Snowflake.mp4

03:29

49 - Handson Demonstrating Temporary & Transient tables.mp4

05:27

50 - Summary.mp4

02:16

6 - Cloning in Snowflake

51 - Cloning in Snowflake.mp4

01:47

52 - How Cloning works in Snowflake.mp4

04:28

53 - Some caveats related to Cloning.mp4

02:30

54 - Handson Clone a Table.mp4

06:15

55 - Handson Clone a complete schema & a complete database.mp4

04:33

56 - Handson Cloning with Time Travel.mp4

04:34

57 - Summary.mp4

01:54

7 - Data Sharing in Snowflake

58 - Data Sharing in Snowflake.mp4

02:41

59 - How Data Sharing works in Snowflake.mp4

02:30

60 - Snowflake offerings for Data Sharing.mp4

02:32

61 - Direct Sharing Process.mp4

03:01

62 - Handson Share a table with another Snowflake Account.mp4

07:58

8 - Security in Snowflake

8 - Quiz Security in Snowflake.html

63 - Security in Snowflake.mp4

03:05

64 - Data Encryption at Rest.mp4

01:39

65 - Multifactor Authentication or MFA.mp4

03:45

66 - Other Authentication Aspects.mp4

01:49

67 - Access Control in Snowflake DAC & RBAC.mp4

04:10

68 - Other Authorization Aspects.mp4

05:02

69 - Out of the Box Roles in Snowflake.mp4

02:34

70 - Network Security.mp4

03:32

71 - Summary.mp4

05:08

Description

Includes practice exam (100+ questions), focused quizzes for each section & practical assignments

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

Who is this 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

More details

Description
This course will help you prepare for the 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 is the Practice Exam which will test your knowledge of the concepts learned in this course. The practice exam included in this course is not a guarantee of exam success, but it 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

User Reviews

Rating

average 0

Total votes0

Focused display

Network Engineering

Hamid Qureshi

Instructor's Courses

I am a data professional with 20 years of experience architecting, designing, and leading the deployment of many data warehouses, data analytics, and business intelligence solutions. During my career, I have acquired substantial experience and qualifications with various data analytics systems, including Teradata, Oracle, Hadoop, and modern cloud-based tools like Snowflake. I am currently in the role of a senior data architect and an enterprise architect. Despite the architecture hat, I am very much hands-on, and that is how I have designed my courses and books, a mixture of theory interlaced with hands-on exercise to re-enforce the learning.Speaking of books, I have authored two books on Snowflake. The first one of these books is the Snowflake cookbook, published almost 2 years ago and has proven to be a great success. The second book is the SnowPro Core certification study guide to assist students with attaining SnowPro Core certification. I am passionate about technology solutions for data warehouses, data lakes, and data lake houses. My goal is to assist & guide every data professional to fully understand the wonderful world of data and its associated concepts and enable them to design efficient and large-scale data analytics solutions.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.