Lessons:16Length:1.5 hours

For full access to all 16 lessons, including source files, subscribe with Elements.
- Overview
- Transcript
3.3 Foreign Keys and Relationships
You already know that you can have multiple tables in your database. Now we need a way to show relationships between records in different tables. This is where foreign keys come in. However, just like primary keys, there are certain rules you should follow. Of course, it’s all in this screencast.
1.Introduction1 lesson, 01:31
1 lesson, 01:31
Free Lesson 1.1Introduction01:31
Free Lesson
1.1
Introduction
01:31
2.History and Terms3 lessons, 17:06
3 lessons, 17:06
Free Lesson 2.1A History Mini-Lesson04:09
Free Lesson
2.1
A History Mini-Lesson
04:09
2.2Codd's Twelve Commandments08:21
2.2
Codd's Twelve Commandments
08:21
2.3Terminology04:36
2.3
Terminology
04:36
3.Relational Components5 lessons, 38:40
5 lessons, 38:40
3.1Data Types08:07
3.1
Data Types
08:07
3.2Primary Keys07:36
3.2
Primary Keys
07:36
3.3Foreign Keys and Relationships07:46
3.3
Foreign Keys and Relationships
07:46
3.4Normalization07:31
3.4
Normalization
07:31
3.5Queries07:40
3.5
Queries
07:40
4.Database Usage6 lessons, 29:50
6 lessons, 29:50
4.1Views06:09
4.1
Views
06:09
4.2Database Servers and Users03:08
4.2
Database Servers and Users
03:08
4.3Designing a Data Model04:55
4.3
Designing a Data Model
04:55
4.4A Practical Look at SQLite: Part 107:13
4.4
A Practical Look at SQLite: Part 1
07:13
4.5A Practical Look at SQLite: Part 206:44
4.5
A Practical Look at SQLite: Part 2
06:44
4.6Other Database Models01:41
4.6
Other Database Models
01:41
5.Conclusion1 lesson, 00:18
1 lesson, 00:18
5.1Conclusion00:18
5.1
Conclusion
00:18
Continue watching with Elements
Continue watching with Elements