05 January 2019 ยท n-pacha ยท       Add to Favorites   Report

Learn Snowflake from Scratch - The Ultimate Course

"Learn Snowflake from Scratch" has been the go-to video resource for all cloud data warehouse newcomers. The course has been created step-by-step for any beginner to gradually grasp and get started. I repeatedly refresh the series to ensure that it remains as up-to-date as possible. I hope you enjoy it!

And if you're brand new to Snowflake, you're in for a treat. Snowflake is a joy to work with. If you're willing, I'll teach you everything I know.

Course Index:

  1. Intro
    ๐ŸŽฌ Episode:1 โŒ› Runtime: 0:53   ๐ŸŽ Free
    Hello and welcome to the course. start here!

  2. Let's tour the snowflake user interface
    ๐ŸŽฌ Episode:2   โŒ› Runtime: 8:37   ๐ŸŽ Free
    Let's start with the fun part: Touring the user interface. In this lesson, you will get acquainted with the snowflake web user interface and its various options. 

  3. Setup the environment
    ๐ŸŽฌ Episode:3 โŒ› Runtime: 5:34 ๐ŸŽ Free
    We will create the virtual warehouse, database, and the schema

  4. Basics of cloud and saas
    ๐ŸŽฌ Episode:4 โŒ› Runtime: 5:59 ๐ŸŽ Free
    Understand the basics of cloud and its difference between traditional on-premise data warehouse. Discuss the SAAS model and how its different from regular software

  5. Snowflake Overview
    ๐ŸŽฌ Episode:5 โŒ› Runtime: 9:29 ๐ŸŽ Free
    Introduction to snowflake and hows it is different from existing solutions available

  6. Install SnowSQL
    ๐ŸŽฌ Episode:6 โŒ› Runtime: 9:08 ๐ŸŽ Free
    Download, Install, Configure SnowSQL client and query the database

  7. Snowflake Architecture
    ๐ŸŽฌ Episode:7 โŒ› Runtime: 5:13 ๐ŸŽ Free
    Let us look at the architecture in detail and its benefits

  8. Load Data using SnowSQL
    ๐ŸŽฌ Episode:8 โŒ› Runtime: 8:09 ๐Ÿ‘ช Membership
    Load data from local to snowflake using the snowsql client

  9. Unload Data using SnowSQL
    ๐ŸŽฌ Episode:9 โŒ› Runtime: 8:35
    Export data from snowflake to a file and then unload the file to our local desktop
     

<This is a Work in progress - I will keep adding more episodes as I create>

Share your thought in the comments

n-pacha

posted on 05 January 2019

Read great educational content like this and a lot more !

Members get free exclusive access to content, new courses, and discounts. Signup for a free account to write a post / comment / upvote posts. Creating an account takes less than 5 seconds and you can start earning badges & points too




  • Can you please share few real time used cases with Snowflake cloud data

    Paddy on 03 January 2019 ยท report ยท 

  • Snowflake claims they do support real time ingestion of streaming data. I am not familiar with any real time consumption use cases, like running a web api. IMO Snowflake is more of a analytics system and less of a transactional system

    n-pacha on 07 January 2019 ยท report ยท 

  • Does it required any prior DWH experience like informatica or datastage. i dont have both. i have experience on SQL and knowledge on DWH> how is the job scope in india.

    srinuy022018 on 23 January 2019 ยท report ยท 

  • Since you already have SQL Background, I would say you are one step ahead. Its very easy to learn and pickup Snowflake. Not to mention Snowflake is growing huge, Its gaining popularity and has acquired lots of new customers.

    n-pacha on 24 January 2019 ยท report ยท 

  • Hi Naveen, Many thanks for your episodes on SnowFlake, they are very precise and easy to understand. I have been working DWH, Big Data for past 15 years and planning to switch to Snowflake and Cloud. Kindly help us in sharing real use cases with Snowflake. Can i have your personal email/contact sent to my email: n.maddineni.rao@gmail.com to discuss my need in more detail? Thank you, Nagesh

    nmaddineni on 03 February 2019 ยท report ยท 

  • Thanks very much for the feedback @nmaddineni

    n-pacha on 01 April 2019 ยท report ยท 


โšก Powered by Hittly.com
Copied