2015
Lynda
Adam Wilbert
1:22
English
Storage is a database's full-time job. Yet many IT professionals never really learn how it's done. This course is designed to change that, providing a baseline understanding of databases and their mechanics. Adam Wilbert covers normalization, a table structuring technique that reduces data redundancy; primary, foreign, and composite keys—features supporting the table relationships that underlie relational databases; and indexing, which helps speed up data retrieval. Along the way, Adam will provide tips for working with SQL Server Management Studio and some challenges to help you practice what you've learned.
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.
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
Download File Size:205.76 MB