Prep for MTA Exam 98-364 and get a baseline understanding of the core concepts of database storage: normalization, key fields, and indexing.
- [Voiceover] Hello, my name is Adam Wilbert, and I'd like to welcome you to Database Fundamentals, Storage. This is the third of four courses in the Database Fundamentals series, where we'll ease you in to the world if information technology. We'll start by taking a look at a topic that's at the foundation of good database design, normalization. Creating tables that conform to the normal forms might sound a bit technical at first, but I'll show you how to evaluate your table structures one step at a time. And we'll make changes to the storage plan in order to be in compliance. Then, we'll spend some time exploring the role of key fields in our data tables.
We'll see how to create primary keys using one or more columns, and see how to use them to link to related data in other tables using foreign keys. I'll also introduce the concept of referential integrity, which will keep you data and your database reliable and connected to the proper related records. We'll wrap up the course with a discussion of table indexes, and I'll show you how adding additional indexes to your tables can help speed up the retrieval of records when it comes time to querying out specific information. Along the way, I'll provide some helpful tips to working with SQL Server Management Studio, as well as provide some insights into the way I work with databases through a couple of hands-on, challenge-and-solution movies.
So I'm glad you've decided to join me as we take a closer look at the construction details to help our data tables perform at their best. Now let's get started.
Note: This course will also prepare certification candidates for the "Understanding data storage" domain of the Microsoft Technology Associate (MTA) Exam 98-364, Database Administration Fundamentals. Find out more at https://www.microsoft.com/learning/en-us/exam-98-364.aspx.
- Reducing redundancy with normalization
- Fixing partial dependencies
- Creating primary keys
- Linking tables with foreign keys
- Creating clustered and nonclustered indexes