SQL Extensibility Features with Snowflake 5

Focused View

Pinal Dave

1:02:13

97 View

1. Course Overview

1. Course Overview.mp4

01:24

02. Getting Started with Stored Procedures and User-defined Functions

01. Version Check.mp4

00:15

02. Introduction.mp4

02:24

03. What Is a Stored Procedure (SP).mp4

03:46

04. What Is a User-Defined Function (UDF).mp4

02:02

05. Comparison - SP vs. UDF.mp4

02:13

06. Demo - Creating Stored Procedures.mp4

06:33

07. Demo - Stored Procedures Advanced Concepts.mp4

08:33

08. Demo - Creating User-defined Functions.mp4

06:30

09. Demo - User-defined Functions Advanced Concepts.mp4

05:13

10. Summary.mp4

01:26

3. Understanding Views and Secure Views

1. Introduction.mp4

00:50

2. What Is a View.mp4

01:21

3. Non-materialized and Materialized Views.mp4

03:26

4. What Is a Secure View.mp4

01:58

5. Demo - Non-materialized Views.mp4

04:39

6. Demo - Materialized Views.mp4

04:49

7. Demo - Secure Views.mp4

03:22

8. Summary.mp4

01:29

Description

This course will teach you how to use various SQL extensibility features like stored procedures, user-defined functions, and views in the Snowflake data cloud platform.

What You'll Learn?

Snowflake provides a number interfaces that you can use to write an application that connects to Snowflake. In this course, SQL Extensibility Features with Snowflake 5, you’ll learn to use various SQL extensibility features and their significance on the Snowflake data cloud platform. First, you’ll explore stored procedures and their advantages. Next, you’ll discover user-defined functions with their use cases. Finally, you’ll learn how to use views and keep them secure. When you’re finished with this course, you’ll have the skills and knowledge of building reusable SQL components needed to build scalable Snowflake data in the cloud.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Data Analysis

Microsoft SQL

Pinal Dave

Instructor's Courses

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 21 years of hands-on experience. He holds a Master of Science degree and numerous database certifications. Pinal has authored 14 SQL Server database books and 45 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,500 database tech articles on his blog at https://blog.sqlauthority.com.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.