Stored Procedures Unpacked: Learn to Code T-SQL Stored Procs (Udemy.com)

Learn to develop, code, & implement stored procedures, transactions, & cursors, in your SQL Server database using T-SQL.

Created by: Kris Wenzel

Produced in 2021

icon
What you will learn

  • Write bits of database code developers can call from other programs
  • Setup transactions, detect errors, and automatically rollback changes
  • Create reusable code to save time and make your queries easier to read
  • Use cursors to access specific rows withing a result.
  • Learn how to debug, that is troubleshoot, a stored procedure.

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 84 / 100

icon
Course Description

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 thanBeing 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 youre 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 youve complete this course youll 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 thats cool!
Who this course is for:
Beginner SQL query authors curious about combining SQL statements into transactions.
Developers looking to for a better way to develop and manage database code.
Analysts looking to create advanced data sources from SQL Server from Power BI.
Developers wanting to learn about database cursors.
Anyone who thinks that stored procedures are really scary (they aren't!) :)

icon
Instructor Details

Kris Wenzel

Hello my name is Kris. Im here because I am passionate about helping non-techie people to overcome their fear of learning SQL.
Let Me Help you Get Started on the Right Foot!
I know what it is like to not know where to start or whether the time spent learning is worth the effort. That is why I am here to help you to:
Get started in an easy to follow step-by-step manner.
Use your time wisely so you focus on what is important to learn to get the most value from your time.
Answer your questions. Really! Just post a comment and Ill respond. Im here to help.
It wasnt long ago that I was helping a colleague with some reporting. She didnt know where to start and soon got overwhelmed and lost as she didnt know SQL.
I felt really bad, as she was under pressure to get some summary information to her boss, the built-in reports were falling short, and to make them better would require her to know SQL. At that time that seemed impossible! It in dawned on me, it doesnt have to be that way.
Then I discovered a way for anyone with the desire to easily learn SQL. I worked with my co-worker, started to teach her what I learned and soon she was able to write reports and answer her boss questions without getting stressed or ploughing hours into manipulating data in Excel.
It hasnt always been easy. Sometimes the information seems abstract or too conceptual. In this case Ive found out that a visual explanation is best. I really like to use diagrams or vi

icon
More courses by Kris Wenzel

Subquery Magic: Write awesome SQL, Master T-SQL Sub Queries

$11.99

Database Normalization Simplified

$11.99

icon
More sql courses

SQL Server - zapytania. Querying. Exam 70-761

$11.99

Oracle Database 12c SQL Certified Associate 1Z0-071

$11.99

Introduction to Structured Query Language (SQL)

Free

Learn C# With Windows Forms and SQL Server

$11.99

Microsoft Access SQL: SQL for Non-Programmers

$11.99

The Ultimate Oracle SQL Course

$11.99

icon
Reviews

4.2

94 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

By ChengSee Lim on 11/22/2020

easy to follow and understand

By Simo Pedro Rocha Toga Machado on 11/15/2020

So far, so good

By Robles Duran on 11/15/2020

That excersices in this course not the same a this video, so I didn't practice

By John Wright on 11/8/2020

A great introduction to SQL.

By Eivar Rodriguez on 11/1/2020

very clear

By Julie Starling on 10/18/2020

It was frustrating that there is one unfinished lesson on debugging, which seems to be pointed out in the Q&A for months. Even after claiming to have fixed it, it still isn't. For that reason alone I have knocked it down a star as I didn't feel like I got anything out of the Debugging section, which is a shame as it was one of the reasons I bought the course as that was on the list of topics covered.

By Minke Pronk on 10/14/2020

hij vertelt een beetje saai

By Donald Killenbec on 10/6/2020

Will add my comments later in the course.

By Avihaish on 9/24/2020

very thorough course, great for beginners/intermedia.

By Aaron on 9/21/2020

Learned tsql programming concepts. I learned sql beyond the basics. this course was challenging . I learned alot.

By Christian Plankl on 9/10/2020

The screen seems sometimes a little bit blurry.

By Gillard Croney on 9/4/2020

Excellent, very much on point with good examples.