MTA Database Fundamentals (98-364) Cert Prep: 3 Storage

Prep for MTA Exam 98-364 and get a baseline understanding of the core concepts of database storage: normalization, key fields, and indexing.

Introduction

• Welcome
• Preparing for MTA Exam 98-364
• Using the exercise files
• Challenges explained
• What you should know

1. Creating Normalized Tables

• Reducing redundancy with normalization
• Understanding the first normal form (1NF)
• Understanding the second normal form (2NF)
• Fixing partial dependencies
• Understanding the third normal form (3NF)
• Exploring the fourth and fifth normal form (4NF) (5NF)
• Challenge: Normalizing a dataset
• Solution: Normalizing a dataset

2. Adding Key Fields

• Understanding the role of key fields
• Creating a table's primary key in SQL Server Management Studio
• Understanding composite primary keys
• Creating composite primary keys
• Linking tables with foreign keys
• Creating a foreign key relationship in SSMS

3. Indexing Records

• Understanding clustered indexes
• Adding a clustered index
• Understanding nonclustered indexes
• Creating a nonclustered index in SSMS
• Creating a nonclustered index using DDL
• Challenge: Creating table indexes
• Solution: Creating table indexes

Conclusion

• Next steps