Filter and Modify Data in SQL Server 2016

Filter and Modify Data in SQL Server 2016

Database administrators, database developers, and BI professionals

Prerequisite
None

Expected Duration
141 minutes

Description
SQL Server 2016 offers various clauses that work in conjunction with SELECT statements. These clauses, which include ORDER BY, TOP, OFFSET, and FETCH, determine how the results of a particular query are presented. In addition to clauses, the data manipulation language (DML) will be introduced in this course. The DML contains additional commands to modify data within rows and tables in SQL Server 2016. This course is one of a series of courses that cover the objectives for 20761A: Querying Data with Transact-SQL exam.

Objective

Sorting and Filtering SQL Server 2016 Data

start the course

describe the ORDER BY clause in SQL Server 2016

demonstrate how to sort data in SQL Server 2016 using the ORDER BY clause

recognize how to filter data in SQL Server 2016

demonstrate how to filter data in SQL Server 2016 using the WHERE clause

describe how to use predicates and operators in SQL Server 2016

Unknown Values

describe three-valued logic in SQL Server 2016

work with NULL in Queries in SQL Server 2016

describe how to test for NULL in SQL Server 2016

SQL Server 2016 Data Types

describe how SQL Server 2016 uses data types

recognize when data type conversions occur in SQL Server 2016

demonstrate implicit and explicit conversions

describe different types of character data in SQL Server 2016

demonstrate how to manipulate character data in SQL Server 2016

Modifying Data Using DML

list the benefits of using data manipulation language (DML) in SQL Server 2016

describe how to populate tables in SQL Server 2016 using the SELECT INTO statement

demonstrate how to add data using INSERT statement

describe how to use UPDATE and MERGE statements to modify data

describe how to use DELETE and TRUNCATE statements to remove data

demonstrate how to use the OUTPUT clause to monitor data in SQL Server 2016