Snowpro Core Certification Preparation

[LeeAndro]

Published 9/2022MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHzLanguage: English | Size: 1.25 GB | Duration: 4h 23m

Ace the SnowPro Core certification.​

Master Snowflake concepts and acquire necessary implementation skills.

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 pass the SnowPro Core certification exam, 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, 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.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 can we 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, 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 a fair assessment of your preparedness.Snowflake offers a variety of certifications. SnowPro Core certification is at the foundation level and is a pre-requisite for other advanced certifications such as data eeering, administration, and data science certification. Because the SnowPro Core certification is a prerequisite for the 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 ing 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

Section 5: Continuous Data Protection

Lecture 40 Continuous data protection in Snowflake

Lecture 41 How Travel works in Snowflake

Lecture 42 Travel SQL Extensions

Lecture 43 Hands-on: Travel in Action

Lecture 44 Travel UNDROP SQL extension

Lecture 45 Hands-on: Undrop using Travel

Lecture 46 Failsafe Storage

Lecture 47 Travel & Fail-safe storage costs DEL

Lecture 48 Types of tables in Snowflake

Lecture 49 Hands-on: Demonstrating Temporary & Transient tables

Lecture 50 Summary

Section 6: Cloning in Snowflake

Lecture 51 Cloning in Snowflake

Lecture 52 How Cloning works in Snowflake

Lecture 53 Some caveats related to Cloning

Lecture 54 Hands-on: Clone a Table

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

Lecture 56 Hands-on: Cloning with Travel

Lecture 57 Summary

Section 7: Data Sharing in Snowflake

Lecture 58 Data Sharing in Snowflake

Lecture 59 How Data Sharing works in Snowflake

Lecture 60 Snowflake offerings for Data Sharing

Lecture 61 Direct Sharing Process

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

Section 8: Security in Snowflake

Lecture 63 Security in Snowflake

Lecture 64 Data Encryption at Rest

Lecture 65 Multifactor Authentication or MFA

Lecture 66 Other Authentication Aspects

Lecture 67 Access Control in Snowflake (DAC & RBAC)

Lecture 68 Other Authorization Aspects

Lecture 69 Out of the Box Roles in Snowflake

Lecture 70 Network Security

Lecture 71 Summary

Section 9: 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 Eeers & 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

HomePage:

Https://anonymz.com/https://www.udemy.com/course/snowpro-core-certification-preparation/

DOWNLOAD

https://1dl.net/yxpsjj8b61sb/ZdbR6szZ__Snowpro_Co.part1.rar.html
https://1dl.net/2udg69yyim5e/ZdbR6szZ__Snowpro_Co.part2.rar.html