Lynda - Designing Database Solutions for SQL Server 2012

295MB | Duration: 1h 58m | Video: AVC (.mp4) 1280x720 15fps | Audio: AAC 48KHz 2ch
Genre: eLearning | Level: Intermediate | Language: English

Learn how to design databases, secure databases, and keep them in tip-top shape, with SQL Server 2012. Join Martin Guidry in this course, as he reviews each step in the process: from designing the infrastructure, a logical schema, and execution plan for the physical hardware, to using indexes to fine-tune performance and implementing policy-based management.

He explains best practices for database design, shows where developers can bend the rules, and introduces techniques to manage your database throughout its lifecycle with PowerShell and other monitoring tools.

Topics include:
* Planning the database infrastructure
* Designing databases vs. data warehouses
* Designing the physical database implementation
* Planning for partitioning
* Adding FileStream data
* Indexing
* Monitoring server health
* Managing SQL Server with PowerShell



Download Links :

Hide Your IP & Protect Your Privacy!
Get Your 15 Day Free Trial Now.

 TO MAC USERS: If RAR password doesn't work, use this archive program: 

RAR Expander 0.8.5 Beta 4  and extract password protected files without error.

 Gamystyle   |