Modifying Data

SQL Server 2016
  • 12 Videos | 1h 29m 48s
  • Includes Assessment
  • Earns a Badge
Likes 20 Likes 20
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 23 Likes 23  
Likes 21 Likes 21  
Likes 24 Likes 24  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 166 Likes 166  
Likes 20 Likes 20