Kris Wenzel
Before I Tell You All About This Life–Changing Program, Let’s Talk About Who This is Really For…
You are in the right place if you’re an ambitious professional who wants to learn stored procedures to expand their SQL skill set, open job opportunities, and advance their career.
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
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…
Knowledge – Knowing how to quickly write stored procedures to take your SQL to the next level.
Instructor Details
Courses : 4
Specification: Stored Procedures Unpacked: Learn to Code T-SQL Stored Procs
|
19 reviews for Stored Procedures Unpacked: Learn to Code T-SQL Stored Procs
Add a review
| Price | $17.99 |
|---|---|
| Provider | |
| Duration | 3.5 hours |
| Year | 2020 |
| Level | All |
| Language | English |
| Certificate | Yes |
| Quizzes | Yes |
$17.99
Prophecy –
Good lesson
David Keevis –
Good basic course. Section on cursors & transactions was very useful. Only basic error trapping and handling covered. Virtually no T SQL covered. Pace of each lesson was appropriate little time wasted on typing code which was a plus. Makes available all code examples and slides as resources which is helpful.
Xavier –
At first I had doubts that I could cover all this material in such a short course, but the way it is laid out with the assignments makes it a great learning tool. I feel comfortable writing my own code with cursors now and reviewing others.
Grahame Apted –
The title of the lecture obscures some of the details on the screen.. But so far apart for that minor irritation it matches what I need.
Juan M. Garcia –
very consized and interesting, great job.
Christian Schmitz–Moormann –
Clear, focused, good to follow.
Rich Rudaski –
Very good, very brief overview of SQL Server Stored Procedures. Extensive and varied use of debugging tools.
Christian Schmitz Moormann –
Clear, focused, good to follow.
P.J. Thierry –
did the course, but using SSMS 18 urged for some searching how to debug. using visual studio is the way to go as smss 18 does not support debugging anymore
Lance Gummere –
This was a good basic intro so far. I really like that you stayed focused and didn’t spend tons of time getting side tracked explaining unnecessary topics.
Martin Belak –
seems to be interesting. important to do easy steps forward.
Justin Fazzio –
Good intro course, however, the instructor uses tools, like the debugger, that are now deprecated in SSMS v18. Multiple questions, including several related to this deprecated feature, are left unanswered. So, at best, this course is useful if you are using SSMS 17.9 or below, but you might want to look elsewhere if you want to get responses to your questions and/or you want all the course content to be relevant with the most up to date SSMS software.
Dewakar Mahendru –
some real time examples should have discussed here
Rene Henriquez –
good explanations and a few practice exercises
Daniel Chen –
Good content
Prakash Singh –
good
Yuqing Wang –
So far so good, slow and clear explanation!
Simone Sindal –
very good and practical and for beginners. Very good
Sebastiaan Breedijk –
Would have liked to have more exercises, and more explanation on purpose of several used concepts.