#snowflaketechnicalsupport

[tutorontech]

Course Content                                    

❖   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