Database Programmability Objects & Non-relational Data

SQL 2016    |    Intermediate
  • 15 videos | 1h 51m 28s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 51 users Rating 4.6 of 51 users (51)
SQL Server 2016 offers various database programmable objects, such as stored procedures and functions. Discover how to implement database programmability objects and how to work with temporal and non-relational data in SQL Server 2016.

WHAT YOU WILL LEARN

  • Describe stored procedures in sql server 2016
    Use and create stored procedures in sql server 2016
    Demonstrate how to input parameters in sql server 2016
    Demonstrate how to output parameters in sql server 2016
    Recognize table-valued functions in sql server 2016
    Describe scalar-valued user-defined functions in sql server 2016
    Demonstrate try…catch error handling
    Demonstrate how to use raiserror in sql 2016
  • Describe temporal data types in sql server 2016
    Work with temporal tables in sql server 2016
    Describe xml data
    Describe json data
    Demonstrate how to query and output json data in sql server 2016
    Demonstrate how to query and output xml data in sql server 2016
    Use database programmability objects in sql server 2016

IN THIS COURSE

  • 8m 4s
    After completing this video, you will be able to describe stored procedures in SQL Server 2016. FREE ACCESS
  • 11m 18s
    Find out how to use and create stored procedures in SQL Server 2016. FREE ACCESS
  • Locked
    3.  Input Parameters
    6m 42s
    In this video, you will learn how to input parameters in SQL Server 2016. FREE ACCESS
  • Locked
    4.  Output Parameters
    7m 21s
    In this video, you will learn how to output parameters in SQL Server 2016. FREE ACCESS
  • Locked
    5.  Table-valued Functions
    7m 37s
    After completing this video, you will be able to recognize table-valued functions in SQL Server 2016. FREE ACCESS
  • Locked
    6.  Scalar-valued User-defined Functions
    8m 53s
    Upon completion of this video, you will be able to describe scalar-valued user-defined functions in SQL Server 2016. FREE ACCESS
  • Locked
    7.  TRY…CATCH Error Handling
    7m 49s
    Learn how to apply error handling using try...catch. FREE ACCESS
  • Locked
    8.  RAISERROR Statements
    7m 33s
    In this video, you will learn how to use RAISERROR in SQL Server 2016. FREE ACCESS
  • Locked
    9.  Temporal Data Types
    7m 52s
    Upon completion of this video, you will be able to describe temporal data types in SQL Server 2016. FREE ACCESS
  • Locked
    10.  Temporal Tables
    5m 56s
    In this video, you will learn how to work with temporal tables in SQL Server 2016. FREE ACCESS
  • Locked
    11.  XML Data
    6m 35s
    Upon completion of this video, you will be able to describe XML data. FREE ACCESS
  • Locked
    12.  JSON Data
    4m 32s
    After completing this video, you will be able to describe data in JSON format. FREE ACCESS
  • Locked
    13.  Output JSON Data
    6m 24s
    In this video, you will learn how to query and output JSON data in SQL Server 2016. FREE ACCESS
  • Locked
    14.  Outputting XML Data
    7m 45s
    In this video, you will learn how to query and output XML data in SQL Server 2016. FREE ACCESS
  • Locked
    15.  Exercise: Using Database Programmability Objects
    7m 9s
    In this video, learn how to use database programmability objects 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

Book Beginning Database Design Solutions: Understanding and Implementing Database Design Concepts for the Cloud and Beyond, Second Edition
Audiobook Learning SQL: Generate, Manipulate, and Retrieve Data, 3rd Edition
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 Backup Management
Rating 4.5 of 82 users Rating 4.5 of 82 users (82)
Course Monitoring Database Activity
Rating 4.6 of 29 users Rating 4.6 of 29 users (29)
Course Subqueries & the EXISTS Predicate
Rating 4.7 of 53 users Rating 4.7 of 53 users (53)