T-SQL Querying

Database administrators, database developers, and BI professionals

Prerequisite
None

Expected Duration
129 minutes

Description
SQL Server 2016 delivers many new features and enhancements. This course provides an overview of the SQL Server 2016 architecture, as well as the functions and capabilities available in each edition. The fundamentals of T-SQL querying is covered in this course, as well as topics such as sets and predicate logic. This course is one of a series of SkillSoft courses that cover the objectives for 20761A: Querying Data with Transact-SQL exam.

Objective

Introduction to Microsoft SQL Server 2016

  • start the course
  • recognize features of SQL Server 2016
  • list SQL Server 2016 editions and components
  • identify SQL Server 2016 functions and capabilities
  • list features of SQL Server Management Studio

T-SQL Querying

  • configure T-SQL statements in SQL Server 2016
  • work with T-SQL Language functions in SQL Server 2016
  • create T-SQL Variables in SQL Server 2016
  • demonstrate how to implement T-SQL expressions in SQL Server 2016
  • work with T-SQL control of flow, errors, and transactions in SQL Server 2016
  • use T-SQL comments in SQL Server 2016
  • work with T-SQL batch separators

SQL Server 2016 Sets

  • describe the characteristics of sets in SQL Server 2016
  • describe the set theory and how it relates to SQL Server 2015
  • describe applying set theory to SQL server queries

Predicate Logic

  • define predicate logic in SQL Server 2016
  • recognize the elements of a SELECT statement in SQL Server 2016
  • define the logical order of operations
  • demonstrate the logical order of operations when writing SELECT statements

Practice: Implementing and Querying Data

  • demonstrate querying data in SQL Server 2016

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.