Download Now

Database Foundations Storage
Database Foundations: Storage
MP4 | Video: 720p | Duration: 1:22:16 | English | Subtitles: VTT | 211.8 MB


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 WeiRuan-->WeiRuan Technology Associate (MTA) Exam 98-364, Database Administration Fundamentals. Find out more at

Topics include:
Reducing redundancy with normalizationFixing partial dependenciesCreating primary keysLinking tables with foreign keysCreating clustered and nonclustered indexes

Download link

Direct Download

Tags: Database, Foundations, Storage

Add Comments:
Enter Code: *