Querying and Manipulating Data


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


Overview/Description
SELECT statements in SQL Server 2016 are used to query tables and views. Further, you can manipulate data using SELECT statements to customize the returned results. This course focuses on the fundamentals of using SELECT statements, including how to use aliases and case expressions, as well as the DISTINCT clause. Lastly, this course covers how to query multiple tables using joins. 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.2

Lesson Objectives

Querying and Manipulating Data

  • start the course
  • recognize elements of simple SQL Server 2016 SELECT queries
  • demonstrate how to write simple SELECT statements in SQL Server 2016
  • demonstrate how to use calculations in the SELECT clause
  • describe the purpose of DISTINCT in SQL Server 2016
  • describe how to execute a SELECT DISTINCT
  • demonstrate how to eliminate duplicates using DISTINCT
  • describe how to refer to columns using aliases
  • specify how to refer to tables using aliases
  • describe SQL Server 2016 CASE expressions
  • demonstrate how to use simple CASE expressions
  • recognize how and when to use joins in SQL Server 2016
  • demonstrate the proper usage of inner joins in SQL Server 2016
  • demonstrate the proper usages of outer joins in SQL Server 2016
  • demonstrate the proper usages of outer joins in SQL Server 2016
  • demonstrate the proper usages of cross and self joins
  • demonstrate the use of multiple join operators
  • demonstrate how to write queries with NULLs on joins
  • demonstrate how to query and manipulate data in SQL Server 2016

    • Course Number:
    df_sqlq_a02_it_enus

    Expertise Level
    Expert