• Online, Self-Paced
Course 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.

Learning Objectives

SELECT Queries

  • 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

 

DISTINCT Clause

  • describe the purpose of DISTINCT in SQL Server 2016
  • describe how to execute a SELECT DISTINCT
  • demonstrate how to eliminate duplicates using DISTINCT

 

Aliases and Case Expressions

  • 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

 

Querying Multiple Tables

  • 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 cross and self joins
  • demonstrate the use of multiple join operators
  • demonstrate how to write queries with NULLs on joins

 

Practice: Fundamentals of Manipulating Data

  • demonstrate how to query and manipulate 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

Feedback

If you would like to provide feedback for this course, please e-mail the NICCS SO at NICCS@hq.dhs.gov.