Querying & Manipulating Data

SQL Server    |    Intermediate
  • 10 videos | 1h 1m 56s
  • Includes Assessment
  • Earns a Badge
Rating 4.7 of 132 users Rating 4.7 of 132 users (132)
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

Audiobook Learning SQL: Generate, Manipulate, and Retrieve Data, 3rd Edition
Journey How to Transform Tables with SQL
Rating 5.0 of 2 users Rating 5.0 of 2 users (2)
Course Querying SQL Databases: Using Generative AI Tools to Filter & Group Data
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course SQL 2016 Tables
Rating 4.5 of 473 users Rating 4.5 of 473 users (473)
Course Working with Functions, Times, Dates, & Intervals
Rating 4.4 of 34 users Rating 4.4 of 34 users (34)
Course Filtering Data
Rating 4.5 of 86 users Rating 4.5 of 86 users (86)