Searching through the data tables is a common task performed by a database management system, and the process is aided by including indexes on specific fields. Too many indexes can slow down the system, but appropriately considered alternate indexes can i
- [Voiceover] When it comes time for your database…to retrieve the information that you've…painstakingly stored,…it'll often be helpful if the most commonly searched fields…contain 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 a phone book is 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 then find her telephone number.…
You can do this because the last names…are ordered alphabetically,…which makes it easy for you to quickly find the right name…and its corresponding phone number.…However, if I were to give you a telephone number,…your task would be infinitely more difficult…
Adam Wilbert covers the basics of relational database design, regardless of whether you use Access, FileMaker, Open Office, or SQL Server. Learn how to prevent data anomalies, gather requirements to plan your design, and develop a conceptual data model—translating your ideas into components like tables, relationships, queries, and views. Plus, learn about logical design considerations that can help you construct a database that is easy to maintain.
- Identify the three rules of relations.
- Summarize the four stages of developing a relational database.
- Describe a strategy one might use to ensure a database remains flexible in terms of the questions a user can ask.
- Explain how to avoid scope creep.
- Recall the characteristics of a Lookup Table.
- Recognize situations in which denormalization would be beneficial.
- Understand the types of relationships modeled by junction tables.
- Define referential integrity.
Skill Level Beginner
1. Relational Database Basics
Relational structures3m 46s
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.