STORED PROCEDURES UNPACKED
By the time you’ve completed this course you’ll have an appreciation of developing stored procedures, overcome your fear, and write stored procedures that pass parameters, handle errors, and rollback unintended database changes.
Now that’s cool!
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 want to learn stored procedures to expand their SQL skill set, open job opportunities, and advance their career.
- 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.
By the end of this program,
you will have…
Used stored procedures to implement business logic.
Developed stored procedures from scratch!
Learned basic troubleshooting and debugging skills.
Learned the right way to use cursors.
Applied database transaction techniques to commit or rollback your database changes.
Trapped and handled errors.
- Gained a valuable skill set to help you advance your career.
"This course is what I'm looking for! I'm a Production DBA, but I want to learn to write complex Stored Procedures.
By learning and practicing the lessons in the course, I'm able to understand the T-SQL codes that our developers wrote and as well as to contribute ideas when it comes to troubleshooting codes.
Furthermore, I will be more effective in code reviews if ever they require a DBA."
RICKY VALENCIA, DATABASE ADMINISRATOR
Great detail and clear concise explanations. I've been working with SQL for only a year and I think of you, out of all the tutorials and documents that I've been reading, actually explained in a unique way where it was the easiest to comprehend.
Thank you and keep them coming.
- Vince, Software Contractor
This is great, and I see you put a lot of effort to make it happen. Thank you.
I had taken many different SQL classes but never seen something like this.
It's great to finally get some real instruction - thanks
- Bhargav, Database Administrator
Your site has been extremely helpful, and I just want to say thank you for putting this course together. I have been using SQL for a few years now, but here and there I come across hurdles and this course has found to be helpful to understanding what I may be doing wrong.
Thanks again for all of your help. It is greatly appreciated!
P.S. If I could send cookies I would! :)
- Heather Q., Business Analyst
Thank you, Kris! I've done quite a bit of the class and I have to say your method of teaching is great. You don't just start with SQL and assume users have everything installed correctly. That puts you head and shoulders above the rest.
- Karen P
I really appreciate your way of teaching important SQL concepts in such a clear and progressive way. I had the impression I could find only either basic resources or very advanced ones. You fill that gap.
- Frederic V
Oh wow, you explained everything so well and thoroughly. Thank you so much for the help.
- Sarah, IT Professional
What’s Inside Stored Procedures Unpacked
Before we dig in to the details, we get a quick win learn about stored procedures, and then creating our first one!
What is a stored procedure? - I'll make sure you get the basic, have you covered.
Creating Your First Stored Procedure - We go through the steps to create our first working stored procedure in the first module. Why? This is to get you context. Once we dig into the details, this overview become a welcome reference.
Introduction and Learning Lab Setup
Before we dig in, I want to make sure you have all the tools ready to learn SQL. In this section we will go over the course set up, and then get your learning lab set up on your computer.
Setup Learning lab - I’ll show you how to get a free copy of SQL server and get it setup on your computer. We’ll use this in conjunction with our example database to do the challenge problems.
Step-By-Step Guide - Being we're coding programming stored procedures, its recommend you have access to the AdventureWorks database. I'll show you how to get it setup!
Stored Procedure Walk Through
In this module you'll learn about the main part of a stored procedure and the commands used to define a stored procedure.
Learn about a stored procedure's, input, execution, and output components.
Walk through the evolution of a query from simple statement to stored procedure.
Debugging Stored Procedures
Know how to find you programming mistakes will save you hours, tears, and your sanity! In this module I'll show you how to use some SQL tool to "peek" inside your stored procedure to understand the steps it is taking. They may not be the ones you think...
Learn how to use the Visual Studio Debugger.
Run your stored procedures statement by statement.
See variable values
In this module we'll cover all the basics of stored procedure control of flow. You'll learn how to define variables, and then use them in logic statement to determine what queries to perform next.
Every modle is accompanied with an assignment and quiz to ensure you understand the material.
This module is a course onto itself!
- Working With Variables - Declare and Set variable values.
- PRINT - Learn to send text and variable values to the messages window. This is useful for troubleshooting.
- Control of Flow - Learn "Control of Flow" statement such as IF-THEN and WHILE to guide your stored procedure's execution.
- You learn the following Statements:
- DECLARE, SET
- BEGIN, END
- IF-THEN ELSE
- WHILE, BREAK, CONTINUE
- GOTO, Label:
When things don't don't go to plan, it good to know how to trap errors and gracefully handle them within your stored procedure.
In this module we take a look at two main methods, structured and unstructured error handling, you'll use to trap and and handle execution exceptions.
Learn how to catch errors in your stored procedures and handle them using CATCH TRY statements and the function used to describe the error messages and severity.
Learn about unstructured programming. Though now CATCH/TRY is preferred, it still important to be able to read older code.
Creating and Executing Stored Procedures
Learn how to call stored procedures with parameters. Pass values into the stored procedure as well as out of it. Learn about the difference between an output parameter and return code.
Learn about the three main way you can return values from a stored procedure: result, parameter, return code.
Learn how to define parameters to pass into and out of your stored procedure.
Learn the proper way to use return codes.
Cursors and Transactions
Once you complete this module you'll know how to set up a database transactions and cursors to iterate through a result to commit or rollback updates, depending upon detected errors.
Explore how database transactions ensure multiple updates complete as a set before they are committed to the database, of if there's trouble, all changes can be rolled back.
Understand what a cursor is and why they are different from traditional SQL results.
Cursors defined using ISO syntax adhere to a standard used across many database platforms.
When you enroll during this special, limited time period,
Stored Procedures Unpacked
(A $449 Value)
Eight Modules to Level Up your SQL By the end of this course you'll have the confidence to write stored procedures.
Online Video Lectures and Demonstrations introduce you to cool concepts such as control-of-flow and error handling. You're sure to understand the material as plenty of visuals are used to enhance your learning.
Online challenge problems and quizzes for you to practice what you have learned. Each module has several quizzes and problem sets to help you practice.
Instructions to set up your own free learning lab. The lab is optional, but many are surprised and delighted to know they can get a full free working copy of Microsoft SQL server for their personal use. Together we'll get this up and running on your windows desktop or laptop.
Plus These Bonuses to Help You Level Up Your SQL
Weekly Office Hours
Each week I'm available to meet with you during "office hours" so I can answer any questions you have about what we're teaching in the course.
What You’ll Get:
- Priority access to get your questions answered in real-time.
- The support you need to ensure you successfully learn stored procedures.
- My commitment and thirty years of developer experience to help you learn.
Private, Members Only Group
Work with others and myself within a private group for the duration of the class. Together we'll motivate each other and help hold each other accountable to work through the modules. The goal of this group is for all of us to support each other, troubleshoot when we get stuck, and learn new tips and tricks to learn SQL.
What You’ll Get:
- You gain access to devoted SQL community of students.
- A safe place to ask questions and get advice.
- A place for support and education.
Stored Procedures Unpacked Risk Free 30 Day Guarantee
Stored Procedures Unpacked is the most digestible and user-friendly SQL learning program that not only helps you learn stored procedures, but also boosts your confidence writing SQL.
Now here's the kicker.
By the end of these 30 days, you'll have had access to every module. Meaning you'll have had the opportunity to learn all about writing stored procedures before deciding to move on.
If you don't feel totally confident and motivated by your progress, simply reach out, show us you've put in the work, and we'll refund your investment. Full Details here >>
Frequently Asked Questions
What people asked before signing up for FearlessSQL.
I don't have much time, can I get the course done in twelve weeks?
I have tried before to learn SQL and I always got stuck.
Why pay for this course?
Why enroll? Can't I just look this up on the Internet?
How much SQL should I know before taking this course?
When will the course be available?
Do you offer a guarantee?
Can you remind me of everything I’m getting when I sign up today?
Still thinking about it?
Stored Procedures Unpacked is PERFECT for you if…
- You are the person who’s just getting started with SQL scripting and wants to do it right.
- You have hit a wall, and need help learning more SQL.
- You feel stored procedures are a tough topic.
- You are already spending 4 hours a week studying, actively trying to learn intermediate SQL.
- You and a powerful and marketable skill to your resume!
- You are ready to 100% commit to learning stored procedures THIS YEAR using a proven roadmap.
I personally cannot wait to guide you over these next 12 weeks…
I’m so excited to share with you my approach to learning stored procedures. I wrote this course because I really love helping others. I have a knack for boiling complex topics down into simple to understand concepts and am looking forward helping you learn stored procedures.
I started using SQL in 1989. Today is it more popular than ever.
SQL has helped me advance my career. Over the years I’ve taken on several roles, from Software Developer to IT Manager. Throughout my journey one thing was constant – SQL was there, as a tool of choice to query databases.
Whether you’re a working business analyst or software developer, this course is for you. I’m really looking forward to helping level up your SQL by learning stored procedures.
Should you choose to accept my invitation, I personally guarantee that these next 12 weeks will be completely life changing.
I look forward to meeting you personally inside Stored Procedures Unpacked.