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
medium.com/@data-engineering-simplified - Read Medium Blog Pages For Articles
groups/627874916138090/ - Join Exclusive Snowflake Facebook Group
🚀🚀 Find all SQL Scripts + Examples in Medium Blog Page
medium.com/@data-engineering-simplified/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
ru-vid.com/group/PLba2xJ7yxHB5NksIHMPirkHhOoEG3-K09
✏ Ch-01 Snowflake Scripting For Stored Procedure Introduction ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--BhYp0X00P0.html
✏ Ch-02 Stored Procedures Are Anti-Pattern ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-rBwknyABYMU.html
✏ Ch-03 Snowflake Scripting Block Structure ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-yBaUbCFSMjM.html
✏ Ch-04 How To Declare Variable ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-CyJ9LPFMhwc.html
✏ Ch-05 Declare & Define Local Variables ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-pBDeMog56AQ.html
✏ Ch-06 How To Use Variables ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-U2gbypinWZs.html
✏ Ch-07 Multiple Variable Assignment ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-HlrcLrbPpD0.html
✏ Ch-08 Variable Visibility in nested block ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-TvzTr8HPdtM.html
✏ Ch-09 Return Value/Expression/Table From Stored Proc ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Gl0x4yxz_Ok.html
✏ Ch-10 IF ELSEIF ELSE IF-END ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-dmybW_lQuGA.html
✏ Ch-11 CASE/WHEN Conditional Logic ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-oRzIqDvhyWU.html
✏ Ch-12 FOR Loop ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-UzKb_TGtqpg.html
✏ Ch-13 WHILE Loop ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Q5UU5h7jdNU.html
✏ Ch-14 REPEAT Loop ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-eNovcmu4Qk4.html
✏ Ch-15 Work With CURSOR Object ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-MIy3k5SzqYk.html
✏ Ch-16 Param Binding & CURSOR Object ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-MIy3k5SzqYk.html
✏ Ch-17 Work With RESULTSET Object ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-MIy3k5SzqYk.html
✏ Ch-18 Exception Handling In Stored Procedure ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-mP-PqZsl4b8.html
#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.
12 мар 2024
