Snowflake

Snowflake Overview and key features

Security and Data Protection

Standard and Extended SQL Support

Tools and Interfaces

Connectivity

Data Import and Export

Data Sharing

Database Replication and Failover

Snowflake Overview

Multi clustered shared Architecture

Local region

Availability zones

Snowflake editions

Standard

Premier

Enterprise

Enterprise for sensitive data

Virtual private snowflake

Connectivity

Data import and export

Data sharing

Data life cycle

Continuous data protection

Data encryption

Parameters

Data types

SQL format models

Object identifiers

Information schema

Snowflake Architecture

Data storage

Compute layer

Storage layer

Virtual warehouses in Snowflake

Concept

How to determine appropriate size

Resizing or multi clustered VW to fix

Snowflake credits

Databases and Querying

Databases

Accessing databases

Accessing database via roles

Custom roles

Querying

Summary of Data Types

Numeric Data Types

String & Binary Data Types

Logical Data Types

Date & Time Data Types

Semi-structured Data Types

Data loading

Data loading

Staging

Loading using SQL

Loading using Web interface

Demonstration

Create warehouse

Create database

Create schema

Create table

Temporary Tables

Transient Tables

Permanent Tables

Load table – ware house

Load table – source files

Load table – file format

Load table – Load options

Load table – Load results

Query data – preview

Query data – SQL query

Query data – Export results

Query data – SQL script

Query data – Information schema

Suspended Warehouse

Drop ware house

Drop table

Drop schema

Drop database

Snowflake Overview and Architecture

Snowflake procedures

Task scheduling for snowflake procedures

Snowflake Overview and Architecture

Industries

Traditional data warehousing

Datawarehouse as a service

Multi clustered shared architecture

Data storage

Compute layer

Service layer

Local region availability zones

Cloning

Time travel

Snowflake editions

When not to use snowflake

Security and data protection

Virtual warehouse in snowflake

How to determine appropriate size

Snowflake credits

Snowflake Project explanation

Project

Roles and responsibilities

Snowflake Resume preparation

Snowflake Interview questions