Querying with Joins

SQL Server 2016    |    Intermediate
  • 8 Videos | 1h 4m 26s
  • 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 166 Likes 166  
Likes 36 Likes 36  
COURSE T-SQL Queries
Likes 173 Likes 173  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 25 Likes 25  
Likes 29 Likes 29  
Likes 122 Likes 122