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 typesrecognize when data type conversions occur in SQL Server 2016demonstrate implicit and explicit conversionsdescribe different types of character data in SQL Server 2016demonstrate how to manipulate character data in SQL Server 2016list 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 statementdemonstrate how to add data using INSERT statementdescribe how to use UPDATE and MERGE statements to modify datadescribe how to use DELETE and TRUNCATE statements to remove datademonstrate how to use the OUTPUT clause to monitor data in SQL Server 2016demonstrate 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.