Querying and Manipulating Data

Database administrators, database developers, and BI professionals

Prerequisite
None

Expected Duration
134 minutes

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 20761A: Querying Data with Transact-SQL exam.

Objective

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

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.