Snowflake Datawarehouse cloud power point presentation

Snowflake

1. Snowflake Promo Video

2. Pre-requisites Basic Database knowledge. Know the basics of Database and Data warehousing Learn and Practice Basic SQL queries

3. How to Use Resources Go through the PPT first Watch the video Practice queries Complete Assessments

4. Content Day 1 Introduction to Snowflake Day 14 Caching in Snowflake Day 2 Snowflake Architecture and Virtual Warehouses Day 15 Time Travel and Fail-Safe Day 3 Trial Account Creation and Snowsight Day 16 Zero-Copy Cloning Day 4 Micro Partitions and Cluster Keys Day 17 Table Types Day 5 Snowflake Pricing(Cost) Day 18 Role Based Access Control Day 6 Loading and Transforming Data Day 19 Roles and Users Creation Day 7 Stages - External Stages Day 20 Dynamic Data Masking Day 8 AWS - Snowflake Integration Day 21 Views and Materialized Views Day 9 Internal Stages and SnowSQL Day 22 Data Sharing Day 10 Processing Semi-Structured Data Day 23 Tasks for Scheduling Day 11 SnowPipe Day 24 Streams for CDC Day 12 Troubleshooting SnowPipe Day 25 External Tables Day 13 Unloading Data Day 26 UDFs and Stored Procedures

5. How Easy learning Snowflake? No need to install software Basic laptop with Internet Just login with user id and password Go through the PPT Type(don’t copy paste) queries and practice

6. How to Prepare for Interview After Learning and Practicing Snowflake 1. Go through the interview questions available at the end of course 2. Practice FAQ on SQL 3. Go through Interview Tips

7. Thank You