Snowflake Full Course - Beginner to Advanced

Snowflake - LEVEL-1 Duration: 15 Hours Contents: Module-1: Getting Up To Speed On Cloud Data Warehousing  What is Cloud?  What is a DataBase & Data WareHouse?  OLAP vs OLTP  DataWarehouse Schemas  AWS Account Setup  AWS Account  AWS Services  Creating S3 bucket  Creating policy  SaasS, Paas & Iaas  Data warehousing: past to present  Understanding the benefits of a cloud data warehouse Module-2: Introduction To Snowflake  Account Setup  Overview of the WebUI  Worksheets  Using Object Explorer in Snowflake  Roles overview  ACCOUNTADMIN  SECURITYADMIN  SYSADMIN, USERADMIN  Custom roles Module-3: Connecting To Snowflake  Overview of the Ecosystem  SnowSQL (CLI Client)  Installing SnowSQL  Configuring SnowSQL  Connecting Through SnowSQL  Using SnowSQL  JDBC Driver  Downloading / Integrating the JDBC Driver  Configuring and Using the JDBC Driver  JDBC Driver Diagnostic Service  ODBC Driver & Downloading the ODBC Driver  Installing and Configuring the ODBC Driver for Windows  ODBC Configuration and Connection Parameters  ODBC Driver API Support  ODBC Driver Diagnostic Service  Client Considerations  Diagnosing Common Connectivity Issues Module-4: Snowflake architecture  Key Concepts & Architecture  Cloud Platforms  Snowflake Editions  Overview of Key Features  Overview of the Data Lifecycle  Continuous Data Protection  Quiz on Architecture Module-5: Virtual warehouses  Scaling policy  Assignment on virtual warehouse  Quiz on virtual warehouse Module-6: Learn & Play with SQL in Snowflake  DDL: Data Definition Language o CREATE,DROP,ALTER,TRUNCATE  DML: Data Manipulation Language o INSERT,UPDATE,DELETE  TCL: Transaction Control Language o COMMIT,ROLLBACK,SAVEPOINT  DCL: Data Control Language o GRANT,REVOKE  DQL: Data Query Language o SELECT Module-7: DQL: Data Query Langue in Detail  CONSTRAINTS, JOINS  LIKE,WHERE  SORTING  GROUP BY,HAVING  INDEX, FUNCTIONS  & Many More  Assignments on DQL Module-8: Micro-partitions & Data Clustering  What are Micro-partitions?  Benefits of Micro-partitioning  Impact of Micro-partitions  Query Pruning  What is Data Clustering?  Clustering Information Maintained for Micro-partitions  Clustering Depth  Clustering Depth Illustrated  Monitoring Clustering Information for Tables This Section includes the following: 15 hours of recorded Sessions 5-6 Assignments 100 Question and Answers Snowflake - LEVEL-2 Duration: 15 Hours Contents: Module-1: Snowflake Objects  Databases  Schemas  Types of Tables in SNowflake o PERMANENT o TEMPORARY-Local & Global o TRANSIENT o EXTERNAL  Views in Snowflake o Standard view o Materialized View o Secure View o Non-Materialized View  Assignments on Snowflake Objects Module-2: Working with Snowflake Objects  Understanding Zero-Copy Cloning  Cloning tables  Cloning schemas & databases  Swapping tables  Sharing a secure view  Using materialized views  Refresh materialized views  When to use materialized views & Maintenance coststs Module-3: Stages in Snowflake  Understanding stages  Creating stage  COPY command  Copy options & ON_ERROR  Assignment & Quiz Create a stage & load data  VALIDATION_MODE  Handling the rejected records  SIZE_LIMIT  RETURN_FAILED_ONLY  TRUNCATION of COLUMNS  FORCE Module-4: Snowpipes in Snowflake  High-level steps  Creating stage  Creating pipe  Configure pipe & notifications  Error handling  Manage pipes Module-5: Semi- Structured File Formats in Snowflake  JSON  Paraquet  AVRO  Xml  ORC  Handling nested data  Parsing & handling array  Dealing with hierarchy Module-6: Loading / Unloading Data Into/From Snowflake  Overview of Data Loading/Unloading  Data Loading/Unloading Considerations  Preparing to Load/Unload Data  Bulk Loading/Unloading from a Local File System  Bulk Loading/Unloading from Amazon S3  Bulk Loading /Unloading from Microsoft Azure  Loading Continuously Using Snowpipe  Loading Using the Web Interface (Limited)  Querying Data in Staged Files  Querying Metadata for Staged Files  Transforming Data During a Load Module-7: Snowflake tasks  Creating tasks  Using CRON  Understand tree of tasks  Creating trees of tasks  Calling a stored procedure  Task history & error handling  Tasks with condition Module-8: Understanding streams in Snowflake  Process all data changes  Combine streams & tasks  Types of streams  Changes clause This Section includes the following: 15 hours of recorded Sessions 5-6 Assignments 100 Question and Answers