SQL Server 2016 offers various database programmable objects, such as stored procedures and functions, used to enhance and increase your database performance as well as ease administrative workload. This course will demonstrate how to implement various database programmability objects, as well as how to work with temporal and non-relational data in SQL Server 2016. This course is one of a series of courses that cover the objectives for 70-761: Querying Data with Transact-SQL exam.
Learning Objectives
Database Programmability Objects
- start the course
- 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
Temporal and Non-relational Data
- 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
Practice: Implementing Database Programmability Objects
- use database programmability objects in SQL Server 2016
Framework Connections
The materials within this course focus on the NICE Framework Task, Knowledge, and Skill statements identified within the indicated NICE Framework component(s):
Specialty Areas
- Data Administration
- Systems Administration
Feedback
If you would like to provide feedback for this course, please e-mail the NICCS SO at NICCS@hq.dhs.gov.