最新消息:网盘下载利器JDownloader--|--发布资讯--|--解压出错.密码问题

Lynda – Database Fundamentals: Storage

其他教程 killking 0评论
Poster

Lynda - Database Fundamentals: Storage
Size: 215MB | Duration: 1h 22m | Video: AVC (.mp4) 1280x720 15&30fps | Audio: AAC 48KHz 2ch
Genre: eLearning | Level: Beginner | Language: 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.

Topics include:

* Reducing redundancy with normalization
* Fixing partial dependencies
* Creating primary keys
* Linking tables with foreign keys
* Creating clustered and nonclustered indexes
Lynda - Database Fundamentals: Storage

您必须 登录 才能发表评论!