User Avatar

Snowflake beginner course

4 weeks
All levels
96 lessons
0 quiz
1 student

Snowflake logo

Master the Fundamental Snowflake concepts & acquire the necessary skills to start implementing Snowflake based solutions

What you’ll learn

  • Snowflake Essentials, it’s unique architecture & its differentiation
  • Scalability through the virtual warehouse compute clusters
  • Staging & Ingesting bulk & streaming data from cloud storage
  • Unique features such as zero copy clones, time travel
  • Snowflake value proposition through its pricing model
  • Secure data sharing with snowflake & non-snowflake users

Who this course is for:

  • You already have the basic knowledge of databases and SQL
  • If you are a Data Engineer or ETL Developer, you want to learn how snowflake can elevate your career
  • If you are an architect who wants to design and deliver a snowflake datawarehouse
  • If you are an experienced software/IT professional with knowledge of Java or Python or ETL tools who wants to make a career change to a snowflake developer or a snowflake architect
  • This is not for the Snowflake Admin, even though we go through a few of the admin tasks

What is Snowflake ?

Snowflake is cloud based data warehouse and analytical tool. With so many SAAS based Data warehouse applications available currently that are competing against one another, Snowflake stands out among the crowd for it uniqueness in design and approach. Snowflake works on an application that is faster and easier to handle. Unlike other data warehouse systems Snowflake is not built on Big data platforms rather it works on new SQL engine that is best suited for cloud. Having one of the best ACID (atomicity, consistency, isolation, and durability) complaint solutions. One of the USPs of Snowflake’s unique capabilities is in its table structures wherein Micro–Partitions and Data–Clustering are adopted Snowflake allows user to “time travel” i.e., track data changes overtime and view changes made anytime in the past up to a 90–days. Some of the other features of Snowflake are

  • Cloning – the clone feature create instant copy of any snowflake object
  • Undrop – any dropped object (Databases, schemas, tables etc) can be undropped
  • Fail safe – In the event of any disaster like hardware or disk failures. Snowflake engineers can recover the data upto a 7 day period post failure
  • Analytics Solution – Snowflake architecture helps in dealing with data and analytics alongside with data warehousing capabilities
Main Content