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 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 Querying SQL Server: Run T-SQL Operations, Data Extraction, Data Manipulation, and Custom Queries to Deliver Simplified Analytics
Course Data Types & Normalization
Likes 67 Likes 67  
Course Database Fundamentals: Working with SQL Commands

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course SQL Concepts & Queries
Likes 498 Likes 498  
Course Filtering Data
Likes 52 Likes 52  
Course Data Visualization Essentials
Likes 250 Likes 250