Snowflake Certification Course

Guarantee your way to SnowPro Core!

What you'll learn

Data Architects & Data Engineers who want to expand their knowledge to new data warehouse technologies

Database Administrators who want to invest in their skills of working within new cloud technologies

Anyone who wants to learn Snowflake from beginner to advanced

Anyone who wants work with data and wants learn learn about the latest cloud technologies

Requirements

access to the internet & motivation to learn

Basic knowledge of SQL is helpful

Snowflake Data Warehouse free trial account

Description

Learn Snowflake concepts step by step.  Get all the required basic and advanced concepts to ace your SnowPro Core examination.The course contains the interview questions as well just in case you are looking for more details on what type of questions are asked these days.Become a master in Snowflake and learn everything from scratch!Why should you take this course?1. Structured and practice-oriented course.2. Learn all the important features and how to use them properly3. Clear explanations and systematic.What is in this course?In this course, you will learn everything you need to master Snowflake Data warehouse!1. Master the fundamentals2. Master all the advanced topics3. Learn the best practices hands-onThis course is right for you if…… you have never worked with Snowflake and want to learn how to master everything hands-on in just one course…. OR you already have some basic knowledge and want to dive deeper and become more advanced in the whole universe of Snowflake.This is the one course that covers everything you need to Master Snowflake.Enroll now to get lifelong access and master Snowflake!The entire course will be kept up to date and new advanced features will be added to this course as well to make sure that the relevant knowledge is always provided to the students!

Overview

Section 1: Introduction

Lecture 1 What is a Snowflake Data Warehouse

Lecture 2 Basics of Cloud computing

Lecture 3 Basics of Cloud computing - 2

Lecture 4 What is IaaS, PaaS, SaaS

Lecture 5 Query Processing in Snowflake Data Warehouse

Section 2: Lets Get started with Snowflake!

Lecture 6 Creating SF Account and defaults.mp4

Lecture 7 Introduction to Virtual Warehouses

Lecture 8 Virtual Warehouses - Deep Dive

Lecture 9 Creating Virtual Warehouses

Lecture 10 Creating tables, Schemas and loading file

Section 3: Snowflake Datawarehouse Features deep dive

Lecture 11 System Views in Snowflake Datawarehouse

Lecture 12 Clustering and Micropartitions

Lecture 13 Continuous Data Protection

Lecture 14 Types of tables in Snowflake Datawarehouse

Lecture 15 Type of tables (cont) and Views

Section 4: Copying Data into Snowflake Datawarehouse - Setup

Lecture 16 Introduction to Stages

Lecture 17 Stage Objects - Deep Dive

Lecture 18 Stage Objects - Part 2

Section 5: Interview Questions of Snowflake Data warehouse

Lecture 19 Interview Questions

Section 6: AWS Setup

Lecture 20 Setting up AWS account

Section 7: Copying data into Snowflake datawarehouse

Lecture 21 COPY INTO

Lecture 22 Stage Options

Lecture 23 Handling error records

Lecture 24 Load History and Intro to Semi Structured files

Lecture 25 Parsing Semi structured files

Section 8: Snowflake Data warehouse - Advanced concepts

Lecture 26 Streams

Lecture 27 Tasks

Lecture 28 Dynamic tables

Lecture 29 Internal Stages

Section 9: SnowSQL

Lecture 30 SnowSQL

Section 10: Additional Features

Lecture 31 COPY FILES

Lecture 32 SnowPipe

You if you have never worked with Snowflake and want to learn how to master everything hands-on in just one course,If have some basic knowledge and want to dive deeper and become more advanced in the whole universe of Snowflake.