Skip to content
Write a review
UdemyIT & SoftwarePaid courseAll LevelsCertificate

Snowflake Scripting - Writing Stored Procedures Using SQL (Udemy.com)

Learn the concepts of Snowflake Scripting. And Learn how to write Stored Procedures and Functions using SQL Language.

4.6
377 reviews

Created by: Janardhana Reddy Bandi

Last updated October 2024

icon
What you will learn

  • Learn the concepts of Snowflake Scripting
  • Learn How to write Stored Procedures using SQL
  • Understand complex Stored Procedures written by others
  • Learn how to write User Defined Functions(UDFs) in SQL

How it compares

Against the other 1,182 rated Udemy courses in IT & Software on CourseDuck:

  • Rating4.6 out of 5higher than 67% of them
  • Reviews377#648 of 1,183 by number of reviews
  • Length10.2 hourslonger than 71% of them
  • Last updatedOctober 2024earlier than 61% of them

icon
Course Description

Hi, in this Snowflake Scripting course I have explained

1. The concepts of Snowflake Scripting.

2. Writing Stored Procedures.

3. Writing User Defined Functions(UDFs).

4. Generic Stored Procedures that can be used in Snowflake Projects.


This course will help you..

1. If you are struggling to understand complex stored procedures written by others.

2. If you want to write simple to complex stored procedures and User Defined Functions.

3. If you want to go through some procedures that can be implemented in your projects with small changes.


Below are the concepts I have explained in this course.

What is a stored procedure and blocks in a procedure

Variables

Table Literals

Identifiers

Flow Control Statements - Branching or Conditional(If Else and Case)

Flow Control Statements - Looping(For and While)

Cursors

Resultsets

Exception Handling

Transactions

Snowflake Information Schema


Below are the generic procedures and implementations explained.

1. Procedure for Automated Data Loads

2. SCD Type-1 implementation

3. SCD Type-2 implementation

4. Procedure for 1 to 1 View creation

5. Procedure for dropping all tables from a schema

6. Procedure for dropping all views from a schema

7. Procedure for migrating table DDL from one database to other database

8. Procedure for migrating views from one database to other database

9. Procedure for Automating Full load from staging to target tables

10. Procedure for Automating Delta/Incremental load from staging to target tables

11. Procedure for sample data setup for testing in lower environment

12. Code deployment using GitHub and Schema change
Read More All Levels All Levels product length iconTime: 10.2h

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Get the Udemy discount

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Janardhana Reddy Bandi

I have around 14 years of experience in Data Warehousing and Data migration projects by using the ETL tools like Informatica and DataStage. I have very good experience in writing SQL queries and stored procedures. I have hands-on experience in Shell scripting. After knowing the advantages of Snowflake, the cloud warehouse, I have started learning Snowflake and then Started working on Snowflake projects.  I have very good knowledge on Azure Data Factory, AWS Glue, DBT, PySpark, Pandas.

     Also I am a writer, I have a website  janaswritingsdotcom  where I write my experience, opinions, stories, quotes, telugu kavithalu etc..

Read More

icon
More courses by Janardhana Reddy Bandi

$74.99

All courses by Janardhana Reddy Bandi

icon
More IT & Software courses

$49.99

$10.99

$124.99

$19.99

$11.99

$19.99

All IT & Software courses

icon
Reviews

4.6

377 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

Write a review

By Sai Krishna on 8/24/2025

Great course. Gave me confidence to go through SPs in my company. For few topics I had to search myself but overall great course.

By Anonymized User on 7/28/2025

An incredibly well-structured and insightful course! Grateful for the clear explanations and practical examples throughout.

By Sumaya Alzuhairy on 9/8/2024

The instruct is wonderful. He is passionate of explaining the topic and trying to make it very clear.

By Zia Ur Rehman on 8/11/2024

Long codes are written and explained in a very fast way. I believe writing small codes with proper explanation is way more advantageous compared to what has been presented in the course.

By Manisha Dasari on 7/26/2024

Thank you for this wonderful course. I was struggling with writing and understanding stored procedures, but this course has been incredibly helpful in deepening my knowledge and grasp of the concepts. I highly recommend it to both beginners and experienced professionals; the content and clear explanations make it an invaluable resource.

By Srinivas Reddy on 7/21/2024

This course is a must-take for anyone looking to deepen their understanding of Store procedures. Whether you're a beginner or an experienced professional, the comprehensive content and superb conceptual explanations make this course invaluable. Highly recommended!

By Hema Velupala on 7/17/2024

Thank you sir ! It was a great course and gave me a better understanding on the design and functionality of stored procedures. I can say that this course is very easy to follow with, it actually covers all the things to start writing the procedures. I will recommend this course, to whoever wants to write the complex stored procedures.

By Srinivasa Rao on 7/16/2024

great explanation. He made the topics so simpler and easier to understand with the presentation. Please come up with more videos with your expertise.

By Prakash on 7/13/2024

The material was well-structured and engaging, with a strong emphasis on practical application. Instructor's explanations was clear, concise, and easy to follow, making even complex concepts accessible.

By Nagamani Mandava on 7/9/2024

Very detailed explanation. In depth explanation of concepts. Very easy to understand the course.

Showing all 10 reviews on CourseDuck

Read all 377 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 92 / 100

Snowflake Scripting - Writing Stored Procedures Using SQL
Visit course on Udemy Write a review
  • Video Duration: icon 10.2h
  • Price: $74.99
  • Provider: icon Udemy
  • Updated: icon October 2024
  • Level: All Levels All Levels
  • Language: icon English
  • Certificate: icon Yes
30-day money-back guarantee on most paid courses

Udemy Coupon Price Tracker

Udemy price history

For any issues or feature requests please email CourseDuck's Co-Founder at mkuhlman12@gmail.com