From the course: Access 2019: Building Dashboards for Excel
Join today to access over 22,700 courses taught by industry experts or purchase this course individually.
Learning the basics of normalization
From the course: Access 2019: Building Dashboards for Excel
Learning the basics of normalization
- [Instructor] It's important to understand that when you're working with the back end of a database, the way the data is stored is not necessarily how we look at it when we report on it. Let's take a look at some normalization. If you look at the data extract file, you'll notice that we see repetitive user names, and maybe even repetitive video names. That's because we're looking at the users and the videos that they watched. This is an example of data being de-normalized. Let's take a look at how this is actually stored in the database. I'll go ahead and close this extract file. Okay, go ahead and double-click on Users. So the way that this database was designed, it was designed using the rules of normalization. Every table contains information about that particular entity. For example, the Users table has information about the users and there's a single record for each user. Now let's go ahead and take a look at the…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.