Snowflake Complete Course for Clearing Interviews

سرفصل های دوره

You can easily learn Snowflake by using the PPTs I have given and by practicing the SQL queries given.

1. Introduction to Snowflake

1.1 1.Udemy Snowflake Intro.pptx

1. Getting Started

2.1 2.Why_Snowflake.pptx

2. Introduction

2. Snowflake Architecture

1.1 3.Snowflake Architecture.pptx

1. Architecture

2.1 4.Virtual Warehouses.pptx

2. Virtual Warehouses

3. Trial Account Creation and Snowsight Overview

1. Trial Account Creation and Web UI Overview

4. Micro Partitions and Clustering

1.1 5.Micro-Partitions and Clustering.pptx

1.2 assignment_1.zip

1.3 lab1_clustering.zip

1. Micro Partitions and Clustering

5. Data Loading and Transforming

1.1 6.DataLoading_in_Snowflake.pptx

1.2 assignment_2.zip

1.3 lab2_loading_data.zip

1.4 lab3_transforming_data.zip

1. Data Loading and Transforming

6. Stages in Snowflake

1.1 7.Stages_in_Snowflake.pptx

1.2 lab4_externalstages_and_fileformats.zip

1.3 Stage_And_FileFormat_Properties.xlsx

1. External Stages

2.1 7.Stages_in_Snowflake.pptx

2.2 customer_data_named.csv

2.3 customer_data_table.csv

2.4 customer_data_user.csv

2.5 lab5_snowsql_internalstages.zip

2. Internal Stages and SnowSQL

3.1 8.Working_With_CopyCommand_Options.pptx

3.2 assignment_2.zip

3.3 customer_data_2021.csv

3.4 lab6_copy_options.zip

3.5 streaming_data.csv

3. Copy Command Options

7. Snowflake - AWS Integration

1.1 9.AWS_Snowflake_Integration.pptx

1.2 assignment_2.zip

1.3 customer_data_2020.csv

1.4 customer_data_2021.csv

1.5 customer_data_2022.csv

1.6 lab7_loading_data_from_aws.zip

1. AWS Integration

8. Processing Semi-Structured Data

1.1 4wheelers.zip

1.2 assignment_3.zip

1.3 lab8_handling_semistructureddata_json.zip

1.4 lab8_loading_parquet_data.zip

1.5 pets_data.zip

1.6 sales_items_data.zip

1. Processing Json Data

9. Snowflake Pricing and Editions

1.1 10.Snowflake_Editions.pptx

1.2 11.Snowflake_Pricing.pptx

1. Pricing - Cost Calculation in Snowflake

10. Snowpipe

1.1 12.Snowpipe.pptx

1.2 lab9_snowpipe_aws.zip

1.3 sp_employee_1.csv

1.4 sp_employee_2.csv

1.5 sp_employee_3.csv

1.6 sp_employee_4.csv

1.7 sp_employee_5.csv

1. Snowpipe

2.1 12.Snowpipe.pptx

2.2 assignment_4.zip

2.3 assignment_5.zip

2.4 assignment_6.zip

2.5 lab9_troubleshooting_snowpipe_aws.zip

2. Troubleshooting Snowpipe

11. Caching in Snowflake

1.1 Caching in Snowflake.pptx

1.2 lab10_caching.zip

1. Caching

12. Time-Travel and Fail-Safe

1.1 13.TimeTravel_and_FailSafe.pptx

1.2 lab11_timetravel.zip

1. Time-Travel and Fail-Safe

13. Zero-Copy Cloning

1.1 14.Zero Copy Cloning.pptx

1.2 lab12_zerocopycloning.zip

1. Zero-Copy Cloning

14. Table Types

1.1 15.Table_Types.pptx

1.2 lab13_table_types.zip

1. Table Types

15. Role Based Access Control

1.1 16.Access_Control_in_Snowflake.pptx

1.2 Snowflake_Roles.xlsx

1. Access Control in Snowflake

2.1 lab14_accesscontrol_in_snowflake.zip

2.2 Snowflake_Roles.xlsx

2. Roles and Users Creation

16. Views in Snowflake

1.1 17.Views_and_MaterializedViews.pptx

1.2 lab15_views_and_materializedviews.zip

1. Views and Materialized Views

17. Dynamic Data Masking

1.1 18.DynamicDataMasking.pptx

1.2 lab16_dynamic_data_masking.zip

1. Dynamic Data Masking

18. Data Sharing

1.1 19.Data_Sharing.pptx

1.2 lab17_datasharing.zip

1. Data Sharing

19. Tasks and Streams

1.1 20.Tasks_in_Snowflake.pptx

1.2 lab18_tasks.zip

1. Tasks for Scheduling

2.1 21.Streams_in_Snowflake.pptx

2.2 lab19_streams.zip

2. Streams for CDC

20. Data Unloading

1.1 lab21_unloading_data.zip

1.2 Unloading Data.pptx

1. Data Unloading

21. External Tables

1.1 22.ExternalTables_in_Snowflake.pptx

1.2 customer_data_2020.csv

1.3 customer_data_2021.csv

1.4 customer_data_2022.csv

1.5 lab20_externaltables.zip

1.6 orders_data_2021.csv

1.7 orders_data_2022.csv

1. External Tables

22. Stored Procedures and UDFs

1.1 23.UserDefinedFunctions.pptx

1.2 lab22_userdefinedfunctions.zip

1. User Defined Functions (UDFs)

2.1 24.StoredProcs.pptx

2.2 lab23_storedprocedures.zip

2. Stored Procedures

3.1 proc_table_count.zip

3. Stored Procedures using Java Script

23. Snowflake Interview Questions and Tips

1.1 Snowflake Interview Questions - Part I.pdf

1. Snowflake Interview Questions - 1

2.1 Snowflake Interview Questions - Part II.pdf

2.2 snowflake interview tips.zip

2.3 snowflake_final_assessment.zip

2. Snowflake Interview Questions - 2

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training