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
-
8m 4sAfter completing this video, you will be able to describe stored procedures in SQL Server 2016. FREE ACCESS
-
11m 18sFind out how to use and create stored procedures in SQL Server 2016. FREE ACCESS
-
3. Input Parameters6m 42sIn this video, you will learn how to input parameters in SQL Server 2016. FREE ACCESS
-
4. Output Parameters7m 21sIn this video, you will learn how to output parameters in SQL Server 2016. FREE ACCESS
-
5. Table-valued Functions7m 37sAfter completing this video, you will be able to recognize table-valued functions in SQL Server 2016. FREE ACCESS
-
6. Scalar-valued User-defined Functions8m 53sUpon completion of this video, you will be able to describe scalar-valued user-defined functions in SQL Server 2016. FREE ACCESS
-
7. TRY…CATCH Error Handling7m 49sLearn how to apply error handling using try...catch. FREE ACCESS
-
8. RAISERROR Statements7m 33sIn this video, you will learn how to use RAISERROR in SQL Server 2016. FREE ACCESS
-
9. Temporal Data Types7m 52sUpon completion of this video, you will be able to describe temporal data types in SQL Server 2016. FREE ACCESS
-
10. Temporal Tables5m 56sIn this video, you will learn how to work with temporal tables in SQL Server 2016. FREE ACCESS
-
11. XML Data6m 35sUpon completion of this video, you will be able to describe XML data. FREE ACCESS
-
12. JSON Data4m 32sAfter completing this video, you will be able to describe data in JSON format. FREE ACCESS
-
13. Output JSON Data6m 24sIn this video, you will learn how to query and output JSON data in SQL Server 2016. FREE ACCESS
-
14. Outputting XML Data7m 45sIn this video, you will learn how to query and output XML data in SQL Server 2016. FREE ACCESS
-
15. Exercise: Using Database Programmability Objects7m 9sIn 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.
