Udemy – EssentialSQL: Stored Procedures Unpacked – Code in TSQL 2023-3

EssentialSQL: Stored Procedures Unpacked – Code in TSQL is a course on implementing and managing stored procedures in Transact-SQL (TSQL) published by Udemy Online Academy. This is a focused course that takes an in-depth look at creating, executing, and managing stored procedures in Transact-SQL (TSQL). The course simplifies complex database programming concepts and teaches people how to write efficient, reusable, and secure stored procedures to streamline database operations. It covers everything from basic syntax and error handling to advanced features like parameterized procedures, output values, and dynamic SQL.

Designed for both beginners and those looking to improve their SQL skills, this course provides practical examples and exercises to build real-world expertise. By the time you complete this course, you will appreciate stored procedure development, overcome your fear, and be able to write stored procedures that pass parameters, handle errors, and roll back unwanted database changes.

What you will learn in EssentialSQL: Stored Procedures Unpacked – Code in TSQL:

• Learn what a stored procedure is and how it differs from other types of SQL queries
• Learn how to pass parameters to and from stored procedures
• Learn how to use variables and control structures such as IF/ELSE and WHILE loops in stored procedures
• Learn how to debug, i.e. troubleshoot, a stored procedure
• Start transactions, detect errors, and automatically roll back changes
• Learn how to use cursors in stored procedures
• And…

Course specifications

Publisher: Udemy
Instructors: Kris Wenzel and Essential Sql
Language: English
Level: Introductory to Advanced
Number of Lessons: 45
Duration: 4 hours and 55 minutes

Course topics

EssentialSQL: Stored Procedures Unpacked – Code in TSQL Prerequisites

You should already be familiar with basic queries, such as SELECT, GROUP BY, and ORDER BY clauses.
Knowledge of basic programming concepts, such as IF/THEN is a plus, but not mandatory.

Pictures

EssentialSQL: Stored Procedures Unpacked – Code in TSQL introduction video

Installation guide

After Extract, watch with your favorite Player.

English subtitle

Quality: 720p

Download link

Download – 825 MB

Size

825 MB