Database Programmability Objects & Non-relational Data
SQL 2016
| Intermediate
- 15 Videos | 1h 51m 28s
- Includes Assessment
- Earns a Badge
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
-
1.Understanding Stored Procedures8m 4sUP NEXT
-
2.Using Stored Procedures11m 18s
-
3.Input Parameters6m 42s
-
4.Output Parameters7m 21s
-
5.Table-valued Functions7m 37s
-
6.Scalar-valued User-defined Functions8m 53s
-
7.TRY…CATCH Error Handling7m 49s
-
8.RAISERROR Statements7m 33s
-
9.Temporal Data Types7m 52s
-
10.Temporal Tables5m 56s
-
11.XML Data6m 35s
-
12.JSON Data4m 32s
-
13.Output JSON Data6m 24s
-
14.Outputting XML Data7m 45s
-
15.Exercise: Using Database Programmability Objects7m 9s
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.
