2015
Lynda
Martin Guidry
1h 58m
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.
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
www.lynda.com/SQL-Server-tutorials/Designing-Database-Solutions-SQL-Server-2012/186376-2.html
Download File Size:137.95 MB
|
