Modifying Data

SQL Server 2016    |    Intermediate
  • 12 Videos | 1h 24m 18s
  • Includes Assessment
  • Earns a Badge
Likes 36 Likes 36
SQL Server 2016 offers various clauses determine how the results of a particular query are presented. Explore data modification using conversions, character data, SELECT INTO, INSERT, and more.

WHAT YOU WILL LEARN

  • describe how SQL Server 2016 uses data types
    recognize when data type conversions occur in SQL Server 2016
    demonstrate implicit and explicit conversions
    describe different types of character data in SQL Server 2016
    demonstrate how to manipulate character data in SQL Server 2016
    list the benefits of using data manipulation language (DML) in SQL Server 2016
  • describe how to populate tables in SQL Server 2016 using the SELECT INTO statement
    demonstrate how to add data using INSERT statement
    describe how to use UPDATE and MERGE statements to modify data
    describe how to use DELETE and TRUNCATE statements to remove data
    demonstrate how to use the OUTPUT clause to monitor data in SQL Server 2016
    demonstrate how to filter and modify data in SQL Server 2016

IN THIS COURSE

  • Playable
    1. 
    SQL Server 2016 Data Types Overview
    9m 17s
    UP NEXT
  • Playable
    2. 
    Data Type Conversions
    5m 5s
  • Locked
    3. 
    Implicit and Explicit Conversions
    6m 11s
  • Locked
    4. 
    Character Data
    6m 55s
  • Locked
    5. 
    Manipulating Character Data
    7m 20s
  • Locked
    6. 
    Data Manipulation Language Overview
    8m 47s
  • Locked
    7. 
    Populating Tables Using SELECT INTO
    4m 8s
  • Locked
    8. 
    Add Data Using INSERT
    8m 47s
  • Locked
    9. 
    Modify Data Using UPDATE and MERGE
    9m 33s
  • Locked
    10. 
    Remove Data Using DELETE and TRUNCATE
    4m 1s
  • Locked
    11. 
    OUTPUT Clause
    5m 29s
  • Locked
    12. 
    Exercise: Modifying Data in SQL Server 2016
    8m 44s

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 62 Likes 62  
Likes 17 Likes 17  
Likes 166 Likes 166  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 62 Likes 62  
Likes 209 Likes 209  
COURSE Encryption
Likes 96 Likes 96