Uploaded February 2024 | Updated September 2026, 1 hour ago
Discover everything about CASE/WHEN conditional logic in Snowflake SQL Scripting with this hands-on video tutorial. Learn about simple and searched CASE/WHEN constructs, and how to use them in your stored procedures and anonymous block.
Get the hang of nested CASE/WHEN statements and understand the importance of semicolons and brackets while working with CASE/WHEN conditional logic. This guide will help you navigate CASE/WHEN statements, making your stored procedures and anonymous block more effective and boosting your skills.
Upon completing the "Exploring CASE/WHEN Conditional Logic in Depth" chapter-11, you'll be ready to answer the following questions:
1. How to apply and use CASE/WHEN conditional logic a SQL based stored procedure?
2. How to debug and understand the syntax error message while working with SQL based stored procedure?
3. Difference between simple/searched CASE/WHEN conditional logic?
3. How to write nested blocked within CASE/WHEN conditional logic?
5. How to use the AND/OR operator while working with CASE/WHEN condition?
🚀🚀 Data Engineering Simplified - Social Links
instagram.com/learn_dataengineering - Connect Via Instagram
medium.com/@data-engineering-simplified - Read Medium Blog Pages For Articles
facebook.com/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
➥ 01:01 Scope of this video
➥ 01:31 Welcome Note
➥ 02:36 Simple CASE/When SQL Construct
➥ 04:06 Searched CASE/When SQL Construct
➥ 09:24 Case-01 CASE/When in Action
➥ 07:11 Case-02 Must & Optional Items
➥ 08:05 Case-03 Error/Debugging Msg
➥ 10:14 Case-04 Multiple Expression With Case/When
➥ 13:54 Case-05 Searched Case Statement
➥ 16:20 Case-06 Support for DDL/DML
➥ 18:17 Case-07 Nested Block Within Case/When
➥ 20:14 Summary & Next Part
➥ 20:23 Thank You Note
🚀🚀 Snowflake Stored Procedure Playlist
youtube.com/playlist?list=PLba2xJ7yxHB5NksIHMPirkHhOoEG3-K09
✏ Ch-01 Snowflake Scripting For Stored Procedure Introduction youtu.be/-BhYp0X00P0
✏ Ch-02 Stored Procedures Are Anti-Pattern youtu.be/rBwknyABYMU
✏ Ch-03 Snowflake Scripting Block Structure youtu.be/yBaUbCFSMjM
✏ Ch-04 How To Declare Variable youtu.be/CyJ9LPFMhwc
✏ Ch-05 Declare & Define Local Variables youtu.be/pBDeMog56AQ
✏ Ch-06 How To Use Variables youtu.be/U2gbypinWZs
✏ Ch-07 Multiple Variable Assignment youtu.be/HlrcLrbPpD0
✏ Ch-08 Variable Visibility in nested block youtu.be/TvzTr8HPdtM
✏ Ch-09 Return Value/Expression/Table From Stored Proc youtu.be/Gl0x4yxz_Ok
✏ Ch-10 IF ELSEIF ELSE IF-END youtu.be/dmybW_lQuGA
✏ Ch-11 CASE/WHEN Conditional Logic youtu.be/oRzIqDvhyWU
✏ Ch-12 FOR Loop youtu.be/UzKb_TGtqpg
✏ Ch-13 WHILE Loop youtu.be/Q5UU5h7jdNU
✏ Ch-14 REPEAT Loop youtu.be/eNovcmu4Qk4
✏ Ch-15 Work With CURSOR Object youtu.be/MIy3k5SzqYk
✏ Ch-16 Param Binding & CURSOR Object youtu.be/MIy3k5SzqYk
✏ Ch-17 Work With RESULTSET Object youtu.be/MIy3k5SzqYk
✏ Ch-18 Exception Handling In Stored Procedure youtu.be/mP-PqZsl4b8
#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.
Discover everything about CASE/WHEN conditional logic in Snowflake SQL Scripting with this hands-on video tutorial. Learn about simple and searched CASE/WHEN constructs, and how to use them in your stored procedures and anonymous block.
Get the hang of nested CASE/WHEN statements and understand the importance of semicolons and brackets while working with CASE/WHEN conditional logic. This guide will help you navigate CASE/WHEN statements, making your stored procedures and anonymous block more effective and boosting your skills.
Upon completing the "Exploring CASE/WHEN Conditional Logic in Depth" chapter-11, you'll be ready to answer the following questions:
1. How to apply and use CASE/WHEN conditional logic a SQL based stored procedure?
2. How to debug and understand the syntax error message while working with SQL based stored procedure?
3. Difference between simple/searched CASE/WHEN conditional logic?
3. How to write nested blocked within CASE/WHEN conditional logic?
5. How to use the AND/OR operator while working with CASE/WHEN condition?
🚀🚀 Data Engineering Simplified - Social Links
instagram.com/learn_dataengineering - Connect Via Instagram
medium.com/@data-engineering-simplified - Read Medium Blog Pages For Articles
facebook.com/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
➥ 01:01 Scope of this video
➥ 01:31 Welcome Note
➥ 02:36 Simple CASE/When SQL Construct
➥ 04:06 Searched CASE/When SQL Construct
➥ 09:24 Case-01 CASE/When in Action
➥ 07:11 Case-02 Must & Optional Items
➥ 08:05 Case-03 Error/Debugging Msg
➥ 10:14 Case-04 Multiple Expression With Case/When
➥ 13:54 Case-05 Searched Case Statement
➥ 16:20 Case-06 Support for DDL/DML
➥ 18:17 Case-07 Nested Block Within Case/When
➥ 20:14 Summary & Next Part
➥ 20:23 Thank You Note
🚀🚀 Snowflake Stored Procedure Playlist
youtube.com/playlist?list=PLba2xJ7yxHB5NksIHMPirkHhOoEG3-K09
✏ Ch-01 Snowflake Scripting For Stored Procedure Introduction youtu.be/-BhYp0X00P0
✏ Ch-02 Stored Procedures Are Anti-Pattern youtu.be/rBwknyABYMU
✏ Ch-03 Snowflake Scripting Block Structure youtu.be/yBaUbCFSMjM
✏ Ch-04 How To Declare Variable youtu.be/CyJ9LPFMhwc
✏ Ch-05 Declare & Define Local Variables youtu.be/pBDeMog56AQ
✏ Ch-06 How To Use Variables youtu.be/U2gbypinWZs
✏ Ch-07 Multiple Variable Assignment youtu.be/HlrcLrbPpD0
✏ Ch-08 Variable Visibility in nested block youtu.be/TvzTr8HPdtM
✏ Ch-09 Return Value/Expression/Table From Stored Proc youtu.be/Gl0x4yxz_Ok
✏ Ch-10 IF ELSEIF ELSE IF-END youtu.be/dmybW_lQuGA
✏ Ch-11 CASE/WHEN Conditional Logic youtu.be/oRzIqDvhyWU
✏ Ch-12 FOR Loop youtu.be/UzKb_TGtqpg
✏ Ch-13 WHILE Loop youtu.be/Q5UU5h7jdNU
✏ Ch-14 REPEAT Loop youtu.be/eNovcmu4Qk4
✏ Ch-15 Work With CURSOR Object youtu.be/MIy3k5SzqYk
✏ Ch-16 Param Binding & CURSOR Object youtu.be/MIy3k5SzqYk
✏ Ch-17 Work With RESULTSET Object youtu.be/MIy3k5SzqYk
✏ Ch-18 Exception Handling In Stored Procedure youtu.be/mP-PqZsl4b8
#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.
