Querying with Joins

SQL Server 2016    |    Intermediate
  • 8 videos | 1h 4m 26s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 89 users Rating 4.6 of 89 users (89)
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

  • 8m 6s
    After completing this video, you will be able to recognize how and when to use joins in SQL Server 2016. FREE ACCESS
  • 7m 19s
    In this video, find out how to apply proper usage of inner joins in SQL Server 2016. FREE ACCESS
  • Locked
    3.  Querying with Left Outer Joins
    7m 21s
    In this video, you will learn how to apply the proper usage of outer joins in SQL Server 2016. FREE ACCESS
  • Locked
    4.  Querying with Right Outer Joins
    7m 45s
    Learn how to apply the proper usage of outer joins in SQL Server 2016. FREE ACCESS
  • Locked
    5.  Querying Cross Joins and Self Joins
    10m 12s
    In this video, you will learn how to apply the proper usage of cross and self joins. FREE ACCESS
  • Locked
    6.  Multiple Join Operators
    9m 8s
    In this video, you will learn about the use of multiple join operators. FREE ACCESS
  • Locked
    7.  NULL Values and Joins
    5m 18s
    In this video, you will learn how to write queries with joins that include NULL values. FREE ACCESS
  • Locked
    8.  Exercise: Manipulating Data in SQL Server 2016
    9m 17s
    In this video, you will learn how to query and manipulate data in SQL Server 2016. FREE ACCESS

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.

YOU MIGHT ALSO LIKE

Course Database Programmability Objects & Non-relational Data
Rating 4.6 of 51 users Rating 4.6 of 51 users (51)
Book Querying SQL Server: Run T-SQL Operations, Data Extraction, Data Manipulation, and Custom Queries to Deliver Simplified Analytics
Course Non-relational Data: Non-relational Databases
Rating 4.5 of 41 users Rating 4.5 of 41 users (41)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Using Functions
Rating 4.5 of 43 users Rating 4.5 of 43 users (43)
Course Subqueries & the EXISTS Predicate
Rating 4.7 of 53 users Rating 4.7 of 53 users (53)
Course Filtering Data
Rating 4.5 of 86 users Rating 4.5 of 86 users (86)