Learn how to use foreign keys in SQL to create referential integrity between two values in two database tables.
- [Instructor] Foreign keys are special type of SQL…constraints that allows us to create referential integrity…between two tables.…That is, using foreign keys we can enforce that values…inserted into a given column in table a,…must also exist in a given column in table b.…Hence, creating this relationship between our table.…So let's see an example.…Assume that we have a suppliers and products table.…Suppliers, list all of the suppliers of our company.…And products, list the products that our company sells.…
The products table will have a supplier id column.…That's because we assume that every product that our…company sells, has a supplier.…Using foreign key constraint, we can enforce that values…inserted into the supplier id column in our products table,…must exist in the id column of our suppliers table.…Essentially, making sure that we don't make up suppliers…that don't exist when inserting data…into our products table.…Essentially, making sure that for every product we insert…into our products table,…a correlating supplier must exist in the supplier table.…
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.