Querying & Manipulating Data

SQL Server 2016    |    Intermediate
  • 10 videos | 1h 1m 56s
  • Includes Assessment
  • Earns a Badge
Likes 112 Likes 112
SELECT statements in SQL Server 2016 are used to query tables and views and to manipulate data for customized results. Explore the fundamentals of using SELECT statements, including how to use aliases and case expressions.

WHAT YOU WILL LEARN

  • 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
    describe the purpose of DISTINCT in SQL Server 2016
    describe how to execute a SELECT DISTINCT
  • demonstrate how to eliminate duplicates using DISTINCT
    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

IN THIS COURSE

  • 6m 37s
    After completing this video, you will be able to recognize elements of simple SQL Server 2016 SELECT queries. FREE ACCESS
  • 4m 34s
    In this video, you will learn how to write simple SELECT statements in SQL Server 2016. FREE ACCESS
  • Locked
    3.  Calculated Expressions
    8m 6s
    In this video, you will learn how to use calculations in the SELECT statement. FREE ACCESS
  • Locked
    4.  Understanding DISTINCT Statements in SQL Server 2016
    3m 52s
    Upon completion of this video, you will be able to describe the purpose of DISTINCT in SQL Server 2016. FREE ACCESS
  • Locked
    5.  SELECT DISTINCT Syntax
    2m 44s
    Upon completion of this video, you will be able to describe how to execute a SELECT DISTINCT statement. FREE ACCESS
  • Locked
    6.  Eliminating Duplicates Using DISTINCT
    7m 13s
    In this video, you will learn how to eliminate duplicates using the DISTINCT keyword. FREE ACCESS
  • Locked
    7.  Referring to Columns Using Aliases
    7m 54s
    After completing this video, you will be able to describe how to refer to columns using column names. FREE ACCESS
  • Locked
    8.  Referring to Tables Using Aliases
    5m 24s
    Upon completion of this video, you will be able to specify how to refer to tables using table aliases. FREE ACCESS
  • Locked
    9.  SQL Server 2016 CASE Expressions
    6m 39s
    Upon completion of this video, you will be able to describe SQL Server 2016 CASE expressions. FREE ACCESS
  • Locked
    10.  Using Simple CASE Expressions
    8m 55s
    In this video, you will learn how to use simple CASE expressions. 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

Course Filtering Data
Likes 52 Likes 52  
Book Querying MySQL: Make your MySQL Database Analytics Accessible with SQL Operations, Data extraction, and Custom Queries
Course Oracle Database 12c R2 SQL: Using Basic SELECT statements
Likes 72 Likes 72  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course CompTIA Server+: Servers & Cloud Computing
Likes 1 Likes 1  
Course Working with Functions, Times, Dates, & Intervals
Likes 22 Likes 22  
Course SQL 2016 Tables
Likes 405 Likes 405