T-SQL Querying


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


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

T-SQL Querying

  • 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
  • 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
  • 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
  • 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
  • demonstrate querying data in SQL Server 2016

    • Course Number:
    df_sqlq_a01_it_enus

    Expertise Level
    Intermediate