T-SQL Queries

SQL Server 2016    |    Intermediate
  • 11 videos | 1h 13m 57s
  • Includes Assessment
  • Earns a Badge
Rating 4.3 of 218 users Rating 4.3 of 218 users (218)
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 Leveling Up with SQL: Advanced Techniques for Transforming Data into Insights
Book Querying MySQL: Make your MySQL Database Analytics Accessible with SQL Operations, Data extraction, and Custom Queries
Course Architecture
Rating 4.2 of 30 users Rating 4.2 of 30 users (30)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Data Types & Normalization
Rating 4.6 of 124 users Rating 4.6 of 124 users (124)
Course Operators & Expressions
Rating 4.7 of 45 users Rating 4.7 of 45 users (45)
Course Project Management Introduction (PMBOK(r) Guide Sixth Edition)
Rating 4.2 of 2232 users Rating 4.2 of 2232 users (2232)