Ultimate Snowpro Core Certification Course & Exam - 2022/23

0

1

2

3

4

5

Posted on 06 Nov 16:29 | by mitsumi | 26 views

Ultimate Snowpro Core Certification Course & Exam - 2022/23
Published 11/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.71 GB | Duration: 7h 6m

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.
Requirements
Basics of SQL syntax such as selecting, inserting, and dropping data. Any SQL concepts specific to Snowflake will be explained thoroughly during the course.
Understanding the basics of cloud computing will help but is not needed to complete this course.
For the hands-on lessons you'll need a free Snowflake trial account. We walk through the process of obtaining an account in one of the introductory videos!
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 & ArchitectureIncluding an overview of Snowflake, the multi-cluster shared data architecture, storage, query processing and services layers, Snowflake editions and more. Account Access & SecurityIncluding 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 OptimizationIncluding a look at query performance analysis tools, SQL tuning, caching, clustering and more.Data Loading & UnloadingIncluding 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 TransformationsIncluding a birds eye look at functions, deep-dive into estimation functions, table sampling, directory tables and more. Storage, Data Protection and Data SharingIncluding 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!
Overview
Section 1: Introduction
Lecture 1 Course Structure
Lecture 2 Making the most of this course
Lecture 3 Provisioning a trial Snowflake account - Hands-on
Section 2: Snowflake Features & Architecture
Lecture 4 Snowflake Features & Architecture Introduction
Lecture 5 What is Snowflake?
Lecture 6 Multi-cluster Shared Data Architecture
Lecture 7 Storage Layer Overview
Lecture 8 Query Processing Layer Overview
Lecture 9 Services Layer Overview
Lecture 10 Snowflake Editions
Lecture 11 Snowflake Object Model
Lecture 12 Organizations, Accounts, Databases & Schemas
Lecture 13 Table & View Types
Lecture 14 Databases, Schemas, Tables & Views - Hands-on
Lecture 15 User Defined Functions (UDFs)
Lecture 16 Stored Procedures
Lecture 17 UDFs, External Functions & Stored Procedures - Hands-on
Lecture 18 Sequences
Lecture 19 Tasks & Streams
Lecture 20 Billing Overview
Lecture 21 User Interfaces - Hands-on
Lecture 22 SnowSQL - Hands-on
Lecture 23 Connectivity: Connectors, Drivers & Partnered Tools
Lecture 24 Connectivity: Snowflake Scripting
Lecture 25 Snowpark
Section 3: Account Access & Security
Lecture 26 Account Access & Security Introduction
Lecture 27 Access Control Overview
Lecture 28 Roles
Lecture 29 Privileges
Lecture 30 Access Control - Hands-on
Lecture 31 User Authentication
Lecture 32 Multi-factor Authentication (MFA)
Lecture 33 Federated Authentication
Lecture 34 Key Pair Authentication, OAuth & SCIM
Lecture 35 Network Policies
Lecture 36 Data Encryption
Lecture 37 Column Level Security
Lecture 38 Row Level Security
Lecture 39 Column and Row Level Security - Hands-on
Lecture 40 Secure Views
Lecture 41 Account Usage & Information Schema
Section 4: Performance Concepts: Virtual Warehouses
Lecture 42 Performance Concepts: Virtual Warehouses Introduction
Lecture 43 Virtual Warehouse Overview
Lecture 44 Virtual Warehouse Sizing and Billing
Lecture 45 Virtual Warehouse State & Properties
Lecture 46 Virtual Warehouse Overview - Hands-on
Lecture 47 Resource Monitors
Lecture 48 Compute Monitoring & Resource Monitors - Hands-on
Lecture 49 Multi-cluster Warehouses
Section 5: Performance Concepts: Query Optimisation
Lecture 50 Query performance analysis tools - Hands-on
Lecture 51 SQL Tuning
Lecture 52 Caching
Lecture 53 Caching - Hands-on
Lecture 54 Materialized Views
Lecture 55 Clustering
Lecture 56 Automatic Clustering
Lecture 57 Clustering & Pruning - Hands-on
Lecture 58 Search Optimization Service
Section 6: Data Loading & Unloading
Lecture 59 Data Loading and Unloading Introduction
Lecture 60 Simple Data Loading Methods: INSERT & UI - Hands-on
Lecture 61 Stages
Lecture 62 Stages - Hands-on
Lecture 63 Bulk Loading - COPY INTO TABLE command
Lecture 64 File Formats
Lecture 65 Bulk Loading - Hands-on
Lecture 66 Snowpipe
Lecture 67 Data Unloading
Lecture 68 Semi-structured Overview
Lecture 69 Loading and Unloading Semi-structured Data
Lecture 70 Accessing Semi-structured Data
Lecture 71 Semi-structured Functions
Lecture 72 Semi-structured Data - Hands-on
Section 7: Data Transformations
Lecture 73 Data Transformations Introduction
Lecture 74 Summary of Snowflake Functions
Lecture 75 Estimation Functions
Lecture 76 Table Sampling
Lecture 77 Unstructured File Functions
Lecture 78 Directory Tables
Lecture 79 File Support REST API
Section 8: Storage, Data Protection & Data Sharing
Lecture 80 Storage, Data Protection & Data Sharing Introduction
Lecture 81 Storage Layer Overview
Lecture 82 Micro-partitions
Lecture 83 Time Travel & Fail-Safe
Lecture 84 Time Travel - Hands-on
Lecture 85 Cloning
Lecture 86 Cloning - Hands-on
Lecture 87 Replication
Lecture 88 Storage Billing
Lecture 89 Secure Data Sharing
Lecture 90 Secure Data Sharing - Hands-on
Lecture 91 Data Marketplace Hands-on
Lecture 92 Data Exchange
Section 9: Mock SnowPro Core Exam - 100 Questions
Section 10: Thank You!
Lecture 93 Thank You & Well Done!
Anyone wanting to know more about Snowflake or prepare for the SnowPro Core Certification.