SKILL BENCHMARK
Microsoft SQL Server 2016 Data Querying and Manipulation Competency (Intermediate Level)
- 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
