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 Querying SQL Databases: Learning SQL Using Prompt Engineering
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Journey How to Transform Tables with SQL
Rating 5.0 of 2 users Rating 5.0 of 2 users (2)
Book Querying SQL Server: Run T-SQL Operations, Data Extraction, Data Manipulation, and Custom Queries to Deliver Simplified Analytics

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course PL-300: Loading & Transforming Data in Power BI
Rating 4.7 of 830 users Rating 4.7 of 830 users (830)
Course Memory-optimized Tables & Native Stored Procedures
Rating 4.6 of 27 users Rating 4.6 of 27 users (27)
Course Data Integrity & Constraints
Rating 4.3 of 168 users Rating 4.3 of 168 users (168)