SKILL BENCHMARK

Microsoft SQL Server 2016 Data Querying and Manipulation Competency

  • 25m
  • 25 questions
The Microsoft SQL Server 2016 Data Querying and Manipulation Competency benchmark measures a learner's skills and knowledge of querying, retrieving, and manipulating data. A learner who scores high on this benchmark demonstrates that they have the required skills to load, query, and manipulate data using Microsoft SQL Server 2016.

Topics covered

  • configure T-SQL statements in SQL Server 2016
  • define predicate logic in SQL Server 2016
  • define the logical order of operations
  • demonstrate how to implement T-SQL expressions in SQL Server 2016
  • demonstrate how to use aggregate functions with NULL
  • demonstrate how to use simple CASE expressions
  • demonstrate how to write queries with NULLs on joins
  • demonstrate implicit and explicit conversions
  • demonstrate the logical order of operations when writing SELECT statements
  • demonstrate the proper usage of inner joins in SQL Server 2016
  • demonstrate the proper usages of cross and self joins
  • demonstrate the proper usages of left outer joins in SQL Server 2016
  • demonstrate the proper usages of right outer joins in SQL Server 2016
  • demonstrate the use of multiple join operators
  • describe how to aggregate distinct values using DISTINCT
  • describe how to test for NULL in SQL Server 2016
  • describe how to use DELETE and TRUNCATE statements to remove data
  • describe how to use predicates and operators in SQL Server 2016
  • describe how to use UPDATE and MERGE statements to modify data
  • describe SQL Server 2016 CASE expressions
  • describe three-valued logic in SQL Server 2016
  • recognize the elements of a SELECT statement in SQL Server 2016
  • work with NULL in Queries in SQL Server 2016
  • work with T-SQL control of flow, errors, and transactions in SQL Server 2016
  • work with T-SQL Language functions in SQL Server 2016

recently added courses