Course Information
Course Overview
Master snowflake cloud data warehouse with hands on exercises, become EXPERT on Snowflake and add SNOWPRO cert(external)
As a Udemy Instructor, I have helped more than 28,000 professionals (and counting).
Do you want to upgrade 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!
Learn using the new Snowflake Web UI - Snowsight.
This course provides Snowflake concepts detailed explanation & hands on expertise to help get you started on implementing solutions using Snowflake. This course reinforces the learning through hands on labs, assignments & quizzes.
It is an hands-on engaging course that has concept explanations, success and on-purpose failures. This course is your ultimate companion to take you on a journey of learning Snowflake Cloud Data warehouse.
You don't have to worry about infrastructure setup, security, performance, tuning, Garbage collection, node failures etc etc...
The course has following structure:-
Video based Concept Lectures
Real time Hands-on Demos
Assignments
Quiz
In this nearly eleven 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), which run in public cloud infrastructures.
The course starts with the basics of data warehousing concepts to bring our beginner audience up to speed before going deep into 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.
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.
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...
Course enrollment grants you lifetime access, with no expiration, to all the course lectures, activities, handouts, and quizzes. In addition, you’ll also receive 1-on-1 support for any questions or uncertainties that come up. And this all comes with a money-back guarantee. You have nothing to lose and so much knowledge to gain.
You will get downloadable one-stop-shop for all the resources used in this class.
By end of this course, you will be able to work as an Snowflake Expert
Course Content
- 10 section(s)
- 116 lecture(s)
- Section 1 Introduction
- Section 2 Getting Started
- Section 3 Learning the Basics
- Section 4 Snowflake Architecture and Key Concepts
- Section 5 Loading Data into Snowflake
- Section 6 COPY command
- Section 7 Loading Semi-structured and Unstructured Data
- Section 8 Snowflake Performance
- Section 9 Snowpipe
- Section 10 Time Travel
What You’ll Learn
- Snowflake Essentials, it's unique architecture & its differentiation
- Staging & Ingesting bulk & streaming data from cloud storage
- Scalability through the virtual warehouse compute clusters
- Hand-on exercises to demonstrate along with sql code files
- WILL BE HELPFUL TO GO FOR SNOWPRO CERTIFICATION
- Understand Snowflake cloud data warehouse 's data loading and querying options and best practices
- Unique features as Snowpipes, SnowSQL, Time Travel, materialized Views, Secured Data Sharing, scheduling automated tasks and other enterprise level features
- Secure data sharing with snowflake & non-snowflake users
Skills covered in this course
Reviews
-
MMehak
This course has helped me to understand the advanced concepts of Snowflake. With hands-on exercises and detailed explanations, I was able to follow the snowflake concepts with ease. The lecturer has done a good job in providing the concepts in easy words, building the course gradually that helps a beginner and experts students equally. I would recommend this course to anyone who wanted to learn Snowflake and become an expert.
-
MM Venkatesh
excellent course, easy understanding, thanks
-
KKhasim Mohamed
Very well organized for senior programmers and Data architects.
-
JJennifer Bowman
Good step by step details