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 on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 405 Likes 405  
Likes 498 Likes 498  
Course T-SQL Queries
Likes 173 Likes 173