Course content

  • 1

    Introduction

  • 2

    Getting started with SQL Server Stored Procedures

  • 3

    Stored Procedures: Using Control-Flow statements

    • If-Else: Control Flow Statement

    • While: Control Flow Statement

    • Break: Control Flow Statement

    • Continue: Control Flow Statement
  • 4

    Stored Procedures: Using CURSOR

    • Using CURSOR in Stored Procedures
  • 5

    Stored Procedures: Handling Exceptions

    • Handling Exceptions in Stored Procedures: Using Try Catch

    • Handling Exceptions in Stored Procedures: Using RaiseError

    • Handling Exceptions in Stored Procedures: Using Throw
  • 6

    Stored Procedures: Using dynamic SQL

    • Using dynamic SQL in Stored Procedures
  • 7

    Working with Functions

    • System-defined scalar function

    • System-defined aggregate function

    • User-defined scalar function

    • User-defined inline table-valued function

    • User-defined multi-statement table-valued function
  • 8

    Course completion

    • Thank You!