With SQL Server views, you can piece your related data tables together in whichever configuration you might need so you get easy access to the information that you’re after, even if that data is spread out across multiple tables.
- [Instructor] I've gone ahead and added some…additional records to the Two Trees database,…and I'd like to demonstrate how SQL Server…can piece together records from separate tables…to give some useful information.…First, let's take a look at the line items table.…I'll right click on it in the Two Trees database…and choose Select Top 1,000 Rows.…This will display four columns of information.…We have the Invoice ID that it's linked to,…so we can see we have data on Invoice ID number one…and invoice ID number three.…Within each invoice, we have a different number…of line items.…
So on invoice number one, we have line items one and two.…And on invoice three, we have lines one, two, and three.…Each of these lines represent an order…for a specific product.…Here we have the Product ID numbers of those referenced…in the products table, over here in the table.…And finally, we have a column for the quantity.…This is the number of bottles of each oil that were ordered.…So we can see that line one on invoice one…was for seven bottles of product number three.…
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.