05 Jan 19 · npack · #snowflake ·   Bookmark  

×

Snowflake Training / Course

Now that you are convinced Cloud Data warehouse is for real, How do I get started? The internet has tons of free resources for getting started in Data Warehousing. Feeling overwhelmed with too much information and chaos that we don't know exactly where to start or what to read. Beginners need a small end-to-end project to grasp the principles

This course is exactly tailored for you to get started with Snowflake Cloud Data Warehousing, what you will learn with this snowflake training:

  • Understand Data Warehousing in general and its best practices
  • Understand Dimensional modeling used in Data Warehousing
  • Understand the basics of Cloud and the Cloud Data Warehousing
  • Understand Snowflake Data Warehouse Architecture and its functions
  • Practice Real-world end-to-end projects
  • Help you build your portfolio and provide free access to this helpful community where thousands of other beginners and pros and hacking together

The Snowflake Course has two real end-to-end projects that you can work on from your laptop and it would give you a good intro to the data Warehousing concepts.

Data Warehousing Myths:

Before we begin our journey, let us bust some myths about machine learning and spread some positive vibes:

  • You do not have to understand everything. Gulping in all the data modeling, data analysis can be overwhelming. So do not try to take them all at once, its okay if you don't get it in the first place, just move on with the tutorial you will learn organically.
  • You do not need that Ph.D. degree in statistics to be a Data engineer and you do not have to understand all the intrinsic mechanisms.
  • You do not need to be a SQL Developer. The syntax of the SQL is intuitive. Try to relate and understand the code, This will get you most of the way. So, Just get started and dive into the details later

What is Cloud Data Warehousing?

A data warehouse is a system that pulls together data from many different sources within an organization for reporting and analysis. The data warehouse is then used by the management to generate reports that aid decision making.

Cloud Data Warehouse is the process of building a highly scalable, highly resilient organizational data store on the cloud. There are several cloud data warehouse solutions including Snowflake, Amazon Redshift, Google BigQuery, ...

How Data Warehousing is different from Data Science?

Data Warehouse is all about bringing the organization's data in one place, a single version of truth the company can use for its analytics. Whereas Data Science involves using platforms like Data Warehouse and doing predictive analytics.

Data Warehouse can serve,

  • For traditional reporting - Tableau, Cognos, BO Reports
  • For Predictive analytics / Machine learning
  • Data exploration/mining with tools like SAS, R, Python

So, A Data Warehouse is a company's asset which can serve for retrospective reporting as well as aid as a platform for predictive reporting as well.

Check out the Snowflake Course

npack

posted on 05 Jan 19

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds




Hi Can you suggest any Certification is available for snowflake?Any lab access for snowflake handson?

Snowflake does offer certifications, Find more details are on their site.
There is no trial or lab access to try Snowflake as far as i know

Hi Naveen,Thanks for your reply.What would be best option to learn Snowflake with hands on?I have good experience in ETL planing to switch the carrier into snowflake..Can you please suggest the options to started getting into snowflake?

You can get started with the free course on copycoding. Since you are into ETL, I assume you might have some prior experience in any of the MPP databases. You should be able to pick up snowflake easily. But if you want to do some hands-on, i am afraid there is no easy way to do it. The trial on the snowflake site is for companies and not developers. Ill very soon spin up a Snowflake instance for developers to learn / practice. I might bundle it with some kind of product / course. So keep an eye on the site for updates


Powered by Hittly.com
Copied