Joins are an important part of the SQL language allowing you to combine the data of two, or more, tables in a single SQL statement. Learn about the concepts of joins and the various types of joins supported in the Oracle database such as LEFT JOIN, RIGHT
- [Instructor] The SQL join clause allows us to combine recommend codes from two tables. A join in SQL locates related column values across two or more tables. So for example, assume that we have an employees table as well as a departments table. And lets say, in our example, we would like to retrieve the employee ID, employee name. But instead of retrieving the department number from the employee table, which makes little sense.
I mean, what's department 20, right? So assuming that instead of retrieving the department number we want to retrieve the department name. But the department name column exists in the departments table, not in the employees table. Using a SQL join, we can choose which column links both tables together, department number in our case. And produce a unified result, combining data from the two tables together.
So in our case we can choose to display the employee ID and employee name from the employees table but display the department name from the departments table. We will see joins in action throughout this chapter so don't worry if it all seems a little bit to theoretical for now. Also note that there are multiple types of joins you can use in your SQL quarries. These include inner joins, left joins, right joins, and full outer joins.
Inner joins will select records that have matching values in both tables. Left join will select records from the first table with any matching records from the right table. A right join selects records from the second that is right most table, with matching rows from the left most table. And a full outer join selects all records that match from in the left or right tables. So don't sweat it. We'll see all of this in action throughout our chapter.
Note: This training course is appropriate for beginning database developers with no prior experience with SQL or Oracle.
- Using Oracle SQL*Developer, the free development environment
- Selecting data from tables
- Filtering data
- Using functions to manipulate data
- Joining data from tables
- Creating tables
- Updating values
- Truncating data
- Grouping and ordering result sets
- Working with primary keys
- Checking constraints
Skill Level Beginner
Database Foundations: Core Conceptswith Adam Wilbert2h 14m Beginner
Database Foundations: Administrationwith Adam Wilbert1h 14m Beginner
Oracle 12c Database: Administrationwith David Yahalom3h 58m Beginner
1. Introduction to SQL
2. Preparing the Course Environment
Downloading the course VM2m 16s
3. Using Oracle SQL Developer
4. Basic SELECT Queries
5. String, Number, and Date Functions
6. Joining Table Data
7. Manipulating Data
8. Grouping Data
9. Advanced Topics
Next steps1m 33s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.