Best Snowflake Courses

Find the best online Snowflake Courses for you. The courses are sorted based on popularity and user ratings. We do not allow paid placements in any of our rankings. We also have a separate page listing only the Free Snowflake Courses.

Snowflake Datawarehouse & Cloud Analytics – Introduction

Build a turbo-powered Cloud Data Warehouse using Snowflake

Created by Nav p - Cloud Data Engineer

"]

Students: 23544, Price: Free

Students: 23544, Price:  Free

Cloud Data Warehouse is the next big thing. Learn What is Snowflake Cloud Data Warehouse and its architecture.  Build highly scalable, high performance next-gen modern data warehouse for you company.  The course is designed in beginner friendly, helping you to understand the basics of cloud, SAAS and it all works together in the background.

Requirements:

  • Good to have prior data warehouse experience, but not mandatory

  • Nice to have SQL Background, but not mandatory

Snowflake Decoded – Fundamentals and hands on Training

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

Created by Hamid Qureshi - Cloud & Data warehouse Professional

"]

Students: 21396, Price: $19.99

Students: 21396, Price:  Paid

This course is not affiliated with Snowflake (the company).

This course provides Snowflake concepts & hands on expertise to help get you started on implementing solutions using Snowflake. This course reinforces the learning through hands on labs, assignments & quizzes.

At a high level we will go through the following topics

Introduction -  A bit of history about snowflake & its differentiation.

Getting Started with Snowflake - Sign up for a snowflake trial, setup the required tools and will create & load our first table into Snowflake

Architecture - A look into the snowflake concepts, how the snowflake decoupled architecture differs from the traditional database architectures. We will explore how Snowflake virtual warehouses allow scaling up and down of compute as per demand.

Getting data into Snowflake - We will explore the ingestion or loading methods available in Snowflake i.e. bulk copy & snowpipe. We will stage the data in an S3 bucket and load into Snowflake table using both bulk copy and snowpipe. We will also explore ways to load semi structured data like JSON into Snowflake.

Time Travel & Zero Copy Clones - Time travel & cloning is a very powerful feature unique to Snowflake. We will explore how time travel can help you recover data before a query was run or before a specific time. Combine time travel with cloning and you can create new tables which contain data back in time, and all that without incurring additional storage cost.

Secure Data Sharing - Snowflake based solutions can easily share data with other Snowflake users as well as non Snowflake users. We will explore ways on how to share your data and also how the sharing reuses existing storage.

Data Warehouse basics for absolute beginners in 30 mins

Data Warehouse basic concepts like architecture, dimensional modeling, fact vs dimension table, star vs snowflake schema

Created by Eshant Garg | LearnCloud.Info | 80,000+ Enrollments - Instructor | LearnCloud.Info | AWS | Azure

"]

Students: 9678, Price: Free

Students: 9678, Price:  Free

Important Note:

Please note that this is NOT a full course but a single module of the full-length course, and intended to cover very basic fundamental concepts for absolute beginners so that they can speed up with Azure Synapse SQL Data Warehouse course.

This module is NOT GOOD for you if:

  • You are already experienced in this technology

  • You are looking for an intermediate or advance concepts

  • You are looking for practical examples or demo

This module is GOOD for you if:

  • You want to understand the basic fundamental concepts of this technology.

This is a free module to help others. If you are not in the intended audience, I request you to please feel free to unenroll.

Where I can find a full-length course?

Please look at the bonus lecture in the end.

What will students learn in this course?

  • Microsoft SQL Data Warehouse (Crash course to speed up with Cloud warehousing)

Level

  • Beginners

Intended Audience

  • Anyone who wants to start learning Data warehousing

Language

  • English

  • If you are not comfortable in English, please do not take the course, captions are not good enough to understand the course.

Target Students

  • Database and BI developers

  • Database Administrators

  • Data Analyst or similar profiles

Prerequisites

  • Basic T-SQL and Database concepts

Course In Detail

Data Warehouse Crash Course

  • In this module, you will learn, what is Data Warehouse, Why we need it and how it is different from the traditional transactional database.

  • We will learn the concept of dimensional modeling which is a database design method optimized for data warehouse solutions.

  • Then I will explain what we mean when we say facts and their corresponding fact tables. What are the dimensions and their corresponding dimension tables?

  • how are these special kinds of tables joined together to form a star schema or snowflake schema?

  • This section will establish the foundation before you start my course on Azure Synapse Analytics or formally known as Azure SQL Data Warehouse.

[Tags]

Microsoft SQL Server, Azure SQL Server, Azure SQL Data Warehouse, Data Factory, Data Lake, Azure Storage, Azure Synapse Analytics Service, PolyBase, Azure monitoring, Azure Security, Data Warehouse, SSIS

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 concepts

Created by Kashish Gakkar - Data Engineer

"]

Students: 9338, Price: $19.99

Students: 9338, Price:  Paid

UPSKILL YOURSELF IN THIS PANDEMIC!

************************************************************************************************************

SnowPro Core Certification Practice Test added

- This will help you understand the examination pattern

- Will boost your confidence before attempting the actual examination

************************************************************************************************************

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

Snowflake Masterclass [Real time demos+Best practices+Labs]

Master snowflake cloud data-warehouse with hands on exercises from real time expert.

Created by Pradeep H C - Data engineer

"]

Students: 7546, Price: $29.99

Students: 7546, Price:  Paid

If you would like to understand how to build workflows using Airflow, Talend and Snowflake Please check out my new course,

Snowflake cloud database with ETL(Airflow+Python+Talend)

This course is the result of my over 4 years of experience working with Snowflake. Snowflake is a fantastic tool to handle huge volumes of data. You can load, query and export, and run transactional queries on TB's and PB's of data easily.

You don't have to worry about infrastructure setup, security, performance, tuning, Garbage collection, node failures etc etc...

if you have already worked with Spark with EMR or with Data bricks you will be amazed by snowflake performance and simplicity.

But there is a catch, if you are not fully aware of how things works in snowflake, you will easily loose control and end up writing costly queries and end up using many of snowflake features wrongly.

I mentioned costly queries because  snowflake is build for performance.

Costly queries and wrong design decisions in snowflake will sky rocket your snowflake bill. I have made lot of such mistakes and learned from those mistakes.

This course is an effort to walk you through such experiences so that you don't end up doing same mistakes which i did!!!

Few things can only be learned by experience you can't find them in documentations this course will expose such details to you.

Hope you join me in this journey...................

The course is broadly divided into 3 modules,

Module#1

    Lectures ------------>: 38

    Real time Demos----->: 11

    Assignments--------->: 10

    Quiz------------------>: 6

  •    This module will concretize snowflake fundamental concepts and architecture.

  •    By the end of this module you will be having very strong foundation about snowflake.

Module#2

    Lectures ------------>: 46

    Real time Demos----->: 31

    Assignments--------->: 14

    Quiz------------------>: 2

  •     In this module i will walk you through, different techniques and options to load and unload data

        in snowflake.

  •     By the end of this module, you will be having great confidence in using COPY command and

        different data processing objects in snowflake.

Module#3

    Lectures ------------>: 45

    Real time Demos----->: 35

    Quiz------------------>: 3

  •     In this module, we closely evaluate important features of snowflake.

  •     This module helps you to understand, how each feature works under the hood.

  •     Through this knowledge you will be in a better position to decide, when to use the feature and when not to use the snowflake features.

High level overview of all modules with sections details is given below,

In module#1,  

    > Snowflake environment setup.

    > Snowflake architecture.

    > Snowflake caching , micro-partitions, clusters.

    > Snowflake clustering deep dive.

    > Snowflake virtual warehouse layer.

    > Performance tuning and DB characteristics.

In module#2,

    > Loading data in snowflake.

    > Loading data using internal stage.

    > Load data from aws s3.

    > Load data from google gcs.

    > Load data from Azure.

    > Copy command options.

    > Working with copy command.

    > Assignments.

    > Loading unstructured data

In module#3,

   > Snowpipe in snowflake.

   > Data sharing in snowflake.

   > Time travel.

   > Fail safe.

   > Clone feature.

   > Data sampling.

   > Tasks in snowflake.

   > Streaming in snowflake.

   > Continuous data load.

   > Materialized views.

Tackling Snowflake Certification – Practice Questions

Mock questions to prepare towards the Snowflake Certification exam

Created by Hamid Qureshi - Cloud & Data warehouse Professional

"]

Students: 6207, Price: $19.99

Students: 6207, Price:  Paid

Please note that these are practice questions only and  is not a snowflake course.

Updated March 2020 - This course contains practice exams to help students prepare towards the Snowflake - SnowPro Core Certification. 

Please note that these questions are meant to test your knowledge of the topics, they are not derived from the actual exam questions.

Please note that these questions do not guarantee exam success, please do attend other trainings and build your hands on experience on Snowflake before attempting the exam.

Snowflake for Developers

Snowflake Cloud Datawarehouse-Fast Track

Created by Ashish Khaitan - The Data Professional

"]

Students: 4441, Price: $29.99

Students: 4441, Price:  Paid

This course assists in developing a solid understanding of Snowflake's Cloud Data Warehouse.

Snowflake for Developers is not a scripted course with a steady pace of reading and death by power-point. It is an intense, involved, and engaging course that has its ups and downs, success and on-purpose failures, and the aha moments. This course is your ultimate companion to take you on a journey of learning Snowflake Cloud Data warehouse.

I would recommend previewing the "Introduction to Data Warehouse" lecture completely for its full 10 minutes length to understand what I mean.

Snowflake for Developers starts with the basics of data warehousing concepts to bring our beginner audience up to speed before going deep into Snowflake.

The course is not designed intentionally for any Certification exam preparation but geared more towards practical use in day to day implementations for Engineers and Architects.

Welcome aboard to Snowflake for Developers!

Snowflake Certification Preparation

SnowPro Core Certification

Created by Joyee D - A learner on the job

"]

Students: 4388, Price: $19.99

Students: 4388, Price:  Paid

When is this practice set last updated : 15 JAN 2021 

These practice tests will prepare you for the SnowPro Core Certification. Please note that this is not a replacement of you doing a thorough study of the snowflake documentation. You should try these questions once you have completed going through the snowflake documentation and is now ready to take the certification exam. These practice tests will help you find out how prepared you are. Based on the score of the test, you can go back and focus on the weak areas. These practice tests are from my notes that I have prepared to pass the certification myself. I do not claim and nor ever will claim that just mugging up these set of questions will guarantee you a pass mark in Snowflake certification exam. Certification is just a way to show others that you know the subject. But for you to be really expert in this field, you must have a thorough understanding of the technology product which is only possible through studying the documentation and actually applying the concepts in your work. 

How will these practice tests help you in preparing for your exam

1. The questions are modeled to test your knowledge on the published Snowflake concepts/topics

2. I do not just put the questions and the answers, I also provide explanations to each question

3. I keep on updating the questions as and when new concepts are introduced

4. Throughout the preparation, I will also share quick tips, important topics to focus on through individual emails to students

Last but not the least, I am looking for your feedback. You feedback is what motivates me and keeps me awake in the night to make this course more effective.

Important point to note:

I have modeled these questions not to just prepare you for the certification but also to be a better architect on the job. These questions are not from the actual certification exam and any resemblance will be just coincidence.

Snowflake Practice Questions – SnowPro Core Certified

Practice questions for the SnowPro Core Certified exam

Created by Adam Morton - Cloud Data Architect with 20 years experience

"]

Students: 2158, Price: $44.99

Students: 2158, Price:  Paid

The course contains a series of practice tests to help prepare you for the SnowPro Core Certified exam.

If, like me you come from the database background you’ll find using a product like Snowflake a real breath of fresh air. Easy to use, fast, agile, and packed with great features, it removes a lot of the tedious administrational tasks you tend to associate with pretty much every other database. It’s no wonder why it’s had the level of success it has and its great fun to use. I hope you find this content helpful.

The sheer simplicity of the Snowflake means it is straightforward to getting up and running. This also means a lot of users don’t move past the basics, because they never need to. For everyday workloads Snowflake runs out of the box and if queries start to take a little longer, well, you can always scale up at the touch of a button!

The questions contained in these practice tests cover the follow subject areas:

  1. Snowflake Overview and Architecture

  2. Snowflake Virtual Warehouses

  3. Snowflake Storage and Protection

  4. Data Movement (Loading & Unloading)

  5. Snowflake Account, Security and Sharing

  6. Snowflake Performance and Tuning

  7. Working with Semi-Structured Data

  8. Streams & Tasks

The exam does not cover cloud fundamentals or basics of SQL syntax, but some questions on the exam assume knowledge of these concepts. It's worthwhile brushing up on some of these areas if your not familiar with them.

This guide does not guarantee success but forms part of your preparation to succeed.

Snowflake concepts and Fundamentals (Only Theory) [2020]

Short and crisp course on the Snowflake for the busy professionals

Created by Nishant Jain - Principal Architect, Artificial Intelligence and Analytics

"]

Students: 2070, Price: Free

Students: 2070, Price:  Free

This a very short course on Snowflake covering all the concepts and fundamentals. Good enough to build a strong foundation on the Snowflake. There is no prior Snowflake knowledge required to complete this course.

Hands-on labs kept out of this course. If you are interested in pursuing the hands-on after this course, you can look for a detailed course of mine!

Snowflake – The Complete Masterclass (2021 Edition)

Master Snowflake & cloud-datawarehouse from the ground up

Created by Nikolai Schuler - Professional Data Scientist und BI Consultant

"]

Students: 1453, Price: $89.99

Students: 1453, Price:  Paid

Do you want to upgrad your skills and learn how to professionally work in Snowflake?

In this course you will – step by step – learn everything that is important in Snowflake!

Become a master in Snowflake and learn everything from scratch!

Why should you take this course?

✓ Understand everything from scratch – step by step, very structured and practice-oriented

Learn all the important features – know when and how to use them properly

✓ Clear explanations and very systematic – theory & practice

✓ Practice everything hands-on – practice & test your knowledge in quizzes & assignments

What is in this course?

In this course you will learn everything you need to master Snowflake!

This course is giving you the chance to systematically master the everything you need to know in Snowflake!

Master all the fundamentals

Master also all the advanced topics

Learn the best practices hands-on

Apply what you’ve learnt in a lot of assignemnts & quizzes

Personal support whenever you have questions

This course is right for you if...

... you have never worked with Snowflake and want to learn how to master everything hands-on in just one course.

... OR you have already some basic knowledge and want to dive deeper and become more advanced in the whole universe of Snowflake.

This is the one course that covers everything you need to Master Snowflake.

Enroll now to get life long access and master Snowflake!

Mock Tests – Snowflake SnowPro Core Certification

Gauge your readiness for the certification

Created by Yogesh Agrawal - Snowflake Architect (DW | DI | ETL Consultant)

"]

Students: 1060, Price: $19.99

Students: 1060, Price:  Paid

This course have full length practice tests. This course is meant to help you practice hundreds of unique questions in the exam format and help you prepare for the actual exam. The questions will be based on the following topics that are key for  Snowflake SnowPro Core Certification -

  1. Snowflake Architecture

  2. Snowflake Virtual Warehouses

  3. Snowflake Storage and Protection

  4. Data Movement (Loading & Unloading)

  5. Snowflake Account & Security

  6. Snowflake Performance Tuning

  7. Semi-Structured Data

  8. Data Sharing

  9. Continuous Data Pipelines (Tasks, Streams).

All questions are categorized under one of the above topics, and result of these practice tests will help you understand which are your strong and weak areas, and you can plan your studies accordingly.

In case anyone needs details on any specific question, please feel free to raise the same under Q&A section of the course, and I will ensure to reply at earliest.

**Disclaimer - Though I have tried to cover the most of the key facts for each areas for SnowPro Core, but clearning these practice test will not gaurantee that you will clear the actual certification exam. These are just mock tests, that can help you check your level of knowledge on different Snowflake topics, so that you can plan your next steps accordingly.

Important Note - The course is not affiliated with Snowflake Inc .

Snowflake SnowPro Core Certification – Practice Tests

Get confident in clearing SnowPro Core Certfication | Understand pattern of the examination

Created by Kashish Gakkar - Data Engineer

"]

Students: 922, Price: $19.99

Students: 922, Price:  Paid

This course is launched in JUNE 2021 with motive to support you in becoming a Certified Snowflake Developer. This course consists of practice tests which covers questions from all the topics which are relevant for SnowPro Core Certification Examination.

You should be prepared and confident on Snowflake Data warehouse core concepts as well as its APIs, connectors, SQL, etc. and most importantly Determination and Readiness for the examination is required.

The questions in the practice tests of this course are hand curated which provides the detailed explanation for the answer of each question. This way you also remember the concepts that you prepared before attempting these tests.

SnowPro Examination structure:

Launched in year: 2019

Examination duration: 2 hours

Number of questions: 100

Questions Type: Multiple Choice and Multi Select

You will get access to cheat sheet to crack SnowPro Certification Examination from my AWS repository given in the description of each practice tests.

-------------------------------------  Examination Tips  -------------------------------------------

  • Most important exam tip would be, "don’t overthink". Revisit CheatSheet shared in practice tests description before attempting examination.

  • if you are stuck with a question, mark it, and come back later. In most cases, some other future questions will give you the answer that question, or you’ll have a fresher mind when you come back.

-------------------------------------------------------------------------------------------------------

*****************************************************************************************************************************

----------------------- 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 get certified on Snowflake. It does not matter if you are working as a Data Analyst/Data Scientists/Data Engineer/Programmer/BI Expert or as a Student, Snowflake is now being used almost everywhere where there is a need to process and store voluminous data to perform day-to-day tasks.

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....

--------------------------------------------------------------------------------------------------------------------------

Important Notes for this course:

  • The questions in this course are not to just prepare you for the certification but will also help you to be a better engineer/architect on the job.

  • Consider this practice test as you are going to attempt actual SnowPro Core certification exam. This will help you to boost your confidence when writing actual SnowPro Core certification exam.

  • Attempt the practice tests in this course once you have good understanding of SnowPro Core Certification Examination content.

  • The questions will be randomly asked from any topic and would not follow any sequence. This increases the difficulty level of these practice tests but will definitely help you to get good results in the actual examination.

  • The practice tests will be periodically updated to add on new concepts relevant to certification exam.

  • Completing and passing the practice tests in this course does not guarantee success in actual certification examination.

  • This course can help you revise/revisit the snowflake concepts however, you should try these questions once you have completed going through the snowflake documentation and now ready to take the certification exam. 

  • This course does not guarantee to make you ready to perform on the job tasks. This is only possible after you diligently go through your snowflake learning resources, by understanding and practicing concepts.

-------------------------------------------  Important Notes Ends Here  ---------------------------------------------

------------------------------------------------------------------------------------------------------------------------------------------------

*****  By end of this course, you will be able to attempt SnowPro Core Certification Exam with boosted confidence  ************

------------------------------------------------------------------------------------------------------------------------------------------------

\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\

I am sure you would gain confidence after completing these practice tests. :)

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.

////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

Provide reviews, feedbacks, ratings for this course once you have gone through at least 1 complete practice test. Feedbacks from my students help me to bring more exciting and up-to-date content.

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 ---------

Snowflake Certification – Architect

SnowPro Advanced Architect

Created by Joyee D - A learner on the job

"]

Students: 681, Price: $34.99

Students: 681, Price:  Paid

When is this practice set last updated : 4 Jan 2021

Pre-requisites for this certification:

You must be SnowPro Core Certification and you should have at-least two years of working experience with SnowFlake.

These practice tests will prepare you for the SnowPro Advanced Architect Certification. Please note that this is not a replacement of you doing a thorough study of the snowflake documentation. You should try these questions once you have completed going through the snowflake documentation and is now ready to take the certification exam. These practice tests will help you find out how prepared you are. Based on the score of the test, you can go back and focus on the weak areas. I do not claim and nor ever will claim that just mugging up these set of questions will guarantee you a pass mark in Snowflake certification exam. Certification is just a way to show others that you know the subject. But for you to be really expert in this field, you must have a thorough understanding of the technology product which is only possible through studying the documentation and actually applying the concepts in your work. 

How will these practice tests help you in preparing for your exam

1. The questions are modeled to test your knowledge on the published Snowflake concepts/topics

2. I do not just put the questions and the answers, I also provide explanations to each question

3. I keep on updating the questions as and when new concepts are introduced

4. Throughout the preparation, I will also share quick tips, important topics to focus on through individual emails to students

Last but not the least, I am looking for your feedback. You feedback is what motivates me and keeps me awake in the night to make this course more effective.

Important point to note:

I have modeled these questions not to just prepare you for the certification but also to be a better architect on the job. These questions are not from the actual certification exam and any resemblance will be just coincidence.

Snowflake SnowPro Core Certification Exam Practice Sets

More than 300 Unique Questions Based On SnowPro Core Certification Exam With 3 Full Mock Tests and Practice Sets

Created by V K - Certified Snowflake SnowPro Advanced and SnowPro Core

"]

Students: 437, Price: $19.99

Students: 437, Price:  Paid

The Practice Sets and Mock Tests are designed to help prepare you for SnowPro Core Certification Exam, but not guarantee success!

This is not a Snowflake Official course.

Snowflake is growing very fast. Its unique offering as first cloud native data platform has changed the ways enterprises have been handling their data. Snowflake is on very high demand and that has opened door for lot of new opportunities for Snowflake Certified consultants. The objective of the SnowPro Core exam is to measure an individual’s ability to implement a data warehouse solution into data environments. The exam has no mandatory pre-requisites.

There could not be a better time than now to get SnowPro Core Certified. This course is meant to help you practice hundreds of unique questions as the exam format and help you prepare for the actual exam.

You will find more than 300 unique questions based on the SnowPro Core Certification Exam format and covering all of the following subject areas:

  1. Snowflake Overview and Architecture

  2. Snowflake Virtual Warehouses

  3. Snowflake Storage and Protection

  4. Data Movement (Loading and Unloading)

  5. Snowflake Account and Security

  6. Snowflake Performance and Tuning

  7. Semi-Structured

There are 3 Full Mock Tests, simulate the actual exam.

There are Practice Sets based on Subject Areas as well to practice any particular area you may want.

TIPS : Your focus should not be only finding the right answers. You should also focus on understanding why other options are not correct or best answers. Detailed Explanations have been provided with each question. It will help you learn the basic to advanced concept, not just for certification exam but it will help you apply the learnings in your live projects as well as handle the job interviews etc.

Snowflake Database – The Complete Cloud Data Platform

A complete course, with sample exam, to prepare the developer/administrator and for the Snowflake Certification exam

Created by Randy Minder - Data Engineer / Business Intelligence / Power BI / Snowflake

"]

Students: 422, Price: $34.99

Students: 422, Price:  Paid

Snowflake was written from the ground up to be a novel and advanced cloud data platform provided as Software-as-a-Service (SaaS). Snowflake enables data storage, processing, and analytic solutions that are faster, easier to use, and far more flexible than traditional offerings.

In this nearly nine hour course, we talk about how Snowflake is a true SaaS offering. Specifically we address:

- How there is no hardware (virtual or physical) to select, install, configure, or manage.
- How there is virtually no software to install, configure, or manage.
- How maintenance, management, upgrades, and tuning are handled by Snowflake.
- All important aspects of Snowflake
- How Snowflake runs completely on cloud infrastructure. All components of Snowflake’s service (other than optional command line clients, drivers, and connectors), run in public cloud infrastructures.

Our goal was to get you up-to-speed with Snowflake and prepare you for the Snowflake Certification exam with a 250 set of practice questions and scenarios. When you finish this course you will have a solid understanding of the Snowflake environment, be ready to administer your own Snowflake environment and be prepared for the Snowflake Certification exam. I recently passed the Snowflake Core Certification exam with a score of 90% and the questions included in this course were invaluable as a study guide.

In addition to the above, we cover more specific areas such as:

- Separation of compute and storage (the power behind Snowflake)
- Virtual warehouses (compute instances)
- Scaling up and scaling out
- Zero-copy cloning (a feature unmatched by most any other competing platform)
- Data sharing
- Snowflake credits and billing
- Performance tips
- Clustering keys
- Data loading and unloading
- Structured and semi-structured data
- and much more...

Snowflake Cloud Data Warehousing-Basics to Advanced concepts

Shape Up the Data in the cloud

Created by Kullayappa Munagamani - Data Engineer

"]

Students: 163, Price: $44.99

Students: 163, Price:  Paid

This tutorial helps you to understand basic and advanced concepts of cloud technologies and their advantages over traditional and on premises data warehouse. You will learn how to load the data and unload the data from/to snowflake account. We create snowflake tasks which will be used to schedule stored procedures or data loading activities. We cover discussing about snowpipe which is a continuous data loading process. Snowflake comes with Time travel and zero copy cloning, We do discuss about these concepts in this tutorial.

Snowflake Database – The Modern Data Lake

See how Snowflake can become your new modern data lake along with your data warehouse and everything else

Created by Randy Minder - Data Engineer / Business Intelligence / Power BI / Snowflake

"]

Students: 119, Price: $24.99

Students: 119, Price:  Paid

The failure rate on big data traditional data lake projects is between 60% and 80%. Hadoop was billed as the platform to store and analyze data. It promised to minimize data silos with the concept of a Data Lake. But, Hadoop has largely failed in its ability to consider the operational side of data and what it takes to actually run a business. Big data systems like Hadoop are complex and require teams of expensive engineers to build and maintain them. This course shows how Snowflake changes all this. Snowflake is the complete modern cloud based data platform that can integrate with, or completely replace your data lake. This course shows how this is made possible.

We do an in-depth discussion of the history of data lakes and the architecture of the modern on-premises or cloud-based data lake. We talk about what's good about data lakes and what's bad about them. We talk about data lakes becoming data swamps. Most importantly, we discuss how Snowflake can complete replace the traditional data lake and be your single repository for corporate data.

Finally we present three case studies of companies that tried to make the traditional on-premises (or cloud-based) data lake architecture work for them and finally scrapped it and settled on Snowflake.

We wrap up the course with some questions to test your knowledge of the material.

Snowflake cloud database with ETL(Airflow+Python+Talend)

Building ETL workflows for snowflake.

Created by Pradeep H C - Data engineer

"]

Students: 84, Price: $19.99

Students: 84, Price:  Paid

In our previous course Snowflake Masterclass [Real time demos+Best practices+Labs] we deep-dived and understood the fundamentals of snowflake, solved lot of assignments, and understood best practices to load data and unload data.

Also, we closely evaluated most of the snowflake features understanding how they work under the hood. Through these discussions, you realized how to use Snowflake efficiently.

There was one missing piece, How to build and orchestrate ETL workflows on Snowflake. This course is just about that.

In this course, we are going to learn,

  1. Build workflows in Airflow.

  2. We will leverage Talend capabilities to build generic code to ingest data and process data in snowflake.       

  3. We will build audit tables and record every command we fire on the snowflake. We will record the time consumed for each task and capture snowflake credits.

  4. Once we build the framework we will build a workflow to process and transform 250 + GB volume of NYC traffic data.

  5. At last, we will connect the Snowflake with python and write code to capture stats of data we loaded to the snowflake.

  6. you will also get access to preconfigured Jupyter notebook to run your python code on the Snowflake.

If you have previously not worked with Talend, Airflow and Python don't worry they are very simple tools I will provide the necessary introduction.

I am sure you will learn a lot from this journey. See you in the course!!

Snowflake Database – Tips, Techniques and Cool Stuff

This course is packed with tips, techniques and just cool stuff that demonstrates why Snowflake is so popular

Created by Randy Minder - Data Engineer / Business Intelligence / Power BI / Snowflake

"]

Students: 61, Price: $29.99

Students: 61, Price:  Paid

Snowflake was founded in 2012 and released in late 2014. The company was founded by Benoit Dageville, Thierry Cruanes and Marcin Żukowski, who, between them, have over 120 patents. Dageville (PhD) spent 16 years at Oracle as an architect. Cruanes spent 13 years at Oracle focused on the optimization and parallelization layers in Oracle databases including as lead for the optimization group. Zukowski invented vectorized query execution for databases. His innovation emerged from his PhD research into optimizing database query execution for modern processors. These three legends have created a company that has currently has 250 petabytes under management, 1,300 partners, over 4,000 customers and $265M in revenue in 2020.

Since its release it has acquired close to 20% of the data warehouse market. It's no wonder. Snowflake is built from the ground up to be unique and purely cloud-based. In this course we show you dozens of tips, tricks and demonstrations of cool things Snowflake can do. We cover numerous SQL tips and tricks. We cover cool features such as resource monitors, the amazing Web UI, generators, using Snowflake as a data lake (which you could, and should, be doing), analytical functions in Snowflake, monitors warehouse usage and so much more.

CheatSheets for Snowflake SnowPro Certification Exam

Notes, Lectures and CheatSheets for SnowPro Certification Exam

Created by Ashok Bhatla - Lead Data Architect & Engineer

"]

Students: 60, Price: $19.99

Students: 60, Price:  Paid

This course covers all the main topics of Snowflake SnowPro Core Certification Exam.  It is divided into 5 different units. Combined total, there are approx. 100 slides of course material. Students will learn about the following topics

(1) Architecture (2) Security and Data Sharing (3) Data Loading and Connectivity, (4) Query Execution & Performance, (5) Working with SnowFlake (Covers STREAMS, TASKS and RESOURCE MONITORS in details)

Snowflake Snowpro Certification Practice Test

Certification Practice Test

Created by Manisha Singh - Senior Solution Architect

"]

Students: 41, Price: $24.99

Students: 41, Price:  Paid

This course consists of practice set with explanation. This will help to have better understanding of various topics covered in snowpro exam. Entire set consists of 40 questions each covering all the topics required by the snowpro certification exam. This practice set is prepared keeping in view the recent snowpro certification. Each practice set is categorized based on the various topics being covered in the exam. It covers

  1. Snowflake Architecture

  2. Snowflake Virtual Warehouses

  3. Snowflake Storage and Protection

  4. Data Movement (Loading & Unloading)

  5. Snowflake Account & Security

  6. Snowflake Performance Tuning

  7. Semi-Structured Data

  8. Data Sharing

  9. Continuous Data Pipelines (Tasks, Streams)

**Disclaimer - Though I have tried to cover the most of the key facts for each areas for SnowPro Core, but clearing these practice test will not guarantee that you will clear the actual certification exam. These are just practice test to assess your knowledge so that you can plan your next steps accordingly.

What you’ll learn

With these Practice Tests, students will get to know how to prepare for Snowflake SnowPro Core Certification.

These are full lenght practice tests with 40 questions in each practice tests, of type Multi Select, Multiple Choice, True False (similar format as that of SnowPro Core Certification)

Are there any course requirements or prerequisites?

Have understanding of following topics of Snowflake - 1. Snowflake Architecture 2. Snowflake Virtual Warehouses 3. Snowflake Storage and Protection 4. Data Movement (Loading & Unloading) 5. Snowflake Account & Security 6. Snowflake Performance Tuning 7. Semi-Structured Data 8. Data Sharing

Who this course is for:

This is for Students & Professionals who are planning to get their Knowledge Check before appearing SnowPro Core Certification

Snowflake SnowPro Core Certification Based Learning

SnowPro Core Certification Based Learning With Multiple Test

Created by Mukund Kumar Mishra - Technical Architect

"]

Students: 11, Price: $19.99

Students: 11, Price:  Paid

Snowflake Inc. is a cloud computing-based data warehousing company based in Bozeman, Montana. It was founded in July 2012 and was publicly launched in October 2014. Snowflake was natively designed for Cloud, where thousands of organizations have seamless access to explore, share, and unlock the true value of their data. Snowflake has the best UX out of all the cloud-hosted options, with a fast and responsive UI console and great JSON handling. This makes it easy to get started and transition to structured tables later, or just stick with JSON for flexibility.

As mentioned above Snowflake is built specifically for the cloud, and it’s designed to address many of the problems found in older hardware-based data warehouses, such as limited scalability, data transformation issues, and delays or failures due to high query volumes.

Snowflake is a public facing multi-tenant SaaS service. It provides a Cloud Data Platform that spans AWS, Azure, and GCP. It helps customers move the following six workloads to the Cloud: Data Engineering, Data Warehouse, Data Lake, Data Applications, Data Exchange, and Data Science. The benefit of Snowflake is that it can do this with a single managed platform rather than many different products.

This course is designed for those who are interested in learning the fundamental of Snowflake along with preparing for Snowpro certification . Here is the agenda based on the Snowpro certification exam

Snowflake Overview and Architecture

• Overview

• Architecture

• Business cases

• Data sharing

• Extensibility

• Cloud services

• Migrations

• WebUI

Snowflake Virtual Warehouses

• Overview

• Compute

• Warehouses

Snowflake Storage and Protection

• Overview

• Continuous data protection

• Storage

Data Movement (Loading and Unloading)

• Overview

• Data loading

• Data pipelines

• Data unloading

• User Defined Function In Snowflake

• Snowflake Account and Security

• Account and security

• Security management

Snowflake Performance and Tuning

• Performance management

• Query optimization

• Clustering

• Semi-Structured Data

• Semi-structured

• Test your knowledge

• Fact Sheet Note & Learn

This is the time now to explore practical based learning on Snowflake and let Snowflake an analytical data warehouse delivered as Software-as-a-Service (SaaS) help you excel in your journey . Snowflake's data warehouse is not built on an existing database or a "big data" software platform like Hadoop. The Snowflake data warehouse uses a new SQL database engine with a unique architecture designed for the cloud.

Snowflake is one of the few enterprise-ready cloud data warehouses that brings simplicity without sacrificing functionality. It scales automatically, both up and down, to strike the right balance between performance and cost. Snowflake is famous for separating computing from storage. This is important because almost every other database, including Redshift, combines the two, meaning you have to scale for your heaviest workload and bear the cost that goes with it.