Microsoft 70-465: Designing Database Solution for Microsoft SQL server2012

Module 1: Designing A Database Server Infrastructure

1. Introduction
2. Designing A Database Server Infrastructure-Part1
3. Designing A Database Server Infrastructure-Part2
4. Designing A Database Server Infrastructure-Part3
5. Designing A Database Server Infrastructure-Part4
6. Considerations For Database Server Consolidation
7. Managing Server Resources

Module 2: Designing A Logical Database Scheme

1. Designing A Logical Database Scheme-Part1
2. Designing A Logical Database Scheme-Part2
3. Designing A Logical Database Scheme-Part3
4. Designing A Logical Database Scheme-Part4
5. Designing A Logical Database Scheme-Part5

Module 3: Designing A Physical Database Implementation

1. Designing A Physical Database Implementation-Part1
2. Designing A Physical Database Implementation-Part2
3. Designing A Physical Database Implementation-Part3

Module 4: Incorporating Data Files Into the Database

1. Incorporating Data Files Into The Database-Part1
2. Incorporating Data Files Into The Database-Part2
3. Incorporating Data Files Into The Database-Part3
4. Incorporating Data Files Into The Database Demo
5. Searching Data Files
6. Searching Data Files Demo

Module 5: Tuning Database Performance

1. Tuning Database Performance-Part1
2. Tuning Database Performance-Part2
3. Tuning Database Performance-Part3
4. Working With Query Plans-Part1
5. Working With Query Plans-Part2
6. Working With Query Plans-Part3
7. Working With Query Plans-Part4

Module 6: Designing Database Security

1. Designing Database Security-Part1
2. Designing Database Security-Part2
3. Contained Databases
4. Protecting Data With Encryption

Module 7: Policy Based Management

1. Policy Based Management
2. Policy Based Management Demo

Module 8: Monitoring Server Health

1. Monitoring Server Health
2. Monitoring Server Health Demo

Module 9: Designing Database Backup Solution

1. Designing Database Backup Solution-Part1
2. Designing Database Backup Solution-Part2
3. Designing Database Backup Solution-Part3
4. Designing Database Backup Solution-Part4
5. Disaster Recovery Plan-Part1
6. Disaster Recovery Plan-Part2

Module 10: Automating Multi Server Maintenance

1. Automating Multi Server Maintenance
2. Managing Multiple Servers

Module 11: Managing SQL Server With Windows PowerShell

1. Managing SQL Server With Windows PowerShell
2. Windows PowerShell Lab

Module 12: Replicating Data

1. Replicating Data-Part1
2. Replicating Data-Part2
3. Replicating Data-Part3

Module 13: Planning High Availability

1. Planning High Availability-Part1
2. Planning High Availability-Part2

Module 14: Review of SQL Statements

1. Review Of SQL Statements-Part1
2. Review Of SQL Statements-Part2
3. Review Of SQL Statements-Part3

Module 15: Eleven Rules of Database Design

1. Eleven Rules Of Database Design
2. Conclusion