Querying with Joins

SQL Server 2016    |    Intermediate
  • 8 Videos | 1h 7m 56s
  • Includes Assessment
  • Earns a Badge
Likes 62 Likes 62
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 2016
    demonstrate the proper usage of inner joins in SQL Server 2016
    demonstrate the proper usages of outer joins in SQL Server 2016
    demonstrate the proper usages of outer joins in SQL Server 2016
  • demonstrate the proper usages of cross and self joins
    demonstrate the use of multiple join operators
    demonstrate how to write queries with NULLs on joins
    demonstrate how to query and manipulate data in SQL Server 2016

IN THIS COURSE

  • Playable
    1. 
    Joins Overview
    8m 6s
    UP NEXT
  • Playable
    2. 
    Querying with Inner Joins
    7m 19s
  • Locked
    3. 
    Querying with Left Outer Joins
    7m 21s
  • Locked
    4. 
    Querying with Right Outer Joins
    7m 45s
  • Locked
    5. 
    Querying Cross Joins and Self Joins
    10m 12s
  • Locked
    6. 
    Multiple Join Operators
    9m 8s
  • Locked
    7. 
    NULL Values and Joins
    5m 18s
  • Locked
    8. 
    Exercise: Manipulating Data in SQL Server 2016
    9m 17s

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.

YOU MIGHT ALSO LIKE

Likes 40 Likes 40  
Likes 21 Likes 21  
Likes 38 Likes 38  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 1602 Likes 1602  
COURSE SOLID & GRASP
Likes 3218 Likes 3218  
Likes 32 Likes 32