5. Sorting and Filtering Data
– Sorting Data with ORDER BY clause
– Filtering Data with WHERE clause Predicates
– Filtering Data with TOP and OFFSET-FETCH
– Working with Unknown/Missing Values or three-valued logic (NULL)

6. Working with SQL Server 2016 Data Types
– Introducing SQL Server 2016 Data Types
– Working with Character Data
– Working with Date and Time Data
– Working with data types conversion

Related

Sir,
Can you tell me where to register for this exam? The links thrown up by google are the prometrics which is no longer operational, as (i think) prometric is no longer a partner for MS certifications.