Stored Procedures

SQL Server 2016
  • 9 Videos | 1h 11m 46s
  • Includes Assessment
  • Earns a Badge
Likes 38 Likes 38
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

  • Playable
    1. 
    Stored Procedures Overview
    9m 40s
    UP NEXT
  • Playable
    2. 
    Designing Stored Procedures
    5m 11s
  • Locked
    3. 
    Input and Output Parameters
    11m
  • Locked
    4. 
    Table-valued Parameters
    10m 13s
  • Locked
    5. 
    Return Codes
    8m 26s
  • Locked
    6. 
    Stored Procedure Logic
    7m 57s
  • Locked
    7. 
    Error Handling and Transaction Control Logic
    7m 52s
  • Locked
    8. 
    Altering a Stored Procedure
    3m
  • Locked
    9. 
    Obfuscating Stored Procedures
    3m 57s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 23 Likes 23  
Likes 31 Likes 31  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 1602 Likes 1602  
COURSE SQL Developer
Likes 152 Likes 152  
Likes 166 Likes 166