Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Personal Transformation Meditation Life Purpose Coaching Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
2020-12-04 11:06:36
30-Day Money-Back Guarantee

This course includes:

  • 14.5 hours on-demand video
  • 103 downloadable resources
  • 1 practice test
  • 1 coding exercise
  • Full lifetime access
  • Access on mobile and TV
Development Database Design & Development Snowflake

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

Snowflake Masterclass launched in SEP 2020, Highest CONTENT HOURS to make you EXPERT on Snowflake Datawarehouse concept
Bestseller
Rating: 4.3 out of 54.3 (411 ratings)
2,641 students
Created by Kashish Gakkar
Last updated 12/2020
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • 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 for Business collection

Course content

27 sections • 177 lectures • 14h 43m total length

  • Preview00:55
  • Preview02:54
  • Preview05:40
  • Download Resources for this course
    02:48
  • Snowflake Introduction
    2 questions

  • 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
    5 questions

  • Preview02: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

  • Preview02:09
  • Properties of Resource Monitor
    04:04
  • Actions or Triggers of Resource Monitors
    03:32
  • Suspension or Resumption
    02:40
  • Preview03:39
  • Create a Resource Monitor using WebUI
    05:22
  • SQL queries to Create Resource Monitor
    08:02

  • 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
  • Preview06:12

  • Clustering Introduction
    04:10
  • Clustering Keys
    03:00
  • Clustering Metadata
    01:37
  • Clustering Depth
    04:35
  • Automatic Re-clustering
    04:54

  • Query History
    01:32
  • Detailed Lab - Query History
    15:03
  • SQL Queries to fetch Query History
    03:48
  • Caching in Snowflake
    02:47
  • Preview06:17
  • Lab - Results Cache
    01:07

  • Worksheets - Databases, Schemas, Tables, etc.
    06:15
  • Preview02:01
  • Run first SQL statement
    03:37
  • More about Worksheet's Results section
    03:08
  • Test your knowledge on Worksheets
    3 questions

  • 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
  • Preview01: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
    4 questions

  • Preview02: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
    2 questions

Requirements

  • Access to a computer with an internet connection.
  • Determination

Description

UPSKILL YOURSELF IN THIS PANDEMIC!


This course is launched in SEPTEMBER 2020 with motive to make you Master on Snowflake Datawarehouse 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

Kashish Gakkar
Data Engineer
Kashish Gakkar
  • 4.3 Instructor Rating
  • 689 Reviews
  • 6,617 Students
  • 2 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.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.