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
    FREE ACCESS
  • Locked
    4. 
    Character Data
    6m 55s
    FREE ACCESS
  • Locked
    5. 
    Manipulating Character Data
    7m 20s
    FREE ACCESS
  • Locked
    6. 
    Data Manipulation Language Overview
    8m 47s
    FREE ACCESS
  • Locked
    7. 
    Populating Tables Using SELECT INTO
    4m 8s
    FREE ACCESS
  • Locked
    8. 
    Add Data Using INSERT
    8m 47s
    FREE ACCESS
  • Locked
    9. 
    Modify Data Using UPDATE and MERGE
    9m 33s
    FREE ACCESS
  • Locked
    10. 
    Remove Data Using DELETE and TRUNCATE
    4m 1s
    FREE ACCESS
  • Locked
    11. 
    OUTPUT Clause
    5m 29s
    FREE ACCESS
  • Locked
    12. 
    Exercise: Modifying Data in SQL Server 2016
    8m 44s
    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 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

COURSE Designing & Implementing Views
Likes 23 Likes 23  
COURSE Using Aggregate Functions
Likes 21 Likes 21  
COURSE Subqueries & the EXISTS Predicate
Likes 24 Likes 24  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE SQL 2016 Tables
Likes 166 Likes 166  
COURSE Database Programmability Objects & Non-relational Data
Likes 22 Likes 22  
COURSE Using GROUP BY, PIVOT, & UNPIVOT
Likes 20 Likes 20