![Udemy - Snowflake Scripting - Writing Stored Procedures Using SQL Udemy - Snowflake Scripting - Writing Stored Procedures Using SQL](https://www.gfxtra31.com/uploads/posts/2024-07/1720425951668b9ddf540d2.jpg)
Language: English (US)
Learn the concepts of Snowflake Scripting. And Learn how to write Stored Procedures and Functions using SQL Language.
https://www.udemy.com/course/snowflake-scripting-stored-procedures/
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
TO MAC USERS: If RAR password doesn't work, use this archive program:
RAR Expander 0.8.5 Beta 4 and extract password protected files without error.
TO WIN USERS: If RAR password doesn't work, use this archive program:
Latest Winrar and extract password protected files without error.