Ultimate SnowPro Core Certification Course & Exam - 2022/23

Focused View

Tom Bailey

7:06:31

124 View

1 - Introduction

1 - Course Structure.mp4

02:45

2 - Making the most of this course.mp4

02:41

2 - SnowPro-Core-Course-Hands-on-Resources.zip

3 - Provisioning a trial Snowflake account Handson.mp4

06:24

2 - Snowflake Features & Architecture

4 - Snowflake Features & Architecture Introduction.mp4

00:56

5 - What is Snowflake.mp4

09:07

6 - Multicluster Shared Data Architecture.mp4

06:14

7 - Storage Layer Overview.mp4

03:19

8 - Query Processing Layer Overview.mp4

03:58

9 - Services Layer Overview.mp4

02:42

10 - Snowflake Editions.mp4

02:13

11 - Snowflake Object Model.mp4

03:33

12 - Organizations Accounts Databases & Schemas.mp4

07:37

13 - Table & View Types.mp4

05:39

14 - Databases Schemas Tables & Views Handson.mp4

06:59

15 - User Defined Functions UDFs.mp4

07:49

16 - Stored Procedures.mp4

03:12

17 - UDFs External Functions & Stored Procedures Handson.mp4

05:41

18 - Sequences.mp4

03:08

19 - Tasks & Streams.mp4

06:16

20 - Billing Overview.mp4

08:07

21 - User Interfaces Handson.mp4

07:10

22 - SnowSQL Handson.mp4

03:40

23 - Connectivity Connectors Drivers & Partnered Tools.mp4

05:13

24 - Connectivity Snowflake Scripting.mp4

05:11

25 - Snowpark.mp4

05:16

3 - Account Access & Security

26 - Account Access & Security Introduction.mp4

00:51

27 - Access Control Overview.mp4

04:01

28 - Roles.mp4

05:02

29 - Privileges.mp4

02:28

30 - Access Control Handson.mp4

08:00

31 - User Authentication.mp4

02:05

32 - Multifactor Authentication MFA.mp4

03:03

33 - Federated Authentication.mp4

03:01

34 - Key Pair Authentication OAuth & SCIM.mp4

02:46

35 - Network Policies.mp4

03:14

36 - Data Encryption.mp4

07:01

37 - Column Level Security.mp4

05:32

38 - Row Level Security.mp4

03:37

39 - Column and Row Level Security Handson.mp4

04:58

40 - Secure Views.mp4

02:19

41 - Account Usage & Information Schema.mp4

05:51

4 - Performance Concepts Virtual Warehouses

42 - Performance Concepts Virtual Warehouses Introduction.mp4

00:45

43 - Virtual Warehouse Overview.mp4

02:56

44 - Virtual Warehouse Sizing and Billing.mp4

04:24

45 - Virtual Warehouse State & Properties.mp4

03:39

46 - Virtual Warehouse Overview Handson.mp4

05:21

47 - Resource Monitors.mp4

03:07

48 - Compute Monitoring & Resource Monitors Handson.mp4

05:30

49 - Multicluster Warehouses.mp4

07:34

5 - Performance Concepts Query Optimisation

50 - Query performance analysis tools Handson.mp4

07:27

51 - SQL Tuning.mp4

07:46

52 - Caching.mp4

04:52

53 - Caching Handson.mp4

06:12

54 - Materialized Views.mp4

04:18

55 - Clustering.mp4

05:57

56 - Automatic Clustering.mp4

06:06

57 - Clustering & Pruning Handson.mp4

05:16

58 - Search Optimization Service.mp4

02:45

6 - Data Loading & Unloading

59 - Data Loading and Unloading Introduction.mp4

00:41

60 - Simple Data Loading Methods INSERT & UI Handson.mp4

04:21

61 - Stages.mp4

09:04

62 - Stages Handson.mp4

05:28

63 - Bulk Loading COPY INTO TABLE command.mp4

07:35

64 - File Formats.mp4

02:34

65 - Bulk Loading Handson.mp4

05:08

66 - Snowpipe.mp4

08:25

67 - Data Unloading.mp4

05:28

68 - Semistructured Overview.mp4

06:09

69 - Loading and Unloading Semistructured Data.mp4

05:28

70 - Accessing Semistructured Data.mp4

04:04

71 - Semistructured Functions.mp4

03:29

72 - Semistructured Data Handson.mp4

07:35

7 - Data Transformations

73 - Data Transformations Introduction.mp4

00:24

74 - Summary of Snowflake Functions.mp4

04:51

75 - Estimation Functions.mp4

06:59

76 - Table Sampling.mp4

02:52

77 - Unstructured File Functions.mp4

06:07

78 - Directory Tables.mp4

02:39

79 - File Support REST API.mp4

02:15

8 - Storage Data Protection & Data Sharing

80 - Storage Data Protection & Data Sharing Introduction.mp4

00:33

81 - Storage Layer Overview.mp4

02:04

82 - Micropartitions.mp4

04:58

83 - Time Travel & FailSafe.mp4

05:57

84 - Time Travel Handson.mp4

05:41

85 - Cloning.mp4

05:03

86 - Cloning Handson.mp4

02:38

87 - Replication.mp4

02:36

88 - Storage Billing.mp4

03:08

89 - Secure Data Sharing.mp4

08:32

90 - Secure Data Sharing Handson.mp4

06:17

91 - Data Marketplace Handson.mp4

03:01

92 - Data Exchange.mp4

01:11

9 - Mock SnowPro Core Exam 100 Questions

1 - Mock SnowPro Core Exam.html

10 - Thank You

93 - Thank You & Well Done.mp4

00:42

Description

Learn Snowflake from scratch with a certified data engineer and ace the SnowPro Core COF-C02 certification exam.

What You'll Learn?

Learn the fundamentals of Snowflake with a mixture of theory lectures and practical hands-on using the Snowflake platform.
End of course mock exam including 100 questions to help you prepare for certification exam.
End of section quizzes to solidify knowledge from each section.
Downloadable code samples for the practical hands-on lessons.
Learn in-depth about Snowflake’s architecture including storage concepts in the storage layer, warehouses in the compute layer and the global services layer.
In-depth look at the Snowsight UI and the classic console and a comparison of their features.
Learn about Snowflake’s broad set of objects including Organizations, Accounts, Databases, Schemas, Tables, Views, User-define functions (UDFs) and much more.
Overview of high-level programmatic data processing with the Snowpark API.
Learn about Snowflake security features including Network Policies, Multi-Factor Authentication (MFA), Federated Authentication and Single Sign-On (SSO).
Learn about the access control schemes Snowflake use including Role Based Access Control (RBAC) and Discretionary Access Control (DAC).
Learn about the ways you can monitor and track usage within organizations, accounts and tables programmatically and through the UI.
Learn to optimise query performance using the Query Profile tool, Materialized Views, Clustering, the Search Optimization Service and tuning SQL code.
Learn how to load and unload data into Snowflake. Covering bulk data loading with the COPY INTO statement and continuous data loading with Snowpipe.
Learn how to work with structured, semi-structured and unstructured data.
Learn about Snowflake data protection features such as Time Travel, Fail-safe, Data Encryption, Cloning and Replication.
Learn how to share data between Snowflake accounts with Secure Data Sharing, the Data Marketplace and the Data Exchange.

Who is this for?

Anyone wanting to know more about Snowflake or prepare for the SnowPro Core Certification.

More details

Description
Welcome to the ultimate COF-C02 SnowPro Core Certification preparation course! After completing this course youâ€™ll have everything you need to ace the SnowPro Core certification exam. The contents have been arranged to cover everything from the Snowflake study guide (and more).
It starts with a broad look at Snowflakeâ€™s architecture and key features and moves through important topics such as account security and data protection, performance improvement, data loading and unloading, working with structured, semi-structured and unstructured data and data sharing.
This course not only provides you with a solid practical level of skill you can take into the workplace but also places you well to attempt further certifications such as the SnowPro Advanced: Data Engineer and SnowPro Advanced: Architect.
Even if you have no experience with Snowflake, this course will take you from beginner to certified. Hereâ€™s why:

This is one of the only courses online which is geared specifically to cover the contents of the Core exam for the most recent COF-C02 version of the certification.
As well as all the topics required for the certification exam, the course also includes extra content on advanced topics to help you truly master Snowflake.
This is one of the most comprehensive Snowflake courses you can find on Udemy with over 7+ hours of quality HD videos, providing an engaging mixture of theory and hands-on lessons.
Because we start with beginners in mind, and cover basic to advanced topics, itâ€™s great even for those not intending to take the certification exam. There is enough content to drop in and out of the areas that interest you.
Your instructor is an experienced data engineer certified in Amazon Web Services (AWS), Apache Kafka and most importantly for this course, has earned the SnowPro Core and SnowPro Advanced Data Engineer certifications.
All lectures and hands-on have been designed from the ground up to make difficult topics easy to understand, getting straight to the point and using simple English.
Includes personal support via the Q&A when you have questions and queries either about Snowflake concepts or assistance with making the most out of the course.

What do you get with this course?

Covers in-depth all the topics required for the COF-C02 SnowPro Core Certification exam.
Hands-on lessons using the new Snowsight Web Interface with downloadable code examples.
Theory lectures which include architectural diagrams, graphics, code snippets and overview slides to bookmark and study from.
Practice exam with 100 questions.
A questionnaire at the end of each section to help solidify the theory and hands-on covered.
The perspective of someone who has studied and passed the Core and Advanced Snowflake certifications.

What is covered in the course?

Snowflake Cloud Data Platform Features & Architecture
Including an overview of Snowflake, the multi-cluster shared data architecture, storage, query processing and services layers, Snowflake editions and more.
Account Access & Security
Including a review of RBAC and DAC access control schemes, deep-dive on roles and privileges, various types of authentication including user authentication, multi-factor authentication (MFA), federated authentication, Key Pair authentication and more.
Performance Concepts: Virtual Warehouses:
Including a Virtual warehouse overview, a look at virtual warehouse sizing and billing, virtual warehouse state & properties, resource monitors and more.
Performance Concepts: Query Optimization
Including a look at query performance analysis tools, SQL tuning, caching, clustering and more.
Data Loading & Unloading
Including a review of simple loading methods such as INSERT, stage objects, file format objects, the serverless feature Snowpipe, bulk loading with the COPY INTO
statement, semi-structured functions and more.
Data Transformations
Including a birds eye look at functions, deep-dive into estimation functions, table sampling, directory tables and more.
Storage, Data Protection and Data Sharing
Including an overview of the storage layer, deep-dive into micro-partitions, data protection features Time Travel and Fail-safe, cloning, replication and more.
In other words, there is a lot of content in this course for you to learn from and that will help you achieve an excellent score in your certification exam!
And once you have passed (which I am sure you will) Iâ€™d love to share in your success, so please tag me in a post on LinkedIn. My LinkedIn handle: thomas-bailey-bd.
Enroll now to get lifelong access and pass the SnowPro Core Certification!
Who this course is for:
Anyone wanting to know more about Snowflake or prepare for the SnowPro Core Certification.

User Reviews

Rating

average 0

Total votes0

Focused display

Hi! My name is Tom Bailey. Thanks for checking out my ‘About me’ section.I’ve worked in technology consulting for nearly a decade, helping a diverse range of clients in industries from automotive to consumer goods transform their business needs into robust technical solutions. I’ve assumed many roles during that time, but I’m primarily interested in cloud data & software engineering!As a consultant I’ve had to move from project to project, which always brings with it the necessity and opportunity to learn. This is one aspect of my job that I've always loved, picking up new technologies, learning their ins and outs and delivering a creative and practical solution.I’ve worked with early big data systems like Cloudera, HorntonWorks, HBase and Spark and more recently streaming & cloud technologies like Amazon Web Services, Apache Kafka and Snowflake. I’ve been fortunate enough to earn: - the AWS Certified Developer Associate certification, - the Confluent Certified Developer for Apache Kafka certification, - Snowflake’s SnowPro Core certification and - Snowflake’s SnowPro Advanced Data Engineer certification.Learning coupled with regularly hosting demonstrations and brown-bag sessions really ignited in me a passion for teaching. My personal teaching methodology leans more towards emphasising and building real-world skills, not just reciting facts.It brings me a lot of joy to help others excel in their career and see them thrive, so please reach out if you’ve taken one of my courses, I’d love to hear from you. The best way to do that is to message me on LinkedIn or tag me in a post telling me about your experience with the course or the result of a certification you’re going for.Thanks for taking the time to get to know me. If you’d like to get in touch, please do not hesitate.

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.