In this Snowflake SQL scripting developer's guide, you would learn about CURSOR objects and how it has to be used while working with stored procedure as well as anonymous block.

Upon completing the "Working With CURSOR Objects " chapter-15, you'll be ready to answer the following questions:
1. How to use CURSOR objects in a stored procedure?
2. How to use fetch keyword when working with CURSOR object
3. How to iterate through a cursor and fetch individual field value from rows?

🚀🚀 Data Engineering Simplified - Social Links
  / learn_dataengineering   - Connect Via Instagram
  / data-engineering-simplified   - Read Medium Blog Pages For Articles
  / 627874916138090   - Join Exclusive Snowflake Facebook Group

🚀🚀 Find all SQL Scripts + Examples in Medium Blog Page
  / f3a1bd5659e0   (Medium Blog Page For SQL Script)

🚀🚀 Chapters
--------------------------
➥ 00:00 Introduction
➥ 00:55 Scope of this video
➥ 01:18 Welcome Note
➥ 01:54 Part-01 CURSOR Object Construct
➥ 05:59 Part-02 Iterating Cursor
➥ 10:22 Part-03 Local CURSOR Definition
➥ 11:38 Part-04 Error Msg With Cursor
➥ 16:25 Part-05 Fetch Keyword
➥ 19:02 Part-06 Cursor inside Cursor
➥ 20:49 Part-07 Cursor & Resultset
➥ 22:38 Summary & Next Part
➥ 22:55 Thank You Note


🚀🚀 Snowflake Stored Procedure Playlist
   • Snowflake SQL Scripting For Stored Pr...  
✏ Ch-01 Snowflake Scripting For Stored Procedure Introduction    • Complete Snowflake SQL Scripting For ...  
✏ Ch-02 Stored Procedures Are Anti-Pattern    • Snowflake Stored Procedures Are Anti-...  
✏ Ch-03 Snowflake Scripting Block Structure    • Snowflake Scripting Block Structure F...  
✏ Ch-04 How To Declare Variable    • Snowflake Scripting - How To Declare ...  
✏ Ch-05 Declare & Define Local Variables    • Snowflake SQL Scripting - Work With L...  
✏ Ch-06 How To Use Variables    • Snowflake SQL Scripting - How To Use ...  
✏ Ch-07 Multiple Variable Assignment    • Snowflake Scripting - Assign Multiple...  
✏ Ch-08 Variable Visibility in nested block    • Stored Procedure - Variable Scope & V...  
✏ Ch-09 Return Value/Expression/Table From Stored Proc    • Stored Procedure - How To RETURN A Va...  
✏ Ch-10 IF ELSEIF ELSE IF-END    • Exploring IF-ELSE Conditional Logic i...  
✏ Ch-11 CASE/WHEN Conditional Logic    • How To Use CASE/WHEN Conditional Logi...  
✏ Ch-12 FOR Loop    • Working With FOR Loops | Snowflake Sc...  
✏ Ch-13 WHILE Loop    • Working With WHILE Loop | Snowflake S...  
✏ Ch-14 REPEAT Loop    • Working With REPEAT Loop | Snowflake ...  
✏ Ch-15 Work With CURSOR Object    • Working With CURSOR Object | Snowflak...  
✏ Ch-16 Param Binding & CURSOR Object    • Working With CURSOR Object | Snowflak...  
✏ Ch-17 Work With RESULTSET Object    • Working With CURSOR Object | Snowflak...  
✏ Ch-18 Exception Handling In Stored Procedure    • Complete Exception Handling Guide | S...  





#storedprocedure
#snowflakecomputing
#snowflakedatawrehouse
#snowflake
#dataengineeringsimplifed
#DESimplified
#dataengineering
#clouddatawarehouse






Disclaimer: All snowflake-related learning materials and tutorial videos published in this channel are the personal opinions of the data engineering simplified team and they're neither authorized by nor associated with Snowflake, Inc.