Snowpro Core Certification Preparation - Cof-C02

Last updated 5/2023
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.44 GB | Duration: 6h 21m

Includes practice exam (300 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

Requirements
Some familiarity with database concepts

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

Overview
Section 1: Introduction & Overview

Lecture 1 Introduction to this Course

Lecture 2 Introduction to the instructor

Lecture 3 How is this course structured

Lecture 4 Snowpro Core Certification

Lecture 5 Snowpro Core Domains

Lecture 6 Introduction to Snowflake

Lecture 7 Snowflake Editions

Lecture 8 Signup for a Snowflake Trial

Lecture 9 First impressions of Snowflake WebUI

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

Lecture 11 Downloading the resources for this course

Section 2: Snowflake Architecture

Lecture 12 Snowflake Architecture is its differentiator

Lecture 13 Traditional Database Architecture

Lecture 14 Snowflake Architecture

Lecture 15 Compute Layer aka Virtual warehouse

Lecture 16 Hands-on: Creating a new Virtual Warehouse

Lecture 17 Snowflake Storage - Micro partitions

Lecture 18 Cloud Services - the brain of the operations

Lecture 19 Compute Layer - Virtual Warehouses In Depth

Lecture 20 Query Execution & Caching in Snowflake

Lecture 21 Snowflake Pricing

Lecture 22 Summary

Section 3: Web UI, Tools & Drivers

Lecture 23 Snowflake Connectivity – Drivers & Interfaces

Lecture 24 Classic Snowflake Web UI

Lecture 25 Worksheet view Walkthrough

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

Lecture 27 The new Web UI

Lecture 28 Summary

Section 4: Data Loading in Snowflake

Lecture 29 Section Introduction

Lecture 30 Birds eye view of data loading

Lecture 31 The use of Stage during data loading

Lecture 32 External Stage

Lecture 33 Data Ingestion using named External Stage

Lecture 34 Data Ingestion via named Internal Stages

Lecture 35 Hands-on: Data Loading from on-premises via internal stage

Lecture 36 Table Stage & User Stage

Lecture 37 External Tables

Lecture 38 Unloading Data from Snowflake

Lecture 39 Basic Data Transformations

Lecture 40 Snowpipe

Section 5: Continuous Data Protection

Lecture 41 Continuous data protection in Snowflake

Lecture 42 How Time Travel works in Snowflake

Lecture 43 Time Travel SQL Extensions

Lecture 44 Hands-on: Time Travel in Action

Lecture 45 Time Travel UNDROP SQL extension

Lecture 46 Hands-on: Undrop using Time Travel

Lecture 47 Failsafe Storage

Lecture 48 Time Travel & Fail-safe storage costs

Lecture 49 Types of tables in Snowflake

Lecture 50 Hands-on: Demonstrating Temporary & Transient tables

Lecture 51 Summary

Section 6: Cloning in Snowflake

Lecture 52 Cloning in Snowflake

Lecture 53 How Cloning works in Snowflake

Lecture 54 Some caveats related to Cloning

Lecture 55 Hands-on: Clone a Table

Lecture 56 Hands-on: Clone a complete schema & a complete database

Lecture 57 Hands-on: Cloning with Time Travel

Lecture 58 Summary

Section 7: Data Sharing in Snowflake

Lecture 59 Data Sharing in Snowflake

Lecture 60 How Data Sharing works in Snowflake

Lecture 61 Snowflake offerings for Data Sharing

Lecture 62 Direct Sharing Process

Lecture 63 Hands-on: Share a table with another Snowflake Account

Lecture 64 Hands-on: Direct Sharing using the User Interface

Lecture 65 Hands-On: Share a table with a non-Snowflake customer

Lecture 66 Snowflake Marketplace

Lecture 67 Hands-on: Explore Snowflake Marketplace

Lecture 68 Data Exchange

Section 8: Snowflake Performance Features & Optimization

Lecture 69 Introduction to Snowflake Performance Features & Optimizations

Lecture 70 Query Execution in Snowflake

Lecture 71 Hands-on: Access Query Profile

Lecture 72 Caching in Snowflake

Lecture 73 Query Result Cache

Lecture 74 Hands-on: Demonstrate Query Result Cache

Lecture 75 Metadata Cache

Lecture 76 Hands-on: Demonstrate Metadata Cache

Lecture 77 Virtual Warehouse Cache

Lecture 78 Hands-on: Demonstrate Virtual Warehouse Cache

Lecture 79 Partition Pruning & Clustering Keys

Lecture 80 Clustering Depth

Lecture 81 Scaling up and down a virtual warehouse

Lecture 82 Multi-cluster virtual warehouse / Scaling out

Lecture 83 Scaling Policies

Lecture 84 Materialized Views

Lecture 85 Search Optimization Service

Lecture 86 Summary

Section 9: Security in Snowflake

Lecture 87 Security in Snowflake

Lecture 88 Data Encryption at Rest

Lecture 89 Multifactor Authentication or MFA

Lecture 90 Other Authentication Aspects

Lecture 91 Access Control in Snowflake (DAC & RBAC)

Lecture 92 Other Authorization Aspects

Lecture 93 Out of the Box Roles in Snowflake

Lecture 94 Network Security

Lecture 95 Summary

Section 10: Extending Snowflake Functionality

Lecture 96 Extending Snowflake Functionality

Lecture 97 Secure UDFs

Lecture 98 Stored Procedures

Lecture 99 Snowpark

Lecture 100 Snowflake Scripting

Section 11: Account & Resource Management

Lecture 101 Account & Resource Management in Snowflake

Lecture 102 Resource Monitors

Lecture 103 Usage & Billing Views

Lecture 104 Account Usage Schema

Lecture 105 Information Schema

Lecture 106 Snowflake Release Process

Section 12: Practice Exams & other resoruces

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

Buy Premium Account From My Download Links & Get Fastest Speed.