Modifying Data

SQL Server    |    Intermediate
  • 12 videos | 1h 24m 18s
  • Includes Assessment
  • Earns a Badge
Rating 4.8 of 33 users Rating 4.8 of 33 users (33)
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

  • 9m 17s
    After completing this video, you will be able to describe how SQL Server 2016 uses data types. FREE ACCESS
  • 5m 5s
    Upon completion of this video, you will be able to recognize when data type conversions occur in SQL Server 2016. FREE ACCESS
  • Locked
    3.  Implicit and Explicit Conversions
    6m 11s
    In this video, you will learn about implicit and explicit type conversions. FREE ACCESS
  • Locked
    4.  Character Data
    6m 55s
    After completing this video, you will be able to describe different types of character data in SQL Server 2016. FREE ACCESS
  • Locked
    5.  Manipulating Character Data
    7m 20s
    In this video, you will learn how to manipulate character data in SQL Server 2016. FREE ACCESS
  • Locked
    6.  Data Manipulation Language Overview
    8m 47s
    Upon completion of this video, you will be able to list the benefits of using data manipulation language (DML) in SQL Server 2016. FREE ACCESS
  • Locked
    7.  Populating Tables Using SELECT INTO
    4m 8s
    Upon completion of this video, you will be able to describe how to populate tables in SQL Server 2016 using the INSERT INTO statement. FREE ACCESS
  • Locked
    8.  Add Data Using INSERT
    8m 47s
    In this video, you will learn how to add data using the INSERT statement. FREE ACCESS
  • Locked
    9.  Modify Data Using UPDATE and MERGE
    9m 33s
    After completing this video, you will be able to describe how to use the UPDATE and MERGE statements to modify data. FREE ACCESS
  • Locked
    10.  Remove Data Using DELETE and TRUNCATE
    4m 1s
    After completing this video, you will be able to describe how to use the DELETE and TRUNCATE statements to remove data. FREE ACCESS
  • Locked
    11.  OUTPUT Clause
    5m 29s
    In this video, you will learn how to use the OUTPUT clause to monitor data in SQL Server 2016. FREE ACCESS
  • Locked
    12.  Exercise: Modifying Data in SQL Server 2016
    8m 44s
    In this video, you will learn how to filter and modify data in SQL Server 2016. 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

Book Getting Started with SQL and Databases: Managing and Manipulating Data with SQL
Book Leveling Up with SQL: Advanced Techniques for Transforming Data into Insights
Course Querying with Joins
Rating 4.6 of 89 users Rating 4.6 of 89 users (89)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Data Loading & Visualization in Power BI: Loading Data from Databases
Rating 5.0 of 4 users Rating 5.0 of 4 users (4)
Course Using Aggregate Functions
Rating 4.7 of 46 users Rating 4.7 of 46 users (46)
Course Filtering Data
Rating 4.5 of 86 users Rating 4.5 of 86 users (86)