This is our first example of SQL joins in action. In this video, explore a basic example of how to join data from two tables together using the JOIN SQL..
- [Instructor] Now it's time for us to write…our very first SQL join query.…But before doing so, let's understand…the type of problems that we're trying to solve…using a join statement.…So let's say we want to retrieve the first name,…last name and the department…for each employee in our company.…If we type select, first_name…comma last_name…comma department_id…from employees and run our query,…we'll get the first name, the last name,…and a code representing department id,…but not the actual department name.…
That's because if we select all of the data…in our employee's table, we'll see…that we do not store department names…as part of the records of our employee table,…but only department IDs.…The actual department names themselves…are stored in the department's table.…As you can see, we have the department ID,…with the corresponding department name.…That's because our database schema is normalized…meaning that we store department codes…for repeating values, such as for employees,…in the employees tables instead of the actual…
Author
Released
1/17/2018Note: 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
Duration
Views
Related Courses
-
Database Foundations: Core Concepts
with Adam Wilbert2h 14m Beginner -
Database Foundations: Administration
with Adam Wilbert1h 14m Beginner -
Oracle 12c Database: Administration
with David Yahalom3h 58m Beginner
-
Introduction
-
Welcome1m 37s
-
-
1. Introduction to SQL
-
What is SQL?2m 30s
-
Database tables2m 21s
-
Overview of table data types4m 21s
-
SQL query structure4m 38s
-
-
2. Preparing the Course Environment
-
Downloading the course VM2m 16s
-
-
3. Using Oracle SQL Developer
-
Exploring database objects1m 29s
-
Filtering specific objects1m 25s
-
Using SQL Developer tabs2m 18s
-
Viewing query output1m 18s
-
4. Basic SELECT Queries
-
Using WHERE to filter dates2m 42s
-
Using column aliases2m 18s
-
Using ORDER BY3m 29s
-
5. String, Number, and Date Functions
-
Introduction to functions1m 39s
-
Using LENGTH1m 4s
-
Using CONCAT4m 48s
-
Using LOWER and UPPER2m 44s
-
Using INSTR4m 32s
-
Using RPAD and LPAD3m 31s
-
Using ROUND1m 15s
-
Using TRUNC1m 36s
-
Using SYSDATE1m 59s
-
Using SYSTIMESTAMP1m 37s
-
Using MONTHS_BETWEEN3m 2s
-
Using ADD_MONTHS1m 17s
-
-
6. Joining Table Data
-
Joining data from tables4m 12s
-
INNER JOIN1m 17s
-
LEFT JOIN2m 55s
-
RIGHT JOIN1m 55s
-
FULL OUTER JOIN1m 59s
-
7. Manipulating Data
-
Creating a simple table2m 1s
-
COMMIT and ROLLBACK2m 23s
-
Introduction to transactions3m 43s
-
Deleting rows for a table3m 23s
-
Updating values2m 40s
-
8. Grouping Data
-
Using aggregate functions2m 24s
-
Using GROUP BY2m 45s
-
Using HAVING3m
-
9. Advanced Topics
-
Primary keys2m 47s
-
NOT NULL constraints1m 36s
-
Check constraints3m 2s
-
Foreign key constraints6m 4s
-
Subqueries4m 39s
-
-
Conclusion
-
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.
CancelTake 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.
Share this video
Embed this video
Video: Joining data from tables