Snowflake[A-Z] Zero to Hero Masterclass(Core+SQL+API+Visual)

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy
Udemy

Course Description

UPSKILL YOURSELF IN THIS PANDEMIC!


************************************************************************************************************

SnowPro Core Certification Practice Test added

- This will help you understand the examination pattern

- Will boost your confidence before attempting the actual examination

************************************************************************************************************


This course is launched in SEPTEMBER 2020 with motive to make you Master on Snowflake Data Warehouse core concepts as well as its APIs, connectors, SQL, etc. This course will also help you to get certified on Snowflake.

This course is providing HIGHEST NUMBER OF CONTENT HOURS to cover each and every aspect related to Snowflake.

In couple of days, this course is marked as "Best Seller" course by Udemy because of:

1.) course content

2.) students feedback

3.) students engagement

4.) prompt instructor responses on QnA

5.) proportion of number of new enrollments as compared to other courses


*****************************************************************************************************************************

----------------------- TAKE THIS COURSE WITH MONEY-BACK GUARANTEE OF 30 DAYS -----------------------

*****************************************************************************************************************************


Snowflake is an in-demand cloud Data Warehouse. It solves most of the problems such as scalability, maintenance and downtime which we used to face with traditional data warehouses.


Using its Modern Architecture and Massive Parallel Processing (MPP) power, many complex problems can be solved within minutes. These days, Data Analysts/Data Scientists/Data Engineers are adopting Snowflake to avoid any maintenance and to pay what they use. Because of its elasticity, they spend less time finding insights from the data stored in Snowflake.

------------------------------------------------------------------------------------------------------------------------------------------------

This course is specially designed for people who are looking forward to learn Snowflake. It does not matter if you are working as a Data Analyst/Data Scientists/Data Engineer/Programmer/BI Expert or as a Student, Data is everywhere so there is a need to process voluminous data to perform day-to-day tasks.

I have tried to include all aspects to perform operations on Snowflake such as:

1.) Snowflake Core concepts
2.) Snowflake Advanced Concepts:
- Time Travel
- Fail Safe
- Zero-Copy Cloning
- Data Sharing
- Query History
- Resource Monitors
- Caching
- Micro-Partitioning
3.) Working with Snowflake APIs using Python
4.) Use Tableau with Snowflake for Visualizations
4.) Use PowerBI with Snowflake for Visualizations
6.) Snowflake SQL - Beginner to Expert Level


A lot of companies are adopting Snowflake as their Data Warehouse and migrating data from disparate sources to it. Because of Snowflake's architecture, companies are saving their costs as Snowflake separates storage and compute costs. Also, you have to pay for what you use on Snowflake. There is no overhead cost on top of it.

Along with this, companies get a lot of advantages with respect to setting up Snowflake.

- They just have to create Snowflake account
- No hardware setup is required
- No software is required to run snowflake
- No installation is needed
- Users does not need to bother about their infrastructure, Snowflake takes care of it perfectly by themselves.
- Snowflake provides default security on data such as encryption of data at rest and in transit.
And many more....


You will get downloadable one-stop-shop for all the resources used in this Masterclass

------------------------------------------------------------------------------------------------------------------------------------------------


******************** By end of this course, you will be able to work as an Snowflake Expert ********************


------------------------------------------------------------------------------------------------------------------------------------------------


\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\

I am sure you would enjoy learning Snowflake with me. :)

In case you don't then you can take benefit of 30 days money-back guarantee within first 30 days and i would be happy to refund your money.

////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////


About Me:

I am Kashish Gakkar, a Senior Data Engineer holding more than 7years of experience. I have experience on various skills and technologies related to:

- ETL
- Data Warehousing
- Data Science/Analytics
- Business Intelligence
- Big Data
- Cloud Technologies : AWS & AZURE
- Programming Expertise : Python, SAS, etc.


--------- HAPPY LEARNING & KEEP GROWING ---------

Who this course is for:

  • Data Engineers who are looking to expand their horizon
  • Data Analysts & Data Scientists: To make data ready on snowflake to perform Analytics on it
  • Any person who is interested to learn Snowflake from Beginner to Expert level
  • Students or any working professionals who are looking for upskilling themselves

Instructor

Data Engineer
  • 4.3 Instructor Rating
  • 1,978 Reviews
  • 15,253 Students
  • 3 Courses

Kashish has over 7 years of experience working in Data Engineering, Data Science and Business Intelligence.

He has great expertise on SAS, SQL, Python, Snowflake, AWS cloud services(EC2, DMS, RDS, S3, LAMBDA), Kafka, etc.

He has great experience in building data pipelines and building data products and services for customers by using advanced analytics.

He has good knowledge on data science and big data technologies.

Expected Outcomes

  1. Core Snowflake Concepts Advanced Concepts such as Time Travel, Fail Safe, Caching, etc. Detailed Overview of Snowflake WebUI SQL - Beginner to Advanced Snowflake API for Python Automate Snowflake tasks using Python How to connect Snowflake Data with Tableau and create visualizations How to connect Snowflake Data with PowerBI and create visualizations Frequent Updates about Snowflake functionalities WILL BE HELPFUL TO GO FOR CERTIFICATION Curated for the Udemy Business collection Course content 34 sections • 230 lectures • 17h 59m total length Expand all sections Introduction 4 lectures • 12min Know your Instructor Preview 00:55 Introduction to Snowflake Preview 02:54 Create Free Snowflake Account Preview 05:40 Download Resources for this course 02:48 Snowflake Introduction 3 questions Deep Dive into Snowflake 5 lectures • 29min Different Roles in Snowflake 06:57 Explore - Databases, Schemas and Tables 05:05 Snowflake Architecture 06:06 Virtual Warehouses (Compute Engine) - Intro 07:19 Virtual Warehouses - Standard vs Economy Scaling policy 03:22 Deep Dive into Snowflake 11 questions Snowflake Pricing 13 lectures • 45min Snowflake Pricing - Introduction Preview 02:23 What are Snowflake Credits 02:02 Snowflake Editions 06:28 Serverless Features cost 00:52 Storage Cost 02:56 Choose Storage type wisely 03:51 Check storage cost for different regions 02:40 Virtual Warehouses - Compute Cost 04:37 Cloud Services Cost 01:02 Data Transfer Cost 01:51 Check consumed CREDITS on your account 05:38 Queries to check consumption 06:11 Optimization Methods to reduce cost 04:14 Snowflake Pricing 2 questions Resource Monitors - Track Compute Consumption 7 lectures • 29min Resource Monitors - Introduction Preview 02:09 Properties of Resource Monitor 04:04 Actions or Triggers of Resource Monitors 03:32 Suspension or Resumption 02:40 Detailed Example - How Resource Monitors work Preview 03:39 Create a Resource Monitor using WebUI 05:22 SQL queries to Create Resource Monitor 08:02 Micro-Partitioning in Snowflake 5 lectures • 20min Partitioning in Traditional Data Warehouses 03:08 Partitioning in Snowflake - Micro Partitioning 03:04 Advantages of Micro-Partitioning 03:35 Structure of Micro-Partition 04:16 Query Processing in Snowflake 06:12 Micro-Partitioning 1 question Clustering in Snowflake 5 lectures • 18min Clustering Introduction 04:10 Clustering Keys 03:00 Clustering Metadata 01:37 Clustering Depth 04:35 Automatic Re-clustering 04:54 Clustering in Snowflake 1 question Query History & Caching 6 lectures • 31min Query History 01:32 Detailed Lab - Query History 15:03 SQL Queries to fetch Query History 03:48 Caching in Snowflake 02:47 Caching - Detailed using Examples Preview 06:17 Lab - Results Cache 01:07 Query History and Caching 1 question Jump into Code 4 lectures • 15min Worksheets - Databases, Schemas, Tables, etc. 06:15 Setting up Context/Parameters for worksheet Preview 02:01 Run first SQL statement 03:37 More about Worksheet's Results section 03:08 Test your knowledge on Worksheets 3 questions Load data from AWS (Amazon Web Services) 16 lectures • 1hr 26min Create Free AWS Account 07:12 What is AWS s3 and how to create buckets under it 03:47 What is IAM (Identity & Access Management) 02:28 Create an IAM Group Preview 01:30 Create IAM User 04:38 Create AWS IAM Role 04:28 Upload data to AWS s3 using web console 04:20 Load Data - 1st Step | Create Table Schema 03:16 Load Data - 2nd Step | Create Integration object - 1 05:27 Load Data - 2nd Step | Create Integration object - 2 02:49 Loading CSV Data to snowflake using COPY command 07:28 Load Complete CSV data from S3 08:32 Load Parquet data - Part 1 05:58 Load Parquet data - Part 2 08:37 View Stages and File formats 06:28 Load JSON Data from AWS S3 08:38 Test your knowledge on Copying Data from AWS S3 8 questions Snowpipe - Continuous Data Ingestion Service 4 lectures • 26min Introduction to Snowpipe Preview 02:10 Load CSV Data from s3 using Snowpipe 10:14 Load PARQUET Data from s3 using Snowpipe 07:34 Load JSON Data from s3 using Snowpipe 06:10 Test your knowledge on Snowpipe 3 questions 24 more sections Requirements Access to a computer with an internet connection. Determination Description UPSKILL YOURSELF IN THIS PANDEMIC! ************************************************************************************************************ SnowPro Core Certification Practice Test added - This will help you understand the examination pattern - Will boost your confidence before attempting the actual examination ************************************************************************************************************ This course is launched in SEPTEMBER 2020 with motive to make you Master on Snowflake Data Warehouse core concepts as well as its APIs, connectors, SQL, etc. This course will also help you to get certified on Snowflake. This course is providing HIGHEST NUMBER OF CONTENT HOURS to cover each and every aspect related to Snowflake. In couple of days, this course is marked as "Best Seller" course by Udemy because of: 1.) course content 2.) students feedback 3.) students engagement 4.) prompt instructor responses on QnA 5.) proportion of number of new enrollments as compared to other courses ***************************************************************************************************************************** ----------------------- TAKE THIS COURSE WITH MONEY-BACK GUARANTEE OF 30 DAYS ----------------------- ***************************************************************************************************************************** Snowflake is an in-demand cloud Data Warehouse. It solves most of the problems such as scalability, maintenance and downtime which we used to face with traditional data warehouses. Using its Modern Architecture and Massive Parallel Processing (MPP) power, many complex problems can be solved within minutes. These days, Data Analysts/Data Scientists/Data Engineers are adopting Snowflake to avoid any maintenance and to pay what they use. Because of its elasticity, they spend less time finding insights from the data stored in Snowflake. ------------------------------------------------------------------------------------------------------------------------------------------------ This course is specially designed for people who are looking forward to learn Snowflake. It does not matter if you are working as a Data Analyst/Data Scientists/Data Engineer/Programmer/BI Expert or as a Student, Data is everywhere so there is a need to process voluminous data to perform day-to-day tasks. I have tried to include all aspects to perform operations on Snowflake such as: 1.) Snowflake Core concepts 2.) Snowflake Advanced Concepts: - Time Travel - Fail Safe - Zero-Copy Cloning - Data Sharing - Query History - Resource Monitors - Caching - Micro-Partitioning 3.) Working with Snowflake APIs using Python 4.) Use Tableau with Snowflake for Visualizations 4.) Use PowerBI with Snowflake for Visualizations 6.) Snowflake SQL - Beginner to Expert Level A lot of companies are adopting Snowflake as their Data Warehouse and migrating data from disparate sources to it. Because of Snowflake's architecture, companies are saving their costs as Snowflake separates storage and compute costs. Also, you have to pay for what you use on Snowflake. There is no overhead cost on top of it. Along with this, companies get a lot of advantages with respect to setting up Snowflake. - They just have to create Snowflake account - No hardware setup is required - No software is required to run snowflake - No installation is needed - Users does not need to bother about their infrastructure, Snowflake takes care of it perfectly by themselves. - Snowflake provides default security on data such as encryption of data at rest and in transit. And many more.... You will get downloadable one-stop-shop for all the resources used in this Masterclass ------------------------------------------------------------------------------------------------------------------------------------------------ ******************** By end of this course, you will be able to work as an Snowflake Expert ******************** ------------------------------------------------------------------------------------------------------------------------------------------------ \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ I am sure you would enjoy learning Snowflake with me. :) In case you don't then you can take benefit of 30 days money-back guarantee within first 30 days and i would be happy to refund your money. //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// About Me: I am Kashish Gakkar , a Senior Data Engineer holding more than 7years of experience. I have experience on various skills and technologies related to: - ETL - Data Warehousing - Data Science/Analytics - Business Intelligence - Big Data - Cloud Technologies : AWS & AZURE - Programming Expertise : Python, SAS, etc. --------- HAPPY LEARNING & KEEP GROWING --------- Who this course is for: Data Engineers who are looking to expand their horizon Data Analysts & Data Scientists: To make data ready on snowflake to perform Analytics on it Any person who is interested to learn Snowflake from Beginner to Expert level Students or any working professionals who are looking for upskilling themselves Show more Show less Instructor Kashish Gakkar Data Engineer 4.3 Instructor Rating 1,978 Reviews 15,253 Students 3 Courses Kashish has over 7 years of experience working in Data Engineering, Data Science and Business Intelligence. He has great expertise on SAS, SQL, Python, Snowflake, AWS cloud services(EC2, DMS, RDS, S3, LAMBDA), Kafka, etc. He has great experience in building data pipelines and building data products and services for customers by using advanced analytics. He has good knowledge on data science and big data technologies. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'677735c46d072c9d',m:'221f2b5bf03b7866637f0953cb5e59bb8ba728ec-1627738529-1800-AZ2iwsOwo9ecHVKsIKIH3w4vScR2+qMMpfi1Bx+/XdqN3sG2Q07FjM1DnzCollHF4eD9F0eUXhPYxt5mD5zXITv6AO5vkVQjgf2XqiNg+73LICnEnzXGz128U0MYGryDJqDXtlS1xO6VNKyXIPdWnysiJdfRO7UHnSlQiMx71CiO',s:[0xd1b94e706e,0x11ce8614f8],}})();
  2. Advanced Concepts such as Time Travel, Fail Safe, Caching, etc. Detailed Overview of Snowflake WebUI SQL - Beginner to Advanced Snowflake API for Python Automate Snowflake tasks using Python How to connect Snowflake Data with Tableau and create visualizations How to connect Snowflake Data with PowerBI and create visualizations Frequent Updates about Snowflake functionalities WILL BE HELPFUL TO GO FOR CERTIFICATION Curated for the Udemy Business collection Course content 34 sections • 230 lectures • 17h 59m total length Expand all sections Introduction 4 lectures • 12min Know your Instructor Preview 00:55 Introduction to Snowflake Preview 02:54 Create Free Snowflake Account Preview 05:40 Download Resources for this course 02:48 Snowflake Introduction 3 questions Deep Dive into Snowflake 5 lectures • 29min Different Roles in Snowflake 06:57 Explore - Databases, Schemas and Tables 05:05 Snowflake Architecture 06:06 Virtual Warehouses (Compute Engine) - Intro 07:19 Virtual Warehouses - Standard vs Economy Scaling policy 03:22 Deep Dive into Snowflake 11 questions Snowflake Pricing 13 lectures • 45min Snowflake Pricing - Introduction Preview 02:23 What are Snowflake Credits 02:02 Snowflake Editions 06:28 Serverless Features cost 00:52 Storage Cost 02:56 Choose Storage type wisely 03:51 Check storage cost for different regions 02:40 Virtual Warehouses - Compute Cost 04:37 Cloud Services Cost 01:02 Data Transfer Cost 01:51 Check consumed CREDITS on your account 05:38 Queries to check consumption 06:11 Optimization Methods to reduce cost 04:14 Snowflake Pricing 2 questions Resource Monitors - Track Compute Consumption 7 lectures • 29min Resource Monitors - Introduction Preview 02:09 Properties of Resource Monitor 04:04 Actions or Triggers of Resource Monitors 03:32 Suspension or Resumption 02:40 Detailed Example - How Resource Monitors work Preview 03:39 Create a Resource Monitor using WebUI 05:22 SQL queries to Create Resource Monitor 08:02 Micro-Partitioning in Snowflake 5 lectures • 20min Partitioning in Traditional Data Warehouses 03:08 Partitioning in Snowflake - Micro Partitioning 03:04 Advantages of Micro-Partitioning 03:35 Structure of Micro-Partition 04:16 Query Processing in Snowflake 06:12 Micro-Partitioning 1 question Clustering in Snowflake 5 lectures • 18min Clustering Introduction 04:10 Clustering Keys 03:00 Clustering Metadata 01:37 Clustering Depth 04:35 Automatic Re-clustering 04:54 Clustering in Snowflake 1 question Query History & Caching 6 lectures • 31min Query History 01:32 Detailed Lab - Query History 15:03 SQL Queries to fetch Query History 03:48 Caching in Snowflake 02:47 Caching - Detailed using Examples Preview 06:17 Lab - Results Cache 01:07 Query History and Caching 1 question Jump into Code 4 lectures • 15min Worksheets - Databases, Schemas, Tables, etc. 06:15 Setting up Context/Parameters for worksheet Preview 02:01 Run first SQL statement 03:37 More about Worksheet's Results section 03:08 Test your knowledge on Worksheets 3 questions Load data from AWS (Amazon Web Services) 16 lectures • 1hr 26min Create Free AWS Account 07:12 What is AWS s3 and how to create buckets under it 03:47 What is IAM (Identity & Access Management) 02:28 Create an IAM Group Preview 01:30 Create IAM User 04:38 Create AWS IAM Role 04:28 Upload data to AWS s3 using web console 04:20 Load Data - 1st Step | Create Table Schema 03:16 Load Data - 2nd Step | Create Integration object - 1 05:27 Load Data - 2nd Step | Create Integration object - 2 02:49 Loading CSV Data to snowflake using COPY command 07:28 Load Complete CSV data from S3 08:32 Load Parquet data - Part 1 05:58 Load Parquet data - Part 2 08:37 View Stages and File formats 06:28 Load JSON Data from AWS S3 08:38 Test your knowledge on Copying Data from AWS S3 8 questions Snowpipe - Continuous Data Ingestion Service 4 lectures • 26min Introduction to Snowpipe Preview 02:10 Load CSV Data from s3 using Snowpipe 10:14 Load PARQUET Data from s3 using Snowpipe 07:34 Load JSON Data from s3 using Snowpipe 06:10 Test your knowledge on Snowpipe 3 questions 24 more sections Requirements Access to a computer with an internet connection. Determination Description UPSKILL YOURSELF IN THIS PANDEMIC! ************************************************************************************************************ SnowPro Core Certification Practice Test added - This will help you understand the examination pattern - Will boost your confidence before attempting the actual examination ************************************************************************************************************ This course is launched in SEPTEMBER 2020 with motive to make you Master on Snowflake Data Warehouse core concepts as well as its APIs, connectors, SQL, etc. This course will also help you to get certified on Snowflake. This course is providing HIGHEST NUMBER OF CONTENT HOURS to cover each and every aspect related to Snowflake. In couple of days, this course is marked as "Best Seller" course by Udemy because of: 1.) course content 2.) students feedback 3.) students engagement 4.) prompt instructor responses on QnA 5.) proportion of number of new enrollments as compared to other courses ***************************************************************************************************************************** ----------------------- TAKE THIS COURSE WITH MONEY-BACK GUARANTEE OF 30 DAYS ----------------------- ***************************************************************************************************************************** Snowflake is an in-demand cloud Data Warehouse. It solves most of the problems such as scalability, maintenance and downtime which we used to face with traditional data warehouses. Using its Modern Architecture and Massive Parallel Processing (MPP) power, many complex problems can be solved within minutes. These days, Data Analysts/Data Scientists/Data Engineers are adopting Snowflake to avoid any maintenance and to pay what they use. Because of its elasticity, they spend less time finding insights from the data stored in Snowflake. ------------------------------------------------------------------------------------------------------------------------------------------------ This course is specially designed for people who are looking forward to learn Snowflake. It does not matter if you are working as a Data Analyst/Data Scientists/Data Engineer/Programmer/BI Expert or as a Student, Data is everywhere so there is a need to process voluminous data to perform day-to-day tasks. I have tried to include all aspects to perform operations on Snowflake such as: 1.) Snowflake Core concepts 2.) Snowflake Advanced Concepts: - Time Travel - Fail Safe - Zero-Copy Cloning - Data Sharing - Query History - Resource Monitors - Caching - Micro-Partitioning 3.) Working with Snowflake APIs using Python 4.) Use Tableau with Snowflake for Visualizations 4.) Use PowerBI with Snowflake for Visualizations 6.) Snowflake SQL - Beginner to Expert Level A lot of companies are adopting Snowflake as their Data Warehouse and migrating data from disparate sources to it. Because of Snowflake's architecture, companies are saving their costs as Snowflake separates storage and compute costs. Also, you have to pay for what you use on Snowflake. There is no overhead cost on top of it. Along with this, companies get a lot of advantages with respect to setting up Snowflake. - They just have to create Snowflake account - No hardware setup is required - No software is required to run snowflake - No installation is needed - Users does not need to bother about their infrastructure, Snowflake takes care of it perfectly by themselves. - Snowflake provides default security on data such as encryption of data at rest and in transit. And many more.... You will get downloadable one-stop-shop for all the resources used in this Masterclass ------------------------------------------------------------------------------------------------------------------------------------------------ ******************** By end of this course, you will be able to work as an Snowflake Expert ******************** ------------------------------------------------------------------------------------------------------------------------------------------------ \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ I am sure you would enjoy learning Snowflake with me. :) In case you don't then you can take benefit of 30 days money-back guarantee within first 30 days and i would be happy to refund your money. //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// About Me: I am Kashish Gakkar , a Senior Data Engineer holding more than 7years of experience. I have experience on various skills and technologies related to: - ETL - Data Warehousing - Data Science/Analytics - Business Intelligence - Big Data - Cloud Technologies : AWS & AZURE - Programming Expertise : Python, SAS, etc. --------- HAPPY LEARNING & KEEP GROWING --------- Who this course is for: Data Engineers who are looking to expand their horizon Data Analysts & Data Scientists: To make data ready on snowflake to perform Analytics on it Any person who is interested to learn Snowflake from Beginner to Expert level Students or any working professionals who are looking for upskilling themselves Show more Show less Instructor Kashish Gakkar Data Engineer 4.3 Instructor Rating 1,978 Reviews 15,253 Students 3 Courses Kashish has over 7 years of experience working in Data Engineering, Data Science and Business Intelligence. He has great expertise on SAS, SQL, Python, Snowflake, AWS cloud services(EC2, DMS, RDS, S3, LAMBDA), Kafka, etc. He has great experience in building data pipelines and building data products and services for customers by using advanced analytics. He has good knowledge on data science and big data technologies. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'677735c46d072c9d',m:'221f2b5bf03b7866637f0953cb5e59bb8ba728ec-1627738529-1800-AZ2iwsOwo9ecHVKsIKIH3w4vScR2+qMMpfi1Bx+/XdqN3sG2Q07FjM1DnzCollHF4eD9F0eUXhPYxt5mD5zXITv6AO5vkVQjgf2XqiNg+73LICnEnzXGz128U0MYGryDJqDXtlS1xO6VNKyXIPdWnysiJdfRO7UHnSlQiMx71CiO',s:[0xd1b94e706e,0x11ce8614f8],}})();
  3. Detailed Overview of Snowflake WebUI SQL - Beginner to Advanced Snowflake API for Python Automate Snowflake tasks using Python How to connect Snowflake Data with Tableau and create visualizations How to connect Snowflake Data with PowerBI and create visualizations Frequent Updates about Snowflake functionalities WILL BE HELPFUL TO GO FOR CERTIFICATION Curated for the Udemy Business collection Course content 34 sections • 230 lectures • 17h 59m total length Expand all sections Introduction 4 lectures • 12min Know your Instructor Preview 00:55 Introduction to Snowflake Preview 02:54 Create Free Snowflake Account Preview 05:40 Download Resources for this course 02:48 Snowflake Introduction 3 questions Deep Dive into Snowflake 5 lectures • 29min Different Roles in Snowflake 06:57 Explore - Databases, Schemas and Tables 05:05 Snowflake Architecture 06:06 Virtual Warehouses (Compute Engine) - Intro 07:19 Virtual Warehouses - Standard vs Economy Scaling policy 03:22 Deep Dive into Snowflake 11 questions Snowflake Pricing 13 lectures • 45min Snowflake Pricing - Introduction Preview 02:23 What are Snowflake Credits 02:02 Snowflake Editions 06:28 Serverless Features cost 00:52 Storage Cost 02:56 Choose Storage type wisely 03:51 Check storage cost for different regions 02:40 Virtual Warehouses - Compute Cost 04:37 Cloud Services Cost 01:02 Data Transfer Cost 01:51 Check consumed CREDITS on your account 05:38 Queries to check consumption 06:11 Optimization Methods to reduce cost 04:14 Snowflake Pricing 2 questions Resource Monitors - Track Compute Consumption 7 lectures • 29min Resource Monitors - Introduction Preview 02:09 Properties of Resource Monitor 04:04 Actions or Triggers of Resource Monitors 03:32 Suspension or Resumption 02:40 Detailed Example - How Resource Monitors work Preview 03:39 Create a Resource Monitor using WebUI 05:22 SQL queries to Create Resource Monitor 08:02 Micro-Partitioning in Snowflake 5 lectures • 20min Partitioning in Traditional Data Warehouses 03:08 Partitioning in Snowflake - Micro Partitioning 03:04 Advantages of Micro-Partitioning 03:35 Structure of Micro-Partition 04:16 Query Processing in Snowflake 06:12 Micro-Partitioning 1 question Clustering in Snowflake 5 lectures • 18min Clustering Introduction 04:10 Clustering Keys 03:00 Clustering Metadata 01:37 Clustering Depth 04:35 Automatic Re-clustering 04:54 Clustering in Snowflake 1 question Query History & Caching 6 lectures • 31min Query History 01:32 Detailed Lab - Query History 15:03 SQL Queries to fetch Query History 03:48 Caching in Snowflake 02:47 Caching - Detailed using Examples Preview 06:17 Lab - Results Cache 01:07 Query History and Caching 1 question Jump into Code 4 lectures • 15min Worksheets - Databases, Schemas, Tables, etc. 06:15 Setting up Context/Parameters for worksheet Preview 02:01 Run first SQL statement 03:37 More about Worksheet's Results section 03:08 Test your knowledge on Worksheets 3 questions Load data from AWS (Amazon Web Services) 16 lectures • 1hr 26min Create Free AWS Account 07:12 What is AWS s3 and how to create buckets under it 03:47 What is IAM (Identity & Access Management) 02:28 Create an IAM Group Preview 01:30 Create IAM User 04:38 Create AWS IAM Role 04:28 Upload data to AWS s3 using web console 04:20 Load Data - 1st Step | Create Table Schema 03:16 Load Data - 2nd Step | Create Integration object - 1 05:27 Load Data - 2nd Step | Create Integration object - 2 02:49 Loading CSV Data to snowflake using COPY command 07:28 Load Complete CSV data from S3 08:32 Load Parquet data - Part 1 05:58 Load Parquet data - Part 2 08:37 View Stages and File formats 06:28 Load JSON Data from AWS S3 08:38 Test your knowledge on Copying Data from AWS S3 8 questions Snowpipe - Continuous Data Ingestion Service 4 lectures • 26min Introduction to Snowpipe Preview 02:10 Load CSV Data from s3 using Snowpipe 10:14 Load PARQUET Data from s3 using Snowpipe 07:34 Load JSON Data from s3 using Snowpipe 06:10 Test your knowledge on Snowpipe 3 questions 24 more sections Requirements Access to a computer with an internet connection. Determination Description UPSKILL YOURSELF IN THIS PANDEMIC! ************************************************************************************************************ SnowPro Core Certification Practice Test added - This will help you understand the examination pattern - Will boost your confidence before attempting the actual examination ************************************************************************************************************ This course is launched in SEPTEMBER 2020 with motive to make you Master on Snowflake Data Warehouse core concepts as well as its APIs, connectors, SQL, etc. This course will also help you to get certified on Snowflake. This course is providing HIGHEST NUMBER OF CONTENT HOURS to cover each and every aspect related to Snowflake. In couple of days, this course is marked as "Best Seller" course by Udemy because of: 1.) course content 2.) students feedback 3.) students engagement 4.) prompt instructor responses on QnA 5.) proportion of number of new enrollments as compared to other courses ***************************************************************************************************************************** ----------------------- TAKE THIS COURSE WITH MONEY-BACK GUARANTEE OF 30 DAYS ----------------------- ***************************************************************************************************************************** Snowflake is an in-demand cloud Data Warehouse. It solves most of the problems such as scalability, maintenance and downtime which we used to face with traditional data warehouses. Using its Modern Architecture and Massive Parallel Processing (MPP) power, many complex problems can be solved within minutes. These days, Data Analysts/Data Scientists/Data Engineers are adopting Snowflake to avoid any maintenance and to pay what they use. Because of its elasticity, they spend less time finding insights from the data stored in Snowflake. ------------------------------------------------------------------------------------------------------------------------------------------------ This course is specially designed for people who are looking forward to learn Snowflake. It does not matter if you are working as a Data Analyst/Data Scientists/Data Engineer/Programmer/BI Expert or as a Student, Data is everywhere so there is a need to process voluminous data to perform day-to-day tasks. I have tried to include all aspects to perform operations on Snowflake such as: 1.) Snowflake Core concepts 2.) Snowflake Advanced Concepts: - Time Travel - Fail Safe - Zero-Copy Cloning - Data Sharing - Query History - Resource Monitors - Caching - Micro-Partitioning 3.) Working with Snowflake APIs using Python 4.) Use Tableau with Snowflake for Visualizations 4.) Use PowerBI with Snowflake for Visualizations 6.) Snowflake SQL - Beginner to Expert Level A lot of companies are adopting Snowflake as their Data Warehouse and migrating data from disparate sources to it. Because of Snowflake's architecture, companies are saving their costs as Snowflake separates storage and compute costs. Also, you have to pay for what you use on Snowflake. There is no overhead cost on top of it. Along with this, companies get a lot of advantages with respect to setting up Snowflake. - They just have to create Snowflake account - No hardware setup is required - No software is required to run snowflake - No installation is needed - Users does not need to bother about their infrastructure, Snowflake takes care of it perfectly by themselves. - Snowflake provides default security on data such as encryption of data at rest and in transit. And many more.... You will get downloadable one-stop-shop for all the resources used in this Masterclass ------------------------------------------------------------------------------------------------------------------------------------------------ ******************** By end of this course, you will be able to work as an Snowflake Expert ******************** ------------------------------------------------------------------------------------------------------------------------------------------------ \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ I am sure you would enjoy learning Snowflake with me. :) In case you don't then you can take benefit of 30 days money-back guarantee within first 30 days and i would be happy to refund your money. //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// About Me: I am Kashish Gakkar , a Senior Data Engineer holding more than 7years of experience. I have experience on various skills and technologies related to: - ETL - Data Warehousing - Data Science/Analytics - Business Intelligence - Big Data - Cloud Technologies : AWS & AZURE - Programming Expertise : Python, SAS, etc. --------- HAPPY LEARNING & KEEP GROWING --------- Who this course is for: Data Engineers who are looking to expand their horizon Data Analysts & Data Scientists: To make data ready on snowflake to perform Analytics on it Any person who is interested to learn Snowflake from Beginner to Expert level Students or any working professionals who are looking for upskilling themselves Show more Show less Instructor Kashish Gakkar Data Engineer 4.3 Instructor Rating 1,978 Reviews 15,253 Students 3 Courses Kashish has over 7 years of experience working in Data Engineering, Data Science and Business Intelligence. He has great expertise on SAS, SQL, Python, Snowflake, AWS cloud services(EC2, DMS, RDS, S3, LAMBDA), Kafka, etc. He has great experience in building data pipelines and building data products and services for customers by using advanced analytics. He has good knowledge on data science and big data technologies. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'677735c46d072c9d',m:'221f2b5bf03b7866637f0953cb5e59bb8ba728ec-1627738529-1800-AZ2iwsOwo9ecHVKsIKIH3w4vScR2+qMMpfi1Bx+/XdqN3sG2Q07FjM1DnzCollHF4eD9F0eUXhPYxt5mD5zXITv6AO5vkVQjgf2XqiNg+73LICnEnzXGz128U0MYGryDJqDXtlS1xO6VNKyXIPdWnysiJdfRO7UHnSlQiMx71CiO',s:[0xd1b94e706e,0x11ce8614f8],}})();
  4. SQL - Beginner to Advanced Snowflake API for Python Automate Snowflake tasks using Python How to connect Snowflake Data with Tableau and create visualizations How to connect Snowflake Data with PowerBI and create visualizations Frequent Updates about Snowflake functionalities WILL BE HELPFUL TO GO FOR CERTIFICATION Curated for the Udemy Business collection Course content 34 sections • 230 lectures • 17h 59m total length Expand all sections Introduction 4 lectures • 12min Know your Instructor Preview 00:55 Introduction to Snowflake Preview 02:54 Create Free Snowflake Account Preview 05:40 Download Resources for this course 02:48 Snowflake Introduction 3 questions Deep Dive into Snowflake 5 lectures • 29min Different Roles in Snowflake 06:57 Explore - Databases, Schemas and Tables 05:05 Snowflake Architecture 06:06 Virtual Warehouses (Compute Engine) - Intro 07:19 Virtual Warehouses - Standard vs Economy Scaling policy 03:22 Deep Dive into Snowflake 11 questions Snowflake Pricing 13 lectures • 45min Snowflake Pricing - Introduction Preview 02:23 What are Snowflake Credits 02:02 Snowflake Editions 06:28 Serverless Features cost 00:52 Storage Cost 02:56 Choose Storage type wisely 03:51 Check storage cost for different regions 02:40 Virtual Warehouses - Compute Cost 04:37 Cloud Services Cost 01:02 Data Transfer Cost 01:51 Check consumed CREDITS on your account 05:38 Queries to check consumption 06:11 Optimization Methods to reduce cost 04:14 Snowflake Pricing 2 questions Resource Monitors - Track Compute Consumption 7 lectures • 29min Resource Monitors - Introduction Preview 02:09 Properties of Resource Monitor 04:04 Actions or Triggers of Resource Monitors 03:32 Suspension or Resumption 02:40 Detailed Example - How Resource Monitors work Preview 03:39 Create a Resource Monitor using WebUI 05:22 SQL queries to Create Resource Monitor 08:02 Micro-Partitioning in Snowflake 5 lectures • 20min Partitioning in Traditional Data Warehouses 03:08 Partitioning in Snowflake - Micro Partitioning 03:04 Advantages of Micro-Partitioning 03:35 Structure of Micro-Partition 04:16 Query Processing in Snowflake 06:12 Micro-Partitioning 1 question Clustering in Snowflake 5 lectures • 18min Clustering Introduction 04:10 Clustering Keys 03:00 Clustering Metadata 01:37 Clustering Depth 04:35 Automatic Re-clustering 04:54 Clustering in Snowflake 1 question Query History & Caching 6 lectures • 31min Query History 01:32 Detailed Lab - Query History 15:03 SQL Queries to fetch Query History 03:48 Caching in Snowflake 02:47 Caching - Detailed using Examples Preview 06:17 Lab - Results Cache 01:07 Query History and Caching 1 question Jump into Code 4 lectures • 15min Worksheets - Databases, Schemas, Tables, etc. 06:15 Setting up Context/Parameters for worksheet Preview 02:01 Run first SQL statement 03:37 More about Worksheet's Results section 03:08 Test your knowledge on Worksheets 3 questions Load data from AWS (Amazon Web Services) 16 lectures • 1hr 26min Create Free AWS Account 07:12 What is AWS s3 and how to create buckets under it 03:47 What is IAM (Identity & Access Management) 02:28 Create an IAM Group Preview 01:30 Create IAM User 04:38 Create AWS IAM Role 04:28 Upload data to AWS s3 using web console 04:20 Load Data - 1st Step | Create Table Schema 03:16 Load Data - 2nd Step | Create Integration object - 1 05:27 Load Data - 2nd Step | Create Integration object - 2 02:49 Loading CSV Data to snowflake using COPY command 07:28 Load Complete CSV data from S3 08:32 Load Parquet data - Part 1 05:58 Load Parquet data - Part 2 08:37 View Stages and File formats 06:28 Load JSON Data from AWS S3 08:38 Test your knowledge on Copying Data from AWS S3 8 questions Snowpipe - Continuous Data Ingestion Service 4 lectures • 26min Introduction to Snowpipe Preview 02:10 Load CSV Data from s3 using Snowpipe 10:14 Load PARQUET Data from s3 using Snowpipe 07:34 Load JSON Data from s3 using Snowpipe 06:10 Test your knowledge on Snowpipe 3 questions 24 more sections Requirements Access to a computer with an internet connection. Determination Description UPSKILL YOURSELF IN THIS PANDEMIC! ************************************************************************************************************ SnowPro Core Certification Practice Test added - This will help you understand the examination pattern - Will boost your confidence before attempting the actual examination ************************************************************************************************************ This course is launched in SEPTEMBER 2020 with motive to make you Master on Snowflake Data Warehouse core concepts as well as its APIs, connectors, SQL, etc. This course will also help you to get certified on Snowflake. This course is providing HIGHEST NUMBER OF CONTENT HOURS to cover each and every aspect related to Snowflake. In couple of days, this course is marked as "Best Seller" course by Udemy because of: 1.) course content 2.) students feedback 3.) students engagement 4.) prompt instructor responses on QnA 5.) proportion of number of new enrollments as compared to other courses ***************************************************************************************************************************** ----------------------- TAKE THIS COURSE WITH MONEY-BACK GUARANTEE OF 30 DAYS ----------------------- ***************************************************************************************************************************** Snowflake is an in-demand cloud Data Warehouse. It solves most of the problems such as scalability, maintenance and downtime which we used to face with traditional data warehouses. Using its Modern Architecture and Massive Parallel Processing (MPP) power, many complex problems can be solved within minutes. These days, Data Analysts/Data Scientists/Data Engineers are adopting Snowflake to avoid any maintenance and to pay what they use. Because of its elasticity, they spend less time finding insights from the data stored in Snowflake. ------------------------------------------------------------------------------------------------------------------------------------------------ This course is specially designed for people who are looking forward to learn Snowflake. It does not matter if you are working as a Data Analyst/Data Scientists/Data Engineer/Programmer/BI Expert or as a Student, Data is everywhere so there is a need to process voluminous data to perform day-to-day tasks. I have tried to include all aspects to perform operations on Snowflake such as: 1.) Snowflake Core concepts 2.) Snowflake Advanced Concepts: - Time Travel - Fail Safe - Zero-Copy Cloning - Data Sharing - Query History - Resource Monitors - Caching - Micro-Partitioning 3.) Working with Snowflake APIs using Python 4.) Use Tableau with Snowflake for Visualizations 4.) Use PowerBI with Snowflake for Visualizations 6.) Snowflake SQL - Beginner to Expert Level A lot of companies are adopting Snowflake as their Data Warehouse and migrating data from disparate sources to it. Because of Snowflake's architecture, companies are saving their costs as Snowflake separates storage and compute costs. Also, you have to pay for what you use on Snowflake. There is no overhead cost on top of it. Along with this, companies get a lot of advantages with respect to setting up Snowflake. - They just have to create Snowflake account - No hardware setup is required - No software is required to run snowflake - No installation is needed - Users does not need to bother about their infrastructure, Snowflake takes care of it perfectly by themselves. - Snowflake provides default security on data such as encryption of data at rest and in transit. And many more.... You will get downloadable one-stop-shop for all the resources used in this Masterclass ------------------------------------------------------------------------------------------------------------------------------------------------ ******************** By end of this course, you will be able to work as an Snowflake Expert ******************** ------------------------------------------------------------------------------------------------------------------------------------------------ \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ I am sure you would enjoy learning Snowflake with me. :) In case you don't then you can take benefit of 30 days money-back guarantee within first 30 days and i would be happy to refund your money. //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// About Me: I am Kashish Gakkar , a Senior Data Engineer holding more than 7years of experience. I have experience on various skills and technologies related to: - ETL - Data Warehousing - Data Science/Analytics - Business Intelligence - Big Data - Cloud Technologies : AWS & AZURE - Programming Expertise : Python, SAS, etc. --------- HAPPY LEARNING & KEEP GROWING --------- Who this course is for: Data Engineers who are looking to expand their horizon Data Analysts & Data Scientists: To make data ready on snowflake to perform Analytics on it Any person who is interested to learn Snowflake from Beginner to Expert level Students or any working professionals who are looking for upskilling themselves Show more Show less Instructor Kashish Gakkar Data Engineer 4.3 Instructor Rating 1,978 Reviews 15,253 Students 3 Courses Kashish has over 7 years of experience working in Data Engineering, Data Science and Business Intelligence. He has great expertise on SAS, SQL, Python, Snowflake, AWS cloud services(EC2, DMS, RDS, S3, LAMBDA), Kafka, etc. He has great experience in building data pipelines and building data products and services for customers by using advanced analytics. He has good knowledge on data science and big data technologies. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'677735c46d072c9d',m:'221f2b5bf03b7866637f0953cb5e59bb8ba728ec-1627738529-1800-AZ2iwsOwo9ecHVKsIKIH3w4vScR2+qMMpfi1Bx+/XdqN3sG2Q07FjM1DnzCollHF4eD9F0eUXhPYxt5mD5zXITv6AO5vkVQjgf2XqiNg+73LICnEnzXGz128U0MYGryDJqDXtlS1xO6VNKyXIPdWnysiJdfRO7UHnSlQiMx71CiO',s:[0xd1b94e706e,0x11ce8614f8],}})();
  5. Snowflake API for Python Automate Snowflake tasks using Python How to connect Snowflake Data with Tableau and create visualizations How to connect Snowflake Data with PowerBI and create visualizations Frequent Updates about Snowflake functionalities WILL BE HELPFUL TO GO FOR CERTIFICATION Curated for the Udemy Business collection Course content 34 sections • 230 lectures • 17h 59m total length Expand all sections Introduction 4 lectures • 12min Know your Instructor Preview 00:55 Introduction to Snowflake Preview 02:54 Create Free Snowflake Account Preview 05:40 Download Resources for this course 02:48 Snowflake Introduction 3 questions Deep Dive into Snowflake 5 lectures • 29min Different Roles in Snowflake 06:57 Explore - Databases, Schemas and Tables 05:05 Snowflake Architecture 06:06 Virtual Warehouses (Compute Engine) - Intro 07:19 Virtual Warehouses - Standard vs Economy Scaling policy 03:22 Deep Dive into Snowflake 11 questions Snowflake Pricing 13 lectures • 45min Snowflake Pricing - Introduction Preview 02:23 What are Snowflake Credits 02:02 Snowflake Editions 06:28 Serverless Features cost 00:52 Storage Cost 02:56 Choose Storage type wisely 03:51 Check storage cost for different regions 02:40 Virtual Warehouses - Compute Cost 04:37 Cloud Services Cost 01:02 Data Transfer Cost 01:51 Check consumed CREDITS on your account 05:38 Queries to check consumption 06:11 Optimization Methods to reduce cost 04:14 Snowflake Pricing 2 questions Resource Monitors - Track Compute Consumption 7 lectures • 29min Resource Monitors - Introduction Preview 02:09 Properties of Resource Monitor 04:04 Actions or Triggers of Resource Monitors 03:32 Suspension or Resumption 02:40 Detailed Example - How Resource Monitors work Preview 03:39 Create a Resource Monitor using WebUI 05:22 SQL queries to Create Resource Monitor 08:02 Micro-Partitioning in Snowflake 5 lectures • 20min Partitioning in Traditional Data Warehouses 03:08 Partitioning in Snowflake - Micro Partitioning 03:04 Advantages of Micro-Partitioning 03:35 Structure of Micro-Partition 04:16 Query Processing in Snowflake 06:12 Micro-Partitioning 1 question Clustering in Snowflake 5 lectures • 18min Clustering Introduction 04:10 Clustering Keys 03:00 Clustering Metadata 01:37 Clustering Depth 04:35 Automatic Re-clustering 04:54 Clustering in Snowflake 1 question Query History & Caching 6 lectures • 31min Query History 01:32 Detailed Lab - Query History 15:03 SQL Queries to fetch Query History 03:48 Caching in Snowflake 02:47 Caching - Detailed using Examples Preview 06:17 Lab - Results Cache 01:07 Query History and Caching 1 question Jump into Code 4 lectures • 15min Worksheets - Databases, Schemas, Tables, etc. 06:15 Setting up Context/Parameters for worksheet Preview 02:01 Run first SQL statement 03:37 More about Worksheet's Results section 03:08 Test your knowledge on Worksheets 3 questions Load data from AWS (Amazon Web Services) 16 lectures • 1hr 26min Create Free AWS Account 07:12 What is AWS s3 and how to create buckets under it 03:47 What is IAM (Identity & Access Management) 02:28 Create an IAM Group Preview 01:30 Create IAM User 04:38 Create AWS IAM Role 04:28 Upload data to AWS s3 using web console 04:20 Load Data - 1st Step | Create Table Schema 03:16 Load Data - 2nd Step | Create Integration object - 1 05:27 Load Data - 2nd Step | Create Integration object - 2 02:49 Loading CSV Data to snowflake using COPY command 07:28 Load Complete CSV data from S3 08:32 Load Parquet data - Part 1 05:58 Load Parquet data - Part 2 08:37 View Stages and File formats 06:28 Load JSON Data from AWS S3 08:38 Test your knowledge on Copying Data from AWS S3 8 questions Snowpipe - Continuous Data Ingestion Service 4 lectures • 26min Introduction to Snowpipe Preview 02:10 Load CSV Data from s3 using Snowpipe 10:14 Load PARQUET Data from s3 using Snowpipe 07:34 Load JSON Data from s3 using Snowpipe 06:10 Test your knowledge on Snowpipe 3 questions 24 more sections Requirements Access to a computer with an internet connection. Determination Description UPSKILL YOURSELF IN THIS PANDEMIC! ************************************************************************************************************ SnowPro Core Certification Practice Test added - This will help you understand the examination pattern - Will boost your confidence before attempting the actual examination ************************************************************************************************************ This course is launched in SEPTEMBER 2020 with motive to make you Master on Snowflake Data Warehouse core concepts as well as its APIs, connectors, SQL, etc. This course will also help you to get certified on Snowflake. This course is providing HIGHEST NUMBER OF CONTENT HOURS to cover each and every aspect related to Snowflake. In couple of days, this course is marked as "Best Seller" course by Udemy because of: 1.) course content 2.) students feedback 3.) students engagement 4.) prompt instructor responses on QnA 5.) proportion of number of new enrollments as compared to other courses ***************************************************************************************************************************** ----------------------- TAKE THIS COURSE WITH MONEY-BACK GUARANTEE OF 30 DAYS ----------------------- ***************************************************************************************************************************** Snowflake is an in-demand cloud Data Warehouse. It solves most of the problems such as scalability, maintenance and downtime which we used to face with traditional data warehouses. Using its Modern Architecture and Massive Parallel Processing (MPP) power, many complex problems can be solved within minutes. These days, Data Analysts/Data Scientists/Data Engineers are adopting Snowflake to avoid any maintenance and to pay what they use. Because of its elasticity, they spend less time finding insights from the data stored in Snowflake. ------------------------------------------------------------------------------------------------------------------------------------------------ This course is specially designed for people who are looking forward to learn Snowflake. It does not matter if you are working as a Data Analyst/Data Scientists/Data Engineer/Programmer/BI Expert or as a Student, Data is everywhere so there is a need to process voluminous data to perform day-to-day tasks. I have tried to include all aspects to perform operations on Snowflake such as: 1.) Snowflake Core concepts 2.) Snowflake Advanced Concepts: - Time Travel - Fail Safe - Zero-Copy Cloning - Data Sharing - Query History - Resource Monitors - Caching - Micro-Partitioning 3.) Working with Snowflake APIs using Python 4.) Use Tableau with Snowflake for Visualizations 4.) Use PowerBI with Snowflake for Visualizations 6.) Snowflake SQL - Beginner to Expert Level A lot of companies are adopting Snowflake as their Data Warehouse and migrating data from disparate sources to it. Because of Snowflake's architecture, companies are saving their costs as Snowflake separates storage and compute costs. Also, you have to pay for what you use on Snowflake. There is no overhead cost on top of it. Along with this, companies get a lot of advantages with respect to setting up Snowflake. - They just have to create Snowflake account - No hardware setup is required - No software is required to run snowflake - No installation is needed - Users does not need to bother about their infrastructure, Snowflake takes care of it perfectly by themselves. - Snowflake provides default security on data such as encryption of data at rest and in transit. And many more.... You will get downloadable one-stop-shop for all the resources used in this Masterclass ------------------------------------------------------------------------------------------------------------------------------------------------ ******************** By end of this course, you will be able to work as an Snowflake Expert ******************** ------------------------------------------------------------------------------------------------------------------------------------------------ \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ I am sure you would enjoy learning Snowflake with me. :) In case you don't then you can take benefit of 30 days money-back guarantee within first 30 days and i would be happy to refund your money. //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// About Me: I am Kashish Gakkar , a Senior Data Engineer holding more than 7years of experience. I have experience on various skills and technologies related to: - ETL - Data Warehousing - Data Science/Analytics - Business Intelligence - Big Data - Cloud Technologies : AWS & AZURE - Programming Expertise : Python, SAS, etc. --------- HAPPY LEARNING & KEEP GROWING --------- Who this course is for: Data Engineers who are looking to expand their horizon Data Analysts & Data Scientists: To make data ready on snowflake to perform Analytics on it Any person who is interested to learn Snowflake from Beginner to Expert level Students or any working professionals who are looking for upskilling themselves Show more Show less Instructor Kashish Gakkar Data Engineer 4.3 Instructor Rating 1,978 Reviews 15,253 Students 3 Courses Kashish has over 7 years of experience working in Data Engineering, Data Science and Business Intelligence. He has great expertise on SAS, SQL, Python, Snowflake, AWS cloud services(EC2, DMS, RDS, S3, LAMBDA), Kafka, etc. He has great experience in building data pipelines and building data products and services for customers by using advanced analytics. He has good knowledge on data science and big data technologies. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'677735c46d072c9d',m:'221f2b5bf03b7866637f0953cb5e59bb8ba728ec-1627738529-1800-AZ2iwsOwo9ecHVKsIKIH3w4vScR2+qMMpfi1Bx+/XdqN3sG2Q07FjM1DnzCollHF4eD9F0eUXhPYxt5mD5zXITv6AO5vkVQjgf2XqiNg+73LICnEnzXGz128U0MYGryDJqDXtlS1xO6VNKyXIPdWnysiJdfRO7UHnSlQiMx71CiO',s:[0xd1b94e706e,0x11ce8614f8],}})();
  6. Automate Snowflake tasks using Python How to connect Snowflake Data with Tableau and create visualizations How to connect Snowflake Data with PowerBI and create visualizations Frequent Updates about Snowflake functionalities WILL BE HELPFUL TO GO FOR CERTIFICATION Curated for the Udemy Business collection Course content 34 sections • 230 lectures • 17h 59m total length Expand all sections Introduction 4 lectures • 12min Know your Instructor Preview 00:55 Introduction to Snowflake Preview 02:54 Create Free Snowflake Account Preview 05:40 Download Resources for this course 02:48 Snowflake Introduction 3 questions Deep Dive into Snowflake 5 lectures • 29min Different Roles in Snowflake 06:57 Explore - Databases, Schemas and Tables 05:05 Snowflake Architecture 06:06 Virtual Warehouses (Compute Engine) - Intro 07:19 Virtual Warehouses - Standard vs Economy Scaling policy 03:22 Deep Dive into Snowflake 11 questions Snowflake Pricing 13 lectures • 45min Snowflake Pricing - Introduction Preview 02:23 What are Snowflake Credits 02:02 Snowflake Editions 06:28 Serverless Features cost 00:52 Storage Cost 02:56 Choose Storage type wisely 03:51 Check storage cost for different regions 02:40 Virtual Warehouses - Compute Cost 04:37 Cloud Services Cost 01:02 Data Transfer Cost 01:51 Check consumed CREDITS on your account 05:38 Queries to check consumption 06:11 Optimization Methods to reduce cost 04:14 Snowflake Pricing 2 questions Resource Monitors - Track Compute Consumption 7 lectures • 29min Resource Monitors - Introduction Preview 02:09 Properties of Resource Monitor 04:04 Actions or Triggers of Resource Monitors 03:32 Suspension or Resumption 02:40 Detailed Example - How Resource Monitors work Preview 03:39 Create a Resource Monitor using WebUI 05:22 SQL queries to Create Resource Monitor 08:02 Micro-Partitioning in Snowflake 5 lectures • 20min Partitioning in Traditional Data Warehouses 03:08 Partitioning in Snowflake - Micro Partitioning 03:04 Advantages of Micro-Partitioning 03:35 Structure of Micro-Partition 04:16 Query Processing in Snowflake 06:12 Micro-Partitioning 1 question Clustering in Snowflake 5 lectures • 18min Clustering Introduction 04:10 Clustering Keys 03:00 Clustering Metadata 01:37 Clustering Depth 04:35 Automatic Re-clustering 04:54 Clustering in Snowflake 1 question Query History & Caching 6 lectures • 31min Query History 01:32 Detailed Lab - Query History 15:03 SQL Queries to fetch Query History 03:48 Caching in Snowflake 02:47 Caching - Detailed using Examples Preview 06:17 Lab - Results Cache 01:07 Query History and Caching 1 question Jump into Code 4 lectures • 15min Worksheets - Databases, Schemas, Tables, etc. 06:15 Setting up Context/Parameters for worksheet Preview 02:01 Run first SQL statement 03:37 More about Worksheet's Results section 03:08 Test your knowledge on Worksheets 3 questions Load data from AWS (Amazon Web Services) 16 lectures • 1hr 26min Create Free AWS Account 07:12 What is AWS s3 and how to create buckets under it 03:47 What is IAM (Identity & Access Management) 02:28 Create an IAM Group Preview 01:30 Create IAM User 04:38 Create AWS IAM Role 04:28 Upload data to AWS s3 using web console 04:20 Load Data - 1st Step | Create Table Schema 03:16 Load Data - 2nd Step | Create Integration object - 1 05:27 Load Data - 2nd Step | Create Integration object - 2 02:49 Loading CSV Data to snowflake using COPY command 07:28 Load Complete CSV data from S3 08:32 Load Parquet data - Part 1 05:58 Load Parquet data - Part 2 08:37 View Stages and File formats 06:28 Load JSON Data from AWS S3 08:38 Test your knowledge on Copying Data from AWS S3 8 questions Snowpipe - Continuous Data Ingestion Service 4 lectures • 26min Introduction to Snowpipe Preview 02:10 Load CSV Data from s3 using Snowpipe 10:14 Load PARQUET Data from s3 using Snowpipe 07:34 Load JSON Data from s3 using Snowpipe 06:10 Test your knowledge on Snowpipe 3 questions 24 more sections Requirements Access to a computer with an internet connection. Determination Description UPSKILL YOURSELF IN THIS PANDEMIC! ************************************************************************************************************ SnowPro Core Certification Practice Test added - This will help you understand the examination pattern - Will boost your confidence before attempting the actual examination ************************************************************************************************************ This course is launched in SEPTEMBER 2020 with motive to make you Master on Snowflake Data Warehouse core concepts as well as its APIs, connectors, SQL, etc. This course will also help you to get certified on Snowflake. This course is providing HIGHEST NUMBER OF CONTENT HOURS to cover each and every aspect related to Snowflake. In couple of days, this course is marked as "Best Seller" course by Udemy because of: 1.) course content 2.) students feedback 3.) students engagement 4.) prompt instructor responses on QnA 5.) proportion of number of new enrollments as compared to other courses ***************************************************************************************************************************** ----------------------- TAKE THIS COURSE WITH MONEY-BACK GUARANTEE OF 30 DAYS ----------------------- ***************************************************************************************************************************** Snowflake is an in-demand cloud Data Warehouse. It solves most of the problems such as scalability, maintenance and downtime which we used to face with traditional data warehouses. Using its Modern Architecture and Massive Parallel Processing (MPP) power, many complex problems can be solved within minutes. These days, Data Analysts/Data Scientists/Data Engineers are adopting Snowflake to avoid any maintenance and to pay what they use. Because of its elasticity, they spend less time finding insights from the data stored in Snowflake. ------------------------------------------------------------------------------------------------------------------------------------------------ This course is specially designed for people who are looking forward to learn Snowflake. It does not matter if you are working as a Data Analyst/Data Scientists/Data Engineer/Programmer/BI Expert or as a Student, Data is everywhere so there is a need to process voluminous data to perform day-to-day tasks. I have tried to include all aspects to perform operations on Snowflake such as: 1.) Snowflake Core concepts 2.) Snowflake Advanced Concepts: - Time Travel - Fail Safe - Zero-Copy Cloning - Data Sharing - Query History - Resource Monitors - Caching - Micro-Partitioning 3.) Working with Snowflake APIs using Python 4.) Use Tableau with Snowflake for Visualizations 4.) Use PowerBI with Snowflake for Visualizations 6.) Snowflake SQL - Beginner to Expert Level A lot of companies are adopting Snowflake as their Data Warehouse and migrating data from disparate sources to it. Because of Snowflake's architecture, companies are saving their costs as Snowflake separates storage and compute costs. Also, you have to pay for what you use on Snowflake. There is no overhead cost on top of it. Along with this, companies get a lot of advantages with respect to setting