Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Udemy

EssentialSQL: Stored Procedures Unpacked - Code in TSQL

via Udemy

Overview

Stored Procedures Master Class| TSQL | Write SQL Server Stored Procs | Data Engineering, Data Analysis, DBA's | Cursors

What you'll 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.

Use TSQL to write stored procedures and scripts to automate data engineering and data analysis task. This is a great SQLcourse for a DBA to take if they want to stand out from other database administrators.


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 newbut not knowing where to start.

  • Wasting time learning the wrong features.

  • Being overwhelmed with options and not know which to use.

Imagine Having...

  • Knowledge - Knowing how to quickly write stored procedures to take your SQL to the next level.

  • Confidence - Feeling good that you’re on the right track.

  • Accomplishment - Having a sense of accomplishment that you've learned something most cannot.

  • Fun - Having fun learning about cursors, stored procedures, and triggers!

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 unintendeddatabase changes.

Now that’s cool!

Taught by

Kris Wenzel

Reviews

4.7 rating at Udemy based on 867 ratings

Start your review of EssentialSQL: Stored Procedures Unpacked - Code in TSQL

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.