Snowpro Core Certification Preparation

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, 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.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, 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 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 engineering, 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 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
Section 5: Continuous Data Protection
Lecture 40 Continuous data protection in Snowflake
Lecture 41 How Time Travel works in Snowflake
Lecture 42 Time Travel SQL Extensions
Lecture 43 Hands-on: Time Travel in Action
Lecture 44 Time Travel UNDROP SQL extension
Lecture 45 Hands-on: Undrop using Time Travel
Lecture 46 Failsafe Storage
Lecture 47 Time 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 Time 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 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


Homepage

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