->
Lynda - SQL Server 2012: Designing Database Solutions - 186376
Lynda - SQL Server 2012: Designing Database Solutions
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.


Table of Contents

  • Introduction
  • 1. Designing a Database Server Infrastructure
  • 2. Designing a Logical Database Schema
  • 3. Designing a Physical Database Implementation
  • 4. Incorporating Data Files into Databases
  • 5. Tuning Database Performance
  • 6. Policy-Based Management
  • 7. Monitoring Server Health
  • 8. Managing SQL Server with PowerShell
  • Conclusion
  • Lynda - SQL Server 2012: Designing Database Solutions


     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.


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

    Latest Winrar  and extract password protected files without error.


     Coktum   |  

    Information
    Members of Guests cannot leave comments.




    rss