T-SQL Queries

SQL Server 2016    |    Intermediate
  • 11 videos | 1h 13m 57s
  • Includes Assessment
  • Earns a Badge
Likes 173 Likes 173
SQL Server 2016 delivers many new features and enhancements. Explore an overview of the SQL Server 2016 architecture through the fundamentals of T-SQL querying.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

  • 11m 43s
    After completing this video, you will be able to recognize features of SQL Server 2016. FREE ACCESS
  • 6m 50s
    After completing this video, you will be able to list the SQL Server 2016 editions and components. FREE ACCESS
  • Locked
    3.  SQL Server 2016 Functions and Capabilities
    6m 59s
    In this video, you will learn how to identify SQL Server 2016 functions and capabilities. FREE ACCESS
  • Locked
    4.  SQL Server Management Studio
    10m 21s
    Upon completion of this video, you will be able to list features of SQL Server Management Studio. FREE ACCESS
  • Locked
    5.  T-SQL Statements
    3m 25s
    Learn how to configure T-SQL statements in SQL Server 2016. FREE ACCESS
  • Locked
    6.  T-SQL Functions
    6m 16s
    In this video, you will work with T-SQL Language functions in SQL Server 2016. FREE ACCESS
  • Locked
    7.  T-SQL Variables
    7m 38s
    During this video, you will learn how to create variables in SQL Server 2016. FREE ACCESS
  • Locked
    8.  T-SQL Expressions
    5m 16s
    In this video, you will learn how to use T-SQL expressions in SQL Server 2016. FREE ACCESS
  • Locked
    9.  T-SQL Control of Flow, Errors, and Transactions
    7m 55s
    Learn how to work with T-SQL control of flow, errors, and transactions in SQL Server 2016. FREE ACCESS
  • Locked
    10.  T-SQL Comments
    3m 31s
    Learn how to use T-SQL comments in SQL Server 2016. FREE ACCESS
  • Locked
    11.  T-SQL Batch Separators
    4m 4s
    Find out how to work with T-SQL batch separators. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Book High Performance SQL Server: Consistent Response for Mission-Critical Applications, Second Edition
Book Querying SQL Server: Run T-SQL Operations, Data Extraction, Data Manipulation, and Custom Queries to Deliver Simplified Analytics
Course Querying & Manipulating Data
Likes 112 Likes 112  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Using Aggregate Functions
Likes 37 Likes 37  
Course Data Integrity & Constraints
Likes 49 Likes 49  
Course SQL 2016 Tables
Likes 405 Likes 405