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
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.
Quality Score
Overall Score : 84 / 100
Course Description
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!) :)
Instructor Details
- 4.2 Rating
94 Reviews
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
More courses by Kris Wenzel
Subquery Magic: Write awesome SQL, Master T-SQL Sub Queries (2021)
4.3 (116 Reviews)
Provider: Udemy
Time: 2.5h
$11.99
More sql courses
SQL Server - zapytania. Querying. Exam 70-761 (2021)
4.8 (99 Reviews)
Provider: Udemy
Time: 5h
$11.99
Oracle Database 12c SQL Certified Associate 1Z0-071 (2021)
4.7 (336 Reviews)
Provider: Udemy
Time: 20h
$11.99
Introduction to Structured Query Language (SQL) (2017)
4.7 (313 Reviews)
Provider: Coursera
Time: 3h
Free
Learn C# With Windows Forms and SQL Server (2021)
4.7 (269 Reviews)
Provider: Udemy
Time: 12.5h
$11.99
Microsoft Access SQL: SQL for Non-Programmers (2021)
4.7 (240 Reviews)
Provider: Udemy
Time: 3.5h
$11.99










