Author
Released
12/17/2020In order to work with the data stored in each row in a table, the table must contain a primary key column, or set of columns. Foreign keys provide the glue that the entire system is built on. Adam steps you through how to incorporate primary keys and foreign keys into the design of your database tables. He walks through data relationships, indexes, and constraints, then concludes with other courses you may find useful.
Skill Level Beginner
Duration
Views
- [Adam] The most important part of database development is building a solid framework for housing your valuable data. Poorly designed data tables can make a database inefficient or worse, it could completely compromise the integrity of your data and make the contents untrustworthy. By learning how to properly structure your data tables, you'll go a long way towards creating a database that protects your data and increases its utility. Hi, my name is Adam Wilbert and I've been introducing people to the world of databases for well over a decade. In my second course of the LinkedIn Learning Database Foundation series, we're going to be covering the all-important data table from top to bottom. If you've ever wondered how to move from a spreadsheet to a relational database, then this is the course for you. There's a lot of topics to cover and many tables that need building. So let's get started.
Related Courses
-
Relational Databases Essential Training
with Adam Wilbert2h 12m Intermediate
-
Introduction
-
1. Data Types
-
Data integrity concepts4m 52s
-
The role of data types3m 55s
-
Numeric data types6m 21s
-
Character data types6m 33s
-
Date and time data types6m 24s
-
Additional common types5m 34s
-
-
2. Design a Normalized Database
-
First normal form3m 16s
-
Second normal form3m 27s
-
Third normal form3m 3s
-
3. Identify Rows with Primary Keys
-
Purpose of a primary key3m 55s
-
Natural keys2m 42s
-
Composite keys5m 33s
-
Surrogate keys4m 40s
-
-
4. Link Data with Foreign Keys
-
What are foreign keys?2m 1s
-
IDENTITY column sequences1m 36s
-
-
5. Formalize Data Relationships
-
One-to-many relationships2m 13s
-
One-to-one relationships1m 27s
-
Many-to-many relationships2m 14s
-
Cascade updates and deletes4m 35s
-
-
6. Indexes
-
Table indexes3m 31s
-
Add indexes to a table3m 37s
-
View index statistics6m 57s
-
-
7. Constraints
-
Null constraints5m 34s
-
Unique constraints3m 46s
-
Setting default values3m 14s
-
Check constraints3m 8s
-
Conclusion
-
Next steps44s
-
- 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: Organizing data in a database