Join Adam Wilbert for an in-depth discussion in this video Building indexes, part of Relational Database Fundamentals.
- View Offline
- Exercise Files
…When it comes time for your database…to retrieve the information that you've painstakingly stored,…it would often be helpful if the…most commonly searched fields contained something called indexes.…Indexes are a way for the database to…keep track of what records have already been added…to your table and to quickly retrieve a…record or a group of records when they're requested.…To get a feel for how indexes work,…let's think about how phone books are structured.…Phone books typically provide a listing of people and their telephone…number and are indexed by the last name of the individual person.…If I were to give you a name to find, say Karyn Reese, it would be…very easy to jump to the correct page…in the R section and find her telephone number.…
You can do this because the last names are ordered alphabetically, which make it…easy for you to quickly find the right name and its corresponding phone number.…However, if I were to give you just a phone number, your…task would be infinitely more difficult to find out who it belonged to.…
- What is a database management system (DBMS)?
- Moving through the database development cycle
- Preventing duplicate, inconsistent, and conflicting data entries
- Gathering requirements
- Developing relationships
- Identifying key fields
- Following a naming convention
- Developing the actual database
Skill Level Beginner
FileMaker Pro 12 Essential Trainingwith Cris Ippolite10h 28m Beginner
Financial Literacy: Reading Financial Reportswith Rudolph Rosenberg1h 25m Appropriate for all
1. Relational Database Basics
2. Preventing Data Anomalies
3. Gathering Requirements
4. Developing the Conceptual Data Model
5. Normalizing Your Data
6. Logical Design Considerations
7. Developing the Physical Database
- 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.