Snowflake L2

Home Introduction Web UI Tour Setup SAAS Basics Snowflake Overview SnowSQL Architecture Loading Data Unloading Data

Home » Snowflake

Bookmark · Report · More actions.. Lock comments · Pin thread

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:

Intro
🎬 Episode:1 ⌛ Runtime: 0:53 🎁 Free
Hello and welcome to the course. start here!
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.
Setup the environment
🎬 Episode:3 ⌛ Runtime: 5:34 🎁 Free
We will create the virtual warehouse, database, and the schema
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
Snowflake Overview
🎬 Episode:5 ⌛ Runtime: 9:29 🎁 Free
Introduction to snowflake and hows it is different from existing solutions available
Install SnowSQL
🎬 Episode:6 ⌛ Runtime: 9:08 🎁 Free
Download, Install, Configure SnowSQL client and query the database
Snowflake Architecture
🎬 Episode:7 ⌛ Runtime: 5:13 🎁 Free
Let us look at the architecture in detail and its benefits
Load Data using SnowSQL
🎬 Episode:8 ⌛ Runtime: 8:09 👪 Membership
Load data from local to snowflake using the snowsql client
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

Next Tutorial ▶

Post Comment

Paddy03-Jan-19

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

ReplyMore..ReportDelete

nVector07-Jan-19

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

ReplyMore..ReportDelete

srinuy02201823-Jan-19

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.

ReplyMore..ReportDelete

nVector24-Jan-19

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.

ReplyMore..ReportDelete

nmaddineni03-Feb-19

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

ReplyMore..ReportDelete

nVector01-Apr-19

Thanks very much for the feedback @nmaddineni

ReplyMore..ReportDelete

GopiB18-Jul-19

Kindly share your personal email/contact sent to my email: gopimstr@gmail.com to discuss snowflake course

ReplyMore..ReportDelete

nVector14-Aug-19

@gopib can you shoot your questions here or on the chat channel if it could benefit others

ReplyMore..ReportDelete

pramakrishna88917-Aug-19

Hi Naveen ,

Thanks for your Videos.. When we Can expect more videos continuation to this..? and also please let me know what kind of roles and responsibilities will have snowflake developers..?

Thanks,

Ramakrishna

ReplyMore..ReportDelete

nVector18-Aug-19

@pramakrishna89 You are welcome. What kind of videos would you like me to cover ?

ReplyMore..ReportDelete

Rhea706-Sep-19

Tips on creating Stored Procedures can help !

ReplyMore..ReportDelete

nVector07-Sep-19

@Rhea7 Sure, The problem is writing stored procedures in Java or python. I wish they come up with SQL support. The plan is cover basic topics like ddl, dml, dcl operations first, followed by advanced topics

ReplyMore..ReportDelete

slakkara-buffalo-edu22-May-20

thanks Naveen for this introduction. We are on SSIS/Cognos reporing stack till date and building the entire system in Attunity/Snowflake/PowerBI stack on Microsoft Azure.

these videos gave the introduction and as you mentioned above it will be great if you can give a pointer for advanced topics like stored procs or any other entities we can use in Snowflake.

ReplyMore..ReportDelete

Mahesh-Mateti12-Sep-19

Hi, I dono how I can say thankful to you. I was enquiring snowflake as I am doing aws n redshift. I want to know which cover redshift or snowflake in aws for more jobs. Also I need more videos for this snowflake. Thanks again again. email: mahe.mateti@gmail.com

ReplyMore..ReportDelete

nVector13-Sep-19

Snowflake is the new cool kid in the town. If you are just getting started, go with snowflake, you wouldnt regret

ReplyMore..ReportDelete

AzharuddinK18-Apr-20

More Videos on Unloading the data to AWS S3 and Loading the data from AWS S3 to Snowflake

ReplyMore..ReportDelete

Sreenivasulu22-Apr-20

Upload more videos about snowflake

ReplyMore..ReportDelete

nVector22-Apr-20

I may do more videos shortly, keep an eye

ReplyMore..ReportDelete

Ramana13-Jun-20

Could you pls upload some more videos. Thanks in advance.

ReplyMore..ReportDelete

nVector14-Jun-20

Sure. What kind of topics do you want me to cover ?

ReplyMore..ReportDelete

prem-g09-Oct-20

Could you please let us know what else we should learn for grabbing jobs on SnowFlake.

ReplyMore..ReportDelete

nVector09-Oct-20

Strong data warehouse fundamentals, snowflake basics like loading data and loading data, architecture and tips and tricks for performance tuning

ReplyMore..ReportDelete

Sravanic17-Nov-20

I recently did AWS associate developer certification so can u please tell me doing snowflake certification will be helpful for me to get a job.

ReplyMore..ReportDelete

nVector17-Nov-20

Snowflake Certification would be a value add for sure, Although not a deal maker. If you have strong SQL Fundamentals and good working knowledge in Snowflake. You should try giving a job interview

ReplyMore..ReportDelete

Ramana22-Jan-21

Hi Naveen,

Where can i purchase your complete snowflake training course? Please mail me the details on mvrswamy09@gmail.com if you anything as such to buy.

Thanks,

Ramana.

ReplyMore..ReportDelete

nVector26-Jan-21

I don't have any paid course. All of my content is available for free on this site

ReplyMore..ReportDelete

SkyRathod14-Apr-21

Hello Naveen,

I just completed this course of yours on Udemy. It was a very informative course. Thank you for your wonderful time and effort for creating such.

I wanted to know, as you mentioned in that course, are you having a more detailed training course on the same. If yes, I would really look forward to enrol in the same (also if there are any paid courses).

I'll just drop my email id "aakashsampleacc@gmail.com", can you share the details to it if you have any. Or any recommendations to get in-dept knowledge & training on Snowflake.

Thank you😃

ReplyMore..ReportDelete