Database Programmability Objects & Non-relational Data

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

YOU MIGHT ALSO LIKE

COURSE Non-relational Data: Non-relational Databases
COURSE Advanced Programming in Go: Accessing Databases
BOOK Refactoring Legacy T-SQL for Improved Performance: Modern Practices for SQL Server Applications

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Optimizing Statisitics & Indexes
Likes 26 Likes 26  
COURSE Modifying Data
Likes 20 Likes 20  
COURSE Using Functions
Likes 32 Likes 32