Modifying Data
SQL Server
| 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
-
9m 17sAfter completing this video, you will be able to describe how SQL Server 2016 uses data types. FREE ACCESS
-
5m 5sUpon completion of this video, you will be able to recognize when data type conversions occur in SQL Server 2016. FREE ACCESS
-
6m 11sIn this video, you will learn about implicit and explicit type conversions. FREE ACCESS
-
6m 55sAfter completing this video, you will be able to describe different types of character data in SQL Server 2016. FREE ACCESS
-
7m 20sIn this video, you will learn how to manipulate character data in SQL Server 2016. FREE ACCESS
-
8m 47sUpon completion of this video, you will be able to list the benefits of using data manipulation language (DML) in SQL Server 2016. FREE ACCESS
-
4m 8sUpon 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
-
8m 47sIn this video, you will learn how to add data using the INSERT statement. FREE ACCESS
-
9m 33sAfter completing this video, you will be able to describe how to use the UPDATE and MERGE statements to modify data. FREE ACCESS
-
4m 1sAfter completing this video, you will be able to describe how to use the DELETE and TRUNCATE statements to remove data. FREE ACCESS
-
5m 29sIn this video, you will learn how to use the OUTPUT clause to monitor data in SQL Server 2016. FREE ACCESS
-
8m 44sIn 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
Channel
Wintellect Data Visualization