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
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
Introducing JavaFX 8 Programming
Develop cross-platform, feature-rich JavaFX GUI applications with expert instruction from Java guru Herb Schildt Introducing JavaFX …
book
Learn SQL Database Programming
Learn everything you need to know to build efficient SQL queries using this easy-to-follow beginner's guide …