ENROLL NOW

Enhance Your SQL Server Skills by Mastering Stored Procedures

 

A step-by-step program to help you learn SQL Server stored procedure programming... so you can be confident in your job working with SQL Server

Before I tell you all about this program, let's make sure you're a good fit.

If you are:

  • A database developer or professional wants to learn how stored procedures, functions, and triggers work, so you can be effective in your job and contribute to your team's projects.
  • A data analyst who wants to understand stored procedure programming so they can retrieve their data effectively
  • A software developer that works with a database for an application and wants to either understand existing stored procedures or contribute to new stored procedures.

You're in the right place!

Effective SQL Server Stored Procedures will take you from the basics to more advanced concepts of stored procedure programming, so you can understand and use these concepts in your job.

By the end of this program,

you will…

 

  • Be Able to Write a Basic Stored Procedure

    You'll be able to create a simple stored procedure in SQL Server: the classic "hello world", so you can get something running quickly.

  • Understand and Use Variables and Parameters

    You'll be clear on what variables and parameters are used for and how to use them in procedures to improve your code.

  • Know How to Control the Flow of Your Code

    You'll learn a range of features to control how your code runs, such as IF statements and loops.

  • Learn How to Find, Fix, and Prevent Errors

    You'll learn and implement commonly-used practices in software development such as version control, debugging your code, testing your procedures, and handling errors.

  • Create Functions and Triggers

    You'll learn how to use procedural code in other objects: functions and triggers, and how to use them effectively.

  • Learn and Understand Advanced Concepts

    You'll also learn more advanced concepts with procedural programming, such as cursors, performance considerations, creating modular code, and making changes to your code.

"Ben has simplified sub-queries for me, regex, and many other topics. I feel slow when reading a lot of explanations off the internet, but his explanations are so clear, they make these topics easy to understand."

Nancy T, Database Star Academy member

Enroll in Effective SQL Server Stored Procedures Today

A One-Time Payment of

$97 USD

BUY NOW
  • 10 high-quality video modules (58 lessons)
  • SQL Scripts
  • Complete Course PDF

Your explanations are so clear and concise that you don’t need to go on and on and on as I have heard others do.

- Donna M

 

The brevity of lessons are more manageable and the progression is well designed.

- Merri H

 

I have learnt a lot by following your site which cannot be described in words. Examples given after each topic are very useful. The videos are simple, informative and easy to understand. 

- Korlahalli S

 

What’s Inside Effective SQL Server Stored Procedures

 

Module 1

Your First Stored Procedure

If stored procedures are new to you, you'll appreciate this module, where you'll learn and write your very first simple stored procedure.

Module Highlights:

  • Learn what a stored procedure is and why use them.
  • How to create a simple stored procedure.
  • How to execute or run a stored procedure.
  • How to make changes to a stored procedure.
Module 2

Variables and Parameters

Once you've got a stored procedure, you can improve it by using variables within the procedure and parameters when calling the procedure.

Module Highlights:

  • Step-by-step instructions on setting up the sample database (Wide World Importers).
  • Creating and using variables in your procedure.
  • Using input parameters in your procedure.
  • Understanding and using output parameters.
  • Inserting, updating, and selecting data within a stored procedure.
Module 3

Version Control

Version control is a fundamental practice of software development. You'll learn what it is and how to implement it with your code, making you more effective in your current and future roles.

Module Highlights:

  • What is version control and why you should use it
  • How to set up your GitHub account and code repository
  • How to add files to your repository
Module 4

More Stored Procedures

You'll learn more about stored procedures and how to control the flow of your code.

Module Highlights:

  • How to control the flow of your code using IF and ELSE statements.
  • How to use loops in your code and why you may not want to.
  • Handling and logging errors in your procedure.
  • A setting you can change to improve your procedures.
Module 5

Debugging

In this module, you'll learn how to debug your procedure code to find and fix bugs or issues you may have.

Module Highlights:

  • What is debugging and why you should do it.
  • How to download and set up the tool for debugging (Microsoft Visual Studio).
  • How to debug a stored procedure in Visual Studio.
Module 6

Improving Your Code

There are a range of strategies that you can use to improve your procedure code, which we'll cover in this module.

Module Highlights:

  • What is "modular code" and how it can help.
  • How to call a procedure from another procedure.
  • How to pass errors to other parts of your code.
  • How and why to add comments to your code.
Module 7

Functions

You can also create user-defined functions using procedural programming in SQL Server, and you'll learn all about that in this module.

Module Highlights:

  • What is a user-defined function (UDF) and why use them.
  • How to create a user-defined function.
  • How to execute a user-defined function.
Module 8

Triggers

Triggers are objects that can use procedural code, and you'll learn how to create and use them in this module.

Module Highlights:

  • What are triggers and why you would use them.
  • The drawbacks of using triggers.
  • Creating a simple trigger.
  • How to implement an audit table using triggers.
Module 9

Testing

The ability to test your procedural code has many benefits, and you'll learn why and how in this module.

Module Highlights:

  • What is testing and why you should test your code.
  • How to set up the testing framework for your tests.
  • How to write and execute tests on your stored procedures.
Module 10

Advanced Concepts

There are a range of advanced concepts you can learn and apply to your stored procedure development.

Module Highlights:

  • What is a cursor, why use them, and why not to use them.
  • A process to follow to make code changes when requirements change.
  • A range of things to consider to improve the performance of your stored procedures.

When you enroll during this special, limited time period,

you’ll get:

 

Effective SQL Server Stored Procedures

 

  • 10 Modules

    A step-by-step roadmap to follow to become confident with writing and working with stored procedures, starting with the very basics and moving onto more advanced concepts.

  • Comments for Questions and Answers

    You'll have access to the built-in comments where you can ask questions to me and other members, and provide answers on other posts.

Plus These Bonuses to Help You Work With SQL Server Stored Procedures

 

Bonus 1

SQL Scripts

A collection of SQL files used in the course and as extra support to help you save time.

What You’ll Get:

  • SQL scripts used within each lesson, so you can save time when following along rather than typing what you see on the screen.
  • SQL scripts to support your procedure development, such as querying the data dictionary.
Bonus 2

Complete Course PDF

A PDF file with the complete course included, so you can read it offline and use as a reference.

What You’ll Get:

  • A single PDF with all lessons included, so you can refer to it in the future
  • PDF includes screenshots and SQL so you know what scripts and screens are being referenced

Here’s what you’re getting when you enroll today:

Effective SQL Server Stored Procedures

  • SQL Scripts
  • Complete Course PDF

 

When you enroll today, you’ll get access to everything for just:

A One-Time Payment of

$97 USD

BUY NOW

30-Day Money Back Guarantee

I'm very confident that this course can help you learn and understand SQL Server stored procedures.
If you enrol in this course, and are not satisfied, let me know within 30 days of enrolling and I'll provide a refund for you.

Frequently Asked Questions

Enroll in Effective SQL Server Stored Procedures

A One-Time Payment of

$97 USD

BUY NOW
  • 10 high-quality video modules (58 lessons)
  • SQL Scripts
  • Complete Course PDF

Still thinking about it?

You should give Effective SQL Server Stored Procedures a 30-day risk-free shot if you're motivated by any of the following:

  1. You know the basics of SQL Server and want to use procedural programming to improve your code.
  2. You often work with stored procedures, functions, or triggers, and want to understand them better.
  3. You work on an application that calls stored procedures and want to better understand them and use them.
  4. Ready to take the actions needed to improve your SQL Server skills.

I can’t wait for you to join Effective SQL Server Stored Procedures

I created this course because SQL Server stored procedures are a great topic to learn if you work with SQL Server.

So much of the material out there is hard to follow and goes into more detail than you need to know.

As someone who works with data, it's important to understand how stored procedures work, so you can use them when the need arises, contribute more effectively to your team, and help you get a job in the future.

Knowing how to write and work with SQL Server stored procedures will serve you for years to come.

All it takes is a small investment in your education, and practicing the strategies highlighted in the course.

You're in the right place, and this is the course for you.

There's no risk to joining, with my 30-day money back guarantee.

I hope to see you inside.

Ben Brumm

Enroll in Effective SQL Server Stored Procedures Today

A One-Time Payment of

$97 USD

BUY NOW
  • 10 high-quality video modules (58 lessons)
  • SQL Scripts
  • Complete Course PDF