Snowflake_Scripting_Course

In this Snowflake Scripting course I have Learned

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 has helped me..

1. To understand complex stored procedures written by others.

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

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

Below are the concepts I have Learned 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

What I have learn Learnt the concepts of Snowflake Scripting Learnt How to write Stored Procedures using SQL Understood complex Stored Procedures written by others Learnt how to write User Defined Functions(UDFs) in SQL Are there any course requirements or prerequisites? Basic idea on Snowflake Cloud Basic SQL Knowledge Knowledge on any programming language will be added advantage Who this course is for: Who is working on Snowflake Projects Who is struggling to Understand the complex Stored Procedures Who is struggling to write Stored Procedures and UDFs