Stored Procedures

SQL Server 2016    |    Intermediate
  • 9 videos | 1h 7m 16s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 64 users Rating 4.6 of 64 users (64)
A stored procedure in SQL Server 2016 is prepared SQL code that can be reused, improving performance, productivity, and ease of use. Discover how to work with stored procedures, including creating, editing, and handling errors.

WHAT YOU WILL LEARN

  • Design stored procedures components and structure based on business requirements
    Describe how to use the input and output parameters
    Demonstrate how to use table-valued parameters
    Implement return codes
    Streamline existing stored procedure logic
  • Implement error handling and transaction control logic within stored procedures
    Alter a stored procedure using the transact-sql alter procedure statement
    Obfuscate stored procedures using the with encryptions clause
    Configure constraints in sql server 2016

IN THIS COURSE

  • 9m 40s
    Learn how to design stored procedures, components, and structure based on business requirements. FREE ACCESS
  • 5m 11s
    After completing this video, you will be able to describe how to use input and output parameters. FREE ACCESS
  • Locked
    3.  Input and Output Parameters
    11m
    In this video, you will learn how to use table-valued parameters. FREE ACCESS
  • Locked
    4.  Table-valued Parameters
    10m 13s
    In this video, you will learn how to implement return codes. FREE ACCESS
  • Locked
    5.  Return Codes
    8m 26s
    In this video, find out how to streamline your existing stored procedure logic. FREE ACCESS
  • Locked
    6.  Stored Procedure Logic
    7m 57s
    During this video, you will learn how to implement error handling and transaction control logic within stored procedures. FREE ACCESS
  • Locked
    7.  Error Handling and Transaction Control Logic
    7m 52s
    In this video, you will alter a stored procedure using the Transact-SQL ALTER PROCEDURE statement. FREE ACCESS
  • Locked
    8.  Altering a Stored Procedure
    3m
    Learn how to encrypt stored procedures using the WITH ENCRYPTION clause. FREE ACCESS
  • Locked
    9.  Obfuscating Stored Procedures
    3m 57s
    In this video, you will configure constraints in SQL Server 2016. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Data Types & Normalization
Rating 4.6 of 124 users Rating 4.6 of 124 users (124)
Book High Performance SQL Server: Consistent Response for Mission-Critical Applications, Second Edition
Book Analytics Optimization with Columnstore Indexes in Microsoft SQL Server: Optimizing OLAP Workloads

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Memory-optimized Tables & Native Stored Procedures
Rating 4.6 of 27 users Rating 4.6 of 27 users (27)
Course SQL 2016 Tables
Rating 4.5 of 473 users Rating 4.5 of 473 users (473)
Course Programming in C#: Manipulating & Retrieving Data
Rating 4.3 of 60 users Rating 4.3 of 60 users (60)