EssentialSQL: Stored Procedures Unpacked – Code in TSQL

EssentialSQL: Stored Procedures Unpacked – Code in TSQL, available at $89.99, has an average rating of 4.51, with 45 lectures, 5 quizzes, based on 1149 reviews, and has 6503 subscribers.

You will learn about Understand what a stored procedure is and how it differs from other types of SQL queries. Understand how to pass parameters to and from stored procedures. Know how to use variables and control structures such as IF/ELSE and WHILE loops within stored procedures. Learn how to debug, that is troubleshoot, a stored procedure. Setup transactions, detect errors, and automatically rollback changes Understand how to use cursors in stored procedures. This course is ideal for individuals who are Beginner SQL query authors curious about combining SQL statements into transactions. or Anyone looking to take a class whose singular purpose is to teach you stored procedures. or Anyone who thinks that stored procedures are really scary (they aren't!) 🙂 or Developers wanting to learn about database cursors. or Analysts looking to create advanced data sources from SQL Server from Power BI. or Developers looking to for a better way to develop and manage database code. It is particularly useful for Beginner SQL query authors curious about combining SQL statements into transactions. or Anyone looking to take a class whose singular purpose is to teach you stored procedures. or Anyone who thinks that stored procedures are really scary (they aren't!) 🙂 or Developers wanting to learn about database cursors. or Analysts looking to create advanced data sources from SQL Server from Power BI. or Developers looking to for a better way to develop and manage database code.

Enroll now: EssentialSQL: Stored Procedures Unpacked – Code in TSQL

Summary

Title: EssentialSQL: Stored Procedures Unpacked – Code in TSQL

Price: $89.99

Average Rating: 4.51

Number of Lectures: 45

Number of Quizzes: 5

Number of Published Lectures: 45

Number of Published Quizzes: 5

Number of Curriculum Items: 60

Number of Published Curriculum Objects: 60

Original Price: $89.99

Quality Status: approved

Status: Live

What You Will Learn

Understand what a stored procedure is and how it differs from other types of SQL queries.
Understand how to pass parameters to and from stored procedures.
Know how to use variables and control structures such as IF/ELSE and WHILE loops within stored procedures.
Learn how to debug, that is troubleshoot, a stored procedure.
Setup transactions, detect errors, and automatically rollback changes
Understand how to use cursors in stored procedures.

Who Should Attend

Beginner SQL query authors curious about combining SQL statements into transactions.
Anyone looking to take a class whose singular purpose is to teach you stored procedures.
Anyone who thinks that stored procedures are really scary (they aren't!) 🙂
Developers wanting to learn about database cursors.
Analysts looking to create advanced data sources from SQL Server from Power BI.
Developers looking to for a better way to develop and manage database code.

Target Audiences

Beginner SQL query authors curious about combining SQL statements into transactions.
Anyone looking to take a class whose singular purpose is to teach you stored procedures.
Anyone who thinks that stored procedures are really scary (they aren't!) 🙂
Developers wanting to learn about database cursors.
Analysts looking to create advanced data sources from SQL Server from Power BI.
Developers looking to for a better way to develop and manage database code.

Use TSQL to write stored procedures and scripts to automate data engineering and data analysis task. This is a great SQL course for a DBA to take if they want to stand out from other database administrators. Learn Database Programming concepts using SQL Server stored procedures.

Whether You’re:

A developer looking to secure your app with stored procedures.
A consultant looking to expand your tool set
An IT professional looking to read and understand database code
An analyst looking to parametrize PowerBI queries for SQL data analysis
A sql server DBA looking to build their SQL server database administrator skills

You’re in the right place and I’m going to tell you exactly how Stored Procedure Unpacked gives you the tools, inspiration, and unparalleled support on your journey to level up your SQL skills.

In this Course you will Learn to:

Use stored procedures to implement business logic.
Develop stored procedures from scratch!
Learn some basic troubleshooting skills.
Know the right way to use cursors.
Apply database transaction techniques to commit or rollback your database changes.
Trap and handle errors.

Nothing is worse than:

Being excited to learn something new but not knowing where to start.
Wasting time learning the wrong features.
Being overwhelmed with options and not know which to use.

Imagine having the knowledge to know how to quickly write stored procedures to take your SQL to the next level. The confidence confidence that you’re on the right track. A sense of accomplishment, you have learned something most cannot.

By the time you’ve complete this course you’ll have an appreciation of developing stored procedures, overcome your fear, and able to write stored procedures that pass parameters, handle errors, and rollback unintended database changes.

Now that’s cool!

Course Curriculum

Chapter 1: Introduction

Lecture 1: Welcome to the Course

Lecture 2: What is a Stored Procedure and why do we need them?

Lecture 3: Creating Your First Stored Procedure

Lecture 4: How to take this course

Lecture 5: Create Your Own Stored Procedure – Challenge

Lecture 6: Create Your Own Stored Procedure – Answer

Chapter 2: Setup Your Learning Lab (Optional)

Lecture 1: Download SQL Server

Lecture 2: Install SQL Server

Lecture 3: Download and Install SSMS

Lecture 4: Download Sample Databases

Lecture 5: Restore Sample Databases

Lecture 6: Setup Interactive Debugging

Chapter 3: Stored Procedure Walk Through

Lecture 1: Introduction

Lecture 2: Parts of a Stored Procedure

Lecture 3: Defining a Stored Procedure

Lecture 4: Do you have any questions?

Chapter 4: Debugging Stored Procedures

Lecture 1: What is Debugging?

Lecture 2: Interactive Debugging with Visual Studio

Chapter 5: Programming Concepts

Lecture 1: Working with Variables and Print

Lecture 2: BEGIN END Code Blocks

Lecture 3: IF THEN Logic

Lecture 4: WHILE Loops

Lecture 5: WHILE Loops Example – Counting to 10

Lecture 6: WHILE Loops Example – Creating Weekly Calendar

Lecture 7: WHILE Loops Example – Using the BREAK statement

Lecture 8: WAITFOR Statement

Lecture 9: GOTO and Labels

Lecture 10: RETURN

Chapter 6: Error Catching

Lecture 1: Unstructured Error Handling using @@ERROR

Lecture 2: Unstructured Error Handling Example

Lecture 3: Structured Error Trapping with TRY and CATCH

Lecture 4: TRY CATCH Example

Lecture 5: Logging Errors

Chapter 7: Creating and Executing Stored Procedures

Lecture 1: Overview

Lecture 2: Input and Output Parameters

Lecture 3: Input and Output Parameter Examples

Lecture 4: Creating LogWrite using Parameters

Lecture 5: Returning Results with SELECT

Lecture 6: Return Codes

Chapter 8: Cursors and Transactions

Lecture 1: Transactions

Lecture 2: Introduction to Cursors

Lecture 3: ISO versus Non-ISO Cursor Syntax

Lecture 4: FETCH Command

Lecture 5: Case Study

Chapter 9: Wrap-up

Lecture 1: Bonus Lecture

Instructors

Kris Wenzel
Let me teach you SQL using simple to understand English.
Essential Sql
Learn everything you need to use SQL in your next project

Rating Distribution

1 stars: 19 votes
2 stars: 21 votes
3 stars: 153 votes
4 stars: 410 votes
5 stars: 546 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu