Database Programmability Objects & Non-relational Data

SQL 2016    |    Intermediate
  • 15 Videos | 1h 51m 28s
  • Includes Assessment
  • Earns a Badge
Likes 49 Likes 49
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

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.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE T-SQL Queries
Likes 173 Likes 173  
Likes 498 Likes 498  
Likes 110 Likes 110