In 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
- [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.
Relational Databases Essential Trainingwith Adam Wilbert2h 12m Intermediate
1. Data Types
2. Design a Normalized Database
3. Identify Rows with Primary Keys
4. Link Data with Foreign Keys
5. Formalize Data Relationships
- 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.