Modifying Data
SQL Server 2016
| Intermediate
- 12 videos | 1h 24m 18s
- Includes Assessment
- Earns a Badge
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
-
1.SQL Server 2016 Data Types Overview9m 17sUP NEXT
-
2.Data Type Conversions5m 5s
-
3.Implicit and Explicit Conversions6m 11s
-
4.Character Data6m 55s
-
5.Manipulating Character Data7m 20s
-
6.Data Manipulation Language Overview8m 47s
-
7.Populating Tables Using SELECT INTO4m 8s
-
8.Add Data Using INSERT8m 47s
-
9.Modify Data Using UPDATE and MERGE9m 33s
-
10.Remove Data Using DELETE and TRUNCATE4m 1s
-
11.OUTPUT Clause5m 29s
-
12.Exercise: Modifying Data in SQL Server 20168m 44s
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.
