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

Practice: Fundamentals of Modifying Data

  • demonstrate how to filter and modify data in SQL Server 2016

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.