Designing Database Solutions for SQL Server 2012 Год выпуска: 2015 Производитель: Lynda Сайт производителя: www.lynda.com/SQL-Server-tutorials/Designing-Database-Solutions-SQL-Server-2012/186376-2.html Автор: Martin Guidry Продолжительность: 1h 58m Тип раздаваемого материала: Видеоурок Язык: Английский Описание: Узнайте, как для проектирования баз данных, баз данных, и хранить их в tip-top форма, с помощью SQL Server 2012. Присоединиться к Мартин Guidry в этом курсе, он просматривает каждый шаг в этом процессе: от разработки инфраструктуры, логической схемы, и выполнение плана по физического оборудования, с использованием индексов для точной настройки производительности и реализации политики управления. Объясняет он передового опыта для разработки базы данных, показывает, где разработчики могут согнуть в правила, и вводит методов для управления вашей базы данных на протяжении всего жизненного цикла с помощью PowerShell и другие инструменты для мониторинга.-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.
Содержание
Introduction 3m 38s Welcome 48s What you should know before watching this course 38s Setting up for the course 2m 12s 1. Designing a Database Server Infrastructure 12m 26s Planning a database server infrastructure 1m 57s Considerations for database server consolidation 3m 58s Managing server resources in a consolidated database infrastructure 6m 31s 2. Designing a Logical Database Schema 14m 38s Designing OLTP databases 1m 54s Using first normal form 3m 41s Using second normal form 3m 10s Using third normal form 2m 41s Designing data warehouses 3m 12s 3. Designing a Physical Database Implementation 23m 22s Understanding files and filegroups 4m 11s Using multiple files 5m 25s Planning for partitioning 5m 11s Planning compression 3m 59s Restoring filegroups separately 4m 36s 4. Incorporating Data Files into Databases 7m 45s Enabling FileStream access 2m 42s Using FileStream data 5m 3s 5. Tuning Database Performance 19m 46s Understanding indexes 3m 12s Using indexes 3m 24s Working with query plans 5m 35s Working with columnstore indexes 4m 44s Indexing tips 2m 51s 6. Policy-Based Management 14m 33s Introduction to policy-based management 3m 27s Implementing policy-based management 3m 45s Extending policy-based management to repair problems 3m 22s Using policy-based management to prevent problems 3m 59s 7. Monitoring Server Health 10m 27s Introduction to server health monitoring 2m 37s Populating the data warehouse 2m 47s Exploring health data 5m 3s 8. Managing SQL Server with PowerShell 11m 0s Introduction to Windows PowerShell 4m 33s Using Windows PowerShell to run SQL commands 4m 5s Performing an SQL backup with PowerShell 2m 22s Conclusion 1m 4s Goodbye 1m 4s
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You can download files in this forum
![[Quote]](./templates/default/images/lang/en/icon_quote.gif "Reply with quote"){kind=icon}
![[Profile]](./templates/default/images/lang/en/icon_profile.gif "View user's profile"){kind=icon}
![[PM]](./templates/default/images/lang/en/icon_pm.gif "Send private message"){kind=icon}
