
An introduction to this course
In this lecture we do a high-level overview of the amazing Snowflake product
In this lecture we do a high-level overview of the Snowflake architecture
In this lecture we take about the various editions of Snowflake and the cost of using Snowflake
Here we show you how to create a demo Snowflake account so that you can work along with the course
In this lecture we do a brief overview of the Snowflake Web UI.
Here we go into detail about what a virtual warehouse is
In this lecture we cover two different ways of creating a virtual warehouse
In this lecture we talk more about Snowflake credits and billing
A summary of virtual warehouses and some tips
An overview of Snowflake storage architecture
In this lecture we talk about how Snowflake encrypts your data
Data masking was recently added to Snowflake and we discuss it in this lecture
Snowflake never has to go offline for updates. We explain how this works.
Time travel allows you to go back in time and see that state of your database or table at some point in the past. We talk about this in this lecture.
Fail-safe is a last attempt option to retrieve the state of your database for up to 7 days in the past. We talk about this in this lecture.
In this lecture we discuss the amazing technology that is zero copy cloning
This lecture contains an overview of loading data into Snowflake
In this lecture we discuss how to ingest data from a local file
There are certain activities that cannot be done from within the Web UI. For these activities you need SnowSQL. In this lecture we discuss what this is.
This is a continuation of the part 1 lecture
In this lecture we talk briefly about ingesting data from an external source
The Copy Into command is an important function that you will use often when ingesting data. We go into a little deeper discussion about this command.
Here we give some recommendations to efficiently ingest data into Snowflake
This lecture talks about Snowpipe and how it allows you to continuously load data into your Snowflake table
In this lecture we talk about unloading data to any number of formats, either locally or in the cloud
In this lecture we talk about Snowflake streams, also known as Change Data Capture.
In this lecture we talk about tasks which allow us to execute SQL statements on a defined schedule
An overview of Snowflake's security architecture
In this lecture we talk about Access security in Snowflake
In this lecture we talk about Authentication security in Snowflake
In this lecture we discuss Snowflake authorization and data protection
In this lecture we discuss Snowflake performance, how to monitor it and how to potentially improve it, at a high, overview, level.
In this lecture we talk about what data clustering is and how creating clustering keys, in certain circumstances, can very effectively improve performance.
In this lecture we discuss some virtual warehouse optimizations to improve efficiency, performance and credit consumption
An overview of semi-structured data support in Snowflake
In this lecture we demonstrate how to query JSON data in Snowflake
In this lecture we talk about the three table types Snowflake supports
In this lecture we talk about the magic of external tables
In this lecture we do a bit deeper dive into the very important topic of caching
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...