Prep for MTA Exam 98-364 and get a baseline understanding of the core concepts of database storage: normalization, key fields, and indexing.
MTA Database Fundamentals (98-364) Cert Prep: 3 Storage
Overview
Syllabus
Introduction
- Welcome
- Preparing for MTA Exam 98-364
- Using the exercise files
- Challenges explained
- What you should know
- 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
- 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
- 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
- Next steps
Taught by
Adam Wilbert
