Querying & Manipulating Data
SQL Server 2016
| Intermediate
- 10 Videos | 1h 1m 56s
- Includes Assessment
- Earns a Badge
SELECT statements in SQL Server 2016 are used to query tables and views and to manipulate data for customized results. Explore the fundamentals of using SELECT statements, including how to use aliases and case expressions.
WHAT YOU WILL LEARN
-
recognize elements of simple SQL Server 2016 SELECT queriesdemonstrate how to write simple SELECT statements in SQL Server 2016demonstrate how to use calculations in the SELECT clausedescribe the purpose of DISTINCT in SQL Server 2016describe how to execute a SELECT DISTINCT
-
demonstrate how to eliminate duplicates using DISTINCTdescribe how to refer to columns using aliasesspecify how to refer to tables using aliasesdescribe SQL Server 2016 CASE expressionsdemonstrate how to use simple CASE expressions
IN THIS COURSE
-
1.SELECT Statements Overview6m 37sUP NEXT
-
2.Writing SELECT Statements in SQL Server 20164m 34s
-
3.Calculated Expressions8m 6s
-
4.Understanding DISTINCT Statements in SQL Server 20163m 52s
-
5.SELECT DISTINCT Syntax2m 44s
-
6.Eliminating Duplicates Using DISTINCT7m 13s
-
7.Referring to Columns Using Aliases7m 54s
-
8.Referring to Tables Using Aliases5m 24s
-
9.SQL Server 2016 CASE Expressions6m 39s
-
10.Using Simple CASE Expressions8m 55s
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.