Snowflake Database - Tips, Techniques and Cool Stuff

Focused View

Randy Minder

5:10:55

14 View

1 - Introduction

1 - Introduction.mp4

01:37

2 - Snowflake User Interface Web UI Techniques

2 - A Quick Tour of the Web UI.mp4

13:20

3 - FindingObjects.zip

3 - Finding Objects in Your Account andor Database.mp4

10:17

4 - Getting Object information.mp4

03:59

5 - Executing SQL Statements.mp4

02:31

6 - Search and Replace.mp4

01:46

7 - Commenting Your Code.mp4

02:37

8 - Copying and Moving Code.mp4

01:15

9 - Query and Results History Part 1.mp4

15:10

10 - QueryHistoryQueries.zip

10 - Query and Results History Part 2.mp4

10:40

3 - SQL Tips and Techniques

11 - InformationSchema.mp4

04:43

12 - DatabasesandSchemas.zip

12 - Databases and Schemas.mp4

03:00

13 - Tables.mp4

08:00

13 - Tables.zip

14 - TableConstraints.zip

14 - Table Constraints.mp4

04:11

15 - Columns.mp4

06:53

15 - Columns.zip

16 - Views.mp4

01:14

16 - Views.zip

17 - DataTypes.zip

17 - Data Types.mp4

05:04

18 - Functions.zip

18 - Userdefined Functions.mp4

03:35

19 - Users.zip

19 - Users and the ResultScan Function.mp4

05:57

20 - Users Never Logged In.mp4

03:10

20 - usersneverloggedin.zip

21 - QueryHistory.zip

21 - Query History.mp4

08:46

22 - VirtualWarehouses.zip

22 - Virtual Warehouses Compute.mp4

06:11

23 - Dates.mp4

03:41

23 - Dates.zip

24 - Converting Time zones.mp4

03:24

4 - Cool Features and Functions in Snowflake

25 - 10 Features That Make Snowflake Cool Plus a Bonus 11th.mp4

17:14

26 - Generators.mp4

06:39

26 - Generators.zip

27 - Using Snowflake as a Data Lake.mp4

16:52

27 - queries1.zip

28 - Data Masking.mp4

07:55

29 - Creating a Table from a Clone and Time Travel.mp4

06:36

29 - createtableclone.zip

30 - Resource Monitors.mp4

12:20

31 - Dropping and Undropping Objects.mp4

03:18

5 - Windowing Functions and Analytical Techniques

32 - Overview.mp4

05:44

33 - Rank.mp4

03:56

33 - rank.zip

34 - Lead and Lag.mp4

04:35

34 - leadandlag.zip

35 - First and Last.mp4

03:23

35 - firstandlast.zip

36 - RatioToReport.mp4

03:01

36 - ratiotoreport.zip

37 - Moving Averages.mp4

04:20

37 - movingaverage.zip

38 - Techniques for Percentiles.mp4

07:28

38 - percentiles.zip

39 - Grouping Sets.mp4

05:36

6 - Miscellaneous

40 - Terminology.zip

40 - Terminology Tips.mp4

10:15

41 - Parameters A Technique for Controlling the Environment.mp4

11:49

41 - parameters.zip

42 - ListAgg.mp4

05:11

42 - ListAgg.zip

43 - The Qualify Function.mp4

07:05

43 - qualifyfunction.zip

44 - The ILIKE Function.mp4

02:40

44 - ilike.zip

45 - The HASHAGG Function and Comparing Two Objects.mp4

03:45

45 - hashagg.zip

46 - Killing a Session Connection.mp4

01:33

47 - Monitoring Warehouse Usage.mp4

06:46

47 - warehouseusage.zip

48 - Date Extraction Confusion.mp4

04:26

48 - dateextractionconfusion.zip

49 - Convert a Permanent Table to Transient.mp4

03:23

50 - Generate a DDL Statement for an Object.mp4

02:59

50 - getddl.zip

51 - 20 Performance and MoneySaving Tips.mp4

09:05

7 - Test Your Knowledge

52 - Test Your Knowledge.mp4

02:00

Description

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

What You'll Learn?

Web UI tips and techniques
Working with query and results history
Dozens of SQL tips and techniques
Many cool features and functions of Snowflake
Techniques for analyzing data
Tips for monitoring warehouse usage

Who is this for?

Anyone who is in the role of Snowflake data engineer, data warehouse developer or data architect

What You Need to Know?

Some basic Snowflake experience would be helpful.

This would be considered an advanced beginner to intermediate level course for Snowflake users

More details

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

Who this course is for:
Anyone who is in the role of Snowflake data engineer, data warehouse developer or data architect

User Reviews

Rating

average 0

Total votes0

Focused display

Database Programming

Randy Minder

Instructor's Courses

Microsoft Certified Professional:Exam 70-778: Analyzing and Visualizing Data with Microsoft Power BI (January 2019 - 80% score)Snowflake Core Certification Exam (April 2021 - 90% score)Seasoned database engineer (OLTP, data warehouses, operational data stores), tabular modeling, business intelligence. Power BI, Snowflake and KQL. 20 years of software development using a variety of Microsoft technologies, mostly C#. 2016 Nominee for the First Solar Business Enablement CEO Award for Analytics Tools & Methods Infrastructure.StackOverflow reputation of 45,000 (top 1%)

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.