SKILL BENCHMARK
Microsoft SQL Server 2016 Data Querying and Manipulation Proficiency (Advanced Level)
- 25m
- 25 questions
The Microsoft SQL Server 2016 Data Querying and Manipulation Proficiency benchmark measures a learner's skills and knowledge of querying, retrieving, and manipulating data using advanced functions in Microsoft SQL Server. A learner who scores high on this benchmark demonstrates that they have the required skills to independently load, query, and manipulate data using Microsoft SQL Server 2016.
Topics covered
- create recursive table expressions in SQL Server 2016
- demonstrate how to input parameters in SQL Server 2016
- demonstrate how to output parameters in SQL Server 2016
- demonstrate how to query and output JSON data in SQL Server 2016
- demonstrate how to query and output XML data in SQL Server 2016
- demonstrate how to use EXISTS and NULLs in SQL Server 2016
- demonstrate how to use NOT EXISTS with OUTER JOINs
- demonstrate how to use PIVOT in SQL Server 2016
- demonstrate how to use the OUTPUT clause to monitor data in SQL Server 2016
- demonstrate how to use UNPIVOT in SQL Server 2016
- demonstrate how to write scalar subqueries in SQL Server 2016
- describe how to determine the impact on NULL values in PIVOT and UNPIVOT queries
- describe how to use EXISTS and INNER JOINS in SQL Server 2016
- describe how to write correlated subqueries in a HAVING clause
- describe how to write correlated subqueries with aliases
- describe JSON data
- describe scalar-valued user-defined functions in SQL Server 2016
- describe the difference between table expressions and temporary tables
- describe XML data
- determine the effect of NULL values on the INTERSECT operator
- recognize how to filter groups using the HAVING clause
- recognize table-valued functions in SQL Server 2016
- use CROSS APPLY operators in SQL Server 2016
- use OUTER APPLY operators in SQL Server 2016
- work with temporal tables in SQL Server 2016
