• Online, Self-Paced
Course 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 70-761: Querying Data with Transact-SQL exam.

Learning Objectives

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

Framework Connections

The materials within this course focus on the NICE Framework Task, Knowledge, and Skill statements identified within the indicated NICE Framework component(s):

Specialty Areas

  • Data Administration
  • Systems Administration