Snowflake Complete Course for Clearing Interviews

Focused View

Janardhana Reddy

25:30:34

111 View

1. Introduction to Snowflake

1.1 1.Udemy Snowflake Intro.pptx

1. Getting Started.mp4

05:21

2.1 2.Why_Snowflake.pptx

2. Introduction.mp4

07:08

2. Snowflake Architecture

1.1 3.Snowflake Architecture.pptx

1. Architecture.mp4

33:04

2.1 4.Virtual Warehouses.pptx

2. Virtual Warehouses.mp4

24:53

3. Trial Account Creation and Snowsight Overview

1. Trial Account Creation and Web UI Overview.mp4

36:36

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.mp4

01:04:21

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.mp4

01:00:48

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.mp4

32:22

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.mp4

59:49

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.mp4

32:20

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.mp4

40:40

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.mp4

56:45

9. Snowflake Pricing and Editions

1.1 10.Snowflake_Editions.pptx

1.2 11.Snowflake_Pricing.pptx

1. Pricing - Cost Calculation in Snowflake.mp4

34:03

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.mp4

45:22

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.mp4

52:12

11. Caching in Snowflake

1.1 Caching in Snowflake.pptx

1.2 lab10_caching.zip

1. Caching.mp4

01:16:59

12. Time-Travel and Fail-Safe

1.1 13.TimeTravel_and_FailSafe.pptx

1.2 lab11_timetravel.zip

1. Time-Travel and Fail-Safe.mp4

01:03:36

13. Zero-Copy Cloning

1.1 14.Zero Copy Cloning.pptx

1.2 lab12_zerocopycloning.zip

1. Zero-Copy Cloning.mp4

25:13

14. Table Types

1.1 15.Table_Types.pptx

1.2 lab13_table_types.zip

1. Table Types.mp4

33:59

15. Role Based Access Control

1.1 16.Access_Control_in_Snowflake.pptx

1.2 Snowflake_Roles.xlsx

1. Access Control in Snowflake.mp4

51:27

2.1 lab14_accesscontrol_in_snowflake.zip

2.2 Snowflake_Roles.xlsx

2. Roles and Users Creation.mp4

56:27

16. Views in Snowflake

1.1 17.Views_and_MaterializedViews.pptx

1.2 lab15_views_and_materializedviews.zip

1. Views and Materialized Views.mp4

58:33

17. Dynamic Data Masking

1.1 18.DynamicDataMasking.pptx

1.2 lab16_dynamic_data_masking.zip

1. Dynamic Data Masking.mp4

01:05:48

18. Data Sharing

1.1 19.Data_Sharing.pptx

1.2 lab17_datasharing.zip

1. Data Sharing.mp4

01:12:53

19. Tasks and Streams

1.1 20.Tasks_in_Snowflake.pptx

1.2 lab18_tasks.zip

1. Tasks for Scheduling.mp4

01:12:38

2.1 21.Streams_in_Snowflake.pptx

2.2 lab19_streams.zip

2. Streams for CDC.mp4

01:16:01

20. Data Unloading

1.1 lab21_unloading_data.zip

1.2 Unloading Data.pptx

1. Data Unloading.mp4

29:59

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.mp4

44:39

22. Stored Procedures and UDFs

1.1 23.UserDefinedFunctions.pptx

1.2 lab22_userdefinedfunctions.zip

1. User Defined Functions (UDFs).mp4

31:10

2.1 24.StoredProcs.pptx

2.2 lab23_storedprocedures.zip

2. Stored Procedures.mp4

38:51

3.1 proc_table_count.zip

3. Stored Procedures using Java Script.mp4

56:43

23. Snowflake Interview Questions and Tips

1.1 Snowflake Interview Questions - Part I.pdf

1. Snowflake Interview Questions - 1.mp4

27:25

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.mp4

01:02:29

Description

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

What You'll Learn?

Snowflake Cloud Database Concepts
Snowflake Data loading and Unloading
Snowflake Integration with AWS Cloud
All other new features of Snowflake
Practice with proper SQL queries

Who is this for?

This Course is for the people who are looking for careers in Cloud database technologies and for Data analysts. You can easily learn all the new concepts of snowflake by practicing the examples I have provided here.

More details

Description
Snowflake Complete Course for Clearing Interviews:Â Snowflake is a advanced cloud based Database technology and there are lot of opportunities in the market for snowflake developers. Many organizations are migrating from their traditional data warehouses to Snowflake as it is cloud based and there are lot of f new feature in lesser cost. This course is mainly for people who are looking for Snowflake training and for people preparing for interviews, I am sure you can easily clear interviews after this course. You can easily learn Snowflake by using the PPTs I have given here and by practicing the SQL queries given. If you go through these videos, PPTs and practice all queries, you can easily clear your interviews on Snowflake. I have explained neatly with proper sql query example and I have given sample files for your practice as well. Also I have given some assignments for testing skills after practicing the sql queries. Also you can prepare for snowflake Snowpro Core certification with this course. Please watch video, go through PPT, practice the lab queries and that is it you can learn and implement snowflake easily. Thanks you very much and I wish you all the very best for your learnings and for your interviews.
Who this course is for:
This Course is for the people who are looking for careers in Cloud database technologies and for Data analysts. You can easily learn all the new concepts of snowflake by practicing the examples I have provided here.

User Reviews

Rating

average 0

Total votes0

Focused display

SQL

Janardhana Reddy

Instructor's Courses

I have more than 10 years of experience in Data Warehousing and Data migration projects by using the ETL tools like Informatica and Datastage. I have very good experience in writing SQL queries and procedures. I have hands-on experience in Shell scripting. After knowing the advantages of Snowflake, the cloud warehouse, I have started learning Snowflake and then Started working on Snowflake projects. Also I am a writer, I have a website janaswritingsdotcom where I write my experience, opinions, stories, quotes, telugu kavithalu etc..

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.