Full Advanced Course: https://www.youtube.com/watch?v=ELdz0dXzWGM&list=PLNcg_FV9n7qZY_2eAtUzEUulNjTJREhQe
In today's Advanced SQL lesson we walk through how to use Stored Procedures step by step covering many topics like parameters, variables, error handling and control flow.

Free Materials (Downloads): https://datawithbaraa.substack.com
Support & Subscribe to Channel: http://bit.ly/3GiCVUE

Stay connected
► Subscribe: http://bit.ly/3GiCVUE
► LinkedIn: https://www.linkedin.com/in/baraa-khatib-salkini/
► Website: https://www.datawithbaraa.com
► Newsletter: https://bit.ly/BaraaNewsletter
► PayPal: https://paypal.me/baraasalkini
► Join: https://www.youtube.com/channel/UC8_RSKwbU1OmZWNEoLV1tQg/join

Free Courses
Tableau: https://youtu.be/UcGF09Awm4Y
Tableau Project: https://www.youtube.com/watch?v=UcGF09Awm4Y
SQL Basics: https://youtu.be/NTgejLheGeU?si=2-m6dgYPRvoFUSgS
SQL Advanced: https://www.youtube.com/watch?v=ELdz0dXzWGM&list=PLNcg_FV9n7qZY_2eAtUzEUulNjTJREhQe
ChatGPT: https://youtu.be/LJLNfei4i-c?si=EhUNYN38dkswAvZH

Other Platforms (Certifications)
► Udemy: https://bit.ly/BaraaUdemy
► Skillshare (1 Free Month): https://bit.ly/BaraaSkillshare

My favorite books: https://kit.co/DataWithBaraa/my-favorite-books
My gear: https://kit.co/DataWithBaraa/my-desktop-gear

⏱ Timestamp
00:00 - Intro
00:30 - What is Stored Procedure?
04:14 - Stored Procedure vs Query
06:05 - Stored Procedure vs Query
10:01 - Stored Procedure Basics
14:00 - Parameters
20:55 - Multiple Statements
24:01 - Variables
31:40 - Control Flow - IF ELSE
38:16 - Error Handling - TRY CATCH
43:35 - Styling Stored Procedure

#sql #sqlserver #data #analytics
**Please note I may earn a small commission for any purchase through these links, which means at no additional cost to you - Thanks for supporting the channel!**
**All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for**