Querying with Joins
SQL Server 2016
| Intermediate
- 8 videos | 1h 4m 26s
- 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 querying multiple tables using joins.
WHAT YOU WILL LEARN
-
recognize how and when to use joins in SQL Server 2016demonstrate the proper usage of inner joins in SQL Server 2016demonstrate the proper usages of outer joins in SQL Server 2016demonstrate the proper usages of outer joins in SQL Server 2016
-
demonstrate the proper usages of cross and self joinsdemonstrate the use of multiple join operatorsdemonstrate how to write queries with NULLs on joinsdemonstrate how to query and manipulate data in SQL Server 2016
IN THIS COURSE
-
1.Joins Overview8m 6sUP NEXT
-
2.Querying with Inner Joins7m 19s
-
3.Querying with Left Outer Joins7m 21s
-
4.Querying with Right Outer Joins7m 45s
-
5.Querying Cross Joins and Self Joins10m 12s
-
6.Multiple Join Operators9m 8s
-
7.NULL Values and Joins5m 18s
-
8.Exercise: Manipulating Data in SQL Server 20169m 17s
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.