Designing Database Solutions for SQL Server 2012 With Martin Guidry

[xidau123 13]

Designing Database Solutions for SQL Server 2012 With Martin Guidry

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

 

Ukryta Zawartość

Treść widoczna tylko dla użytkowników forum DarkSiders. Zaloguj się lub załóż darmowe konto na forum aby uzyskać dostęp bez limitów.