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