In this lecture we do a quick tour of the Web UI. This is essentially the same lecture of the Web UI contained in our Complete Cloud Data Platform course. It's included here (edited somewhat) for those who haven't taken that course and for those not all that familiar with the Web UI.

Some techniques for finding objects in your entire account or a particular database

Once you have found the object you are looking for (prior lecture), how do you inspect some details about the object? This lecture covers that.

This lecture shows how to do a search and search / replace in Snowflake, which is not obvious

In this lecture we talk about commenting blocks of code and making changes to blocks of code.

In this lecture we discuss various ways of copying and moving code. Ctrl + C and Ctrl + X are not your only options.

Part 1 of Query History and Results Cache tips, techniques and cool stuff

Part 2 of Query History and Results Cache tips, techniques and cool stuff

Before we begin working through all the useful queries you might want to execute in Snowflake, it's useful to first discuss what an Information Schema is.

In this lecture we discuss queries you will find useful to learn about the databases and schemas in your account

In this lecture we discuss some useful techniques for retrieve table and view information in a database

Snowflake supports table constraints to some extent for compatibility with other systems. This lecture talks about how to determine what types of constraints exist in your tables.

In this lecture we show you a technique for retrieve column information from one or more of your tables

A brief lecture in information schema views

Data types in Snowflake are interesting. It appears Snowflake has quite a few but there is a relatively small number of base types that other types fall into. We then show a technique for retrieve all columns of a certain data type.

A brief discussion of user-defined functions and a technique for determining what functions might reside in your database

In this lecture we discusses techniques for retrieving user information, roles, grants and the result_scan function.

It's not unusual to create a user account and then the user never logs in. Or, perhaps you have users who haven't logged in, in at least 60 or 90 days. Do they really need access to your system? We discuss a technique to detect this in this lecture.

Here we discuss techniques for determining who has been issuing queries in your account and the types of queries and more

Here we show some techniques for working with warehouses (compute)

In this lecture we demonstrate some techniques for generating all sorts of dates in Snowflake

Time zones can be a hassle to deal with and you will often need to convert from one time zone to another. In this lecture we show a quick technique to do that.

We discuss 10 Snowflake technologies that make Snowflake cool, plus a bonus 11th.

You can do some pretty cool things with Generators in Snowflake. In this lecture we show you how.

Did you know that Snowflake can be, and should be, used as your data lake? In this lecture we demonstrate some simple techniques for doing just that. This lecture is actually part of our Modern Data Lake course.

In 2020 Snowflake added the ability to mask data. In this lecture, from our Complete Cloud Data Platform course, we demonstrate techniques for masking data.

Without a doubt one of the coolest features of Snowflake and Time Travel. In this lecture we demonstrate how to create a new database based on an existing database using both cloning and time travel.

I give Snowflake a lot of credit. They go out of their way to make sure you don't spend any more than you have to. One very cool way they do this is via something called a resource monitor. We discuss these in this lecture.

How often have you wish you could restore a database or a table without having to go through the hassle of doing a database restore. In this lecture we demonstrate how Snowflake makes this very simple with a very cool feature called Undrop.

An overview of Windowing functions in SQL

The Rank function is a very important analysis tool you will almost certainly want to use when asked to perform some basic statistical analysis on data.

The Lead and Lag functions are very useful functions when you want to compare a current value to a value in the future or the past. In this lecture we show you a technique for using these functions.

In this lecture we demonstrate a technique for the determining the first and last values in some sort of user defined partition.

In this lecture we discuss a relatively new function to help make percent of total calculations a bit easier.

If you do data analysis long enough you will be required to perform a moving average. We show a technique for doing this in this lecture.

Eventually you will have a need to work with percentiles. This lecture demonstrates a technique for generating percentiles.

Grouping sets are an extension of the traditional Group By that allows you to create interesting combinations of aggregated data.

Like any other technology, Snowflake has a lot of buzz words. In this lecture we review the most common ones you are likely to encounter when working with Snowflake.

Here we should several techniques for controlling the Snowflake operational environment

The ListAgg function in Snowflake is amazingly powerful when you need to dynamically concatenate values together in a result set. We discuss this function in this lecture.

The Qualify function works with Windowing statements and can save you a significant amount of code. We talk about this cool function here.

Did you realize that Snowflake does case sensitive comparisons by default and that will sometimes result in unexpected behavior? The ILIKE function can help with this potential problem.

Have you ever had a need to compare two tables or rows of data? There is an easy way and hard way. We show you a very easy way to do this using Hash_Agg.

In this brief lecture we demonstrate the technique for killing a session (connection)

A cool technique for detecting warehouses consuming more credits than average.

It can be confusing to know which function to call when you want to extract parts of a date/time field. In this lecture we demonstrate a technique for doing this.

A technique to convert a permanent table to transient.

Eventually you will want to create a SQL script to generate a particular object, be it a database or perhaps a sequence. In this lecture we demonstrate a technique for doing that.

20 performance and money-saving tips to keep your company or clients happy, and to make you look good.

Expand your knowledge