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. NT-compus 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.
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.
Topics
include:
- Reducing redundancy with normalization
- Fixing partial dependencies
- Creating primary keys
- Linking tables with foreign keys
- Creating clustered and nonclustered indexes
0 comments:
Post a Comment