Querying & Manipulating Data

SQL Server 2016
  • 10 Videos | 1h 6m 56s
  • Includes Assessment
  • Earns a Badge
Likes 61 Likes 61
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

  • Playable
    1. 
    SELECT Statements Overview
    6m 37s
    UP NEXT
  • Playable
    2. 
    Writing SELECT Statements in SQL Server 2016
    4m 34s
  • Locked
    3. 
    Calculated Expressions
    8m 6s
  • Locked
    4. 
    Understanding DISTINCT Statements in SQL Server 2016
    3m 52s
  • Locked
    5. 
    SELECT DISTINCT Syntax
    2m 44s
  • Locked
    6. 
    Eliminating Duplicates Using DISTINCT
    7m 13s
  • Locked
    7. 
    Referring to Columns Using Aliases
    7m 54s
  • Locked
    8. 
    Referring to Tables Using Aliases
    5m 24s
  • Locked
    9. 
    SQL Server 2016 CASE Expressions
    6m 39s
  • Locked
    10. 
    Using Simple CASE Expressions
    8m 55s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 23 Likes 23  
Likes 32 Likes 32  
Likes 26 Likes 26  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 24 Likes 24  
Likes 32 Likes 32