Video description
- Identify parent key and foreign keys to establish table relationships
- Return parent rows even in the absence of corresponding child rows
- Correctly choose between LEFT, RIGHT, and FULL outer joins
- Query for rows that are held in common between two tables
- Combine rows from multiple result sets using union operations
Table of contents
- Introduction 00:02:50
- SELECT from Multiple Tables 00:05:12
- Finding Table Relationships 00:07:20
- Parent Tables vs Child Tables 00:02:48
- Using Inner Joins 00:04:58
- Using Left Outer Joins 00:02:30
- Using Right Outer Joins 00:02:59
- Using Full Outer Joins 00:03:04
- Using Self Joins 00:04:16
- Using Cross Joins 00:03:06
- UNION and UNION All Operators 00:02:52
- INTERSECT and EXCEPT Operators 00:02:43
Product information
- Title: Selecting Data from Multiple Tables
- Author(s):
- Release date: April 2019
- Publisher(s): Apress
- ISBN: 9781484249055
You might also like
video
From 0 To 1:SQL And Databases - Heavy Lifting
Your bodyguard for when data gets too big, this course is strong but friendly, funny yet …
video
Microsoft PolyBase Concepts and Configuration: Binding SQL Server and Other Platforms into a Single Data Source
This video provides an overview of PolyBase, Microsoft's technology for data virtualization. Modern data platform environments …
video
Using T-SQL Functions and Summarizing Results
Enhance your SELECT statements by invoking a vast library of built-in features and capabilities that SQL …
book
Just Java™ 2
The #1 introduction to J2SE 1.5 and enterprise/server-side development! An international bestseller for eight years, is …