SKILL BENCHMARK

Microsoft SQL Server 2016 Data Querying and Manipulation Proficiency

  • 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

recently added courses