Filter and Modify Data in SQL Server 2016


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/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.

Target Audience
Database administrators, database developers, and BI professionals

Prerequisites
None

Expected Duration (hours)
2.3

Lesson Objectives

Filter and Modify Data in SQL Server 2016

  • 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
  • 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
  • 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
  • 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
  • demonstrate how to filter and modify data in SQL Server 2016

    • Course Number:
    df_sqlq_a03_it_enus

    Expertise Level
    Expert