Microsoft 70-465: Designing Database Solutions for Microsoft SQL Server 2012

This course prepares students for the Microsoft 70-465 Designing Database Solutions for Microsoft SQL Server 2012 exam. The course teaches students how to  plan and implement enterprise database infrastructure solutions by using SQL Server 2012 and other Microsoft technologies.

The course describes how to consolidate SQL Server workloads, work with both on-premises and Microsoft Azure cloud-based solutions, and how to plan and implement high availability and disaster recovery solutions.

$39.99

Description

This course prepares students for the Microsoft 70-465 Designing Database Solutions for Microsoft SQL Server 2012 exam.

The course teaches students how to  plan and implement enterprise database infrastructure solutions by using SQL Server 2012 and other Microsoft technologies. The course describes how to consolidate SQL Server workloads, work with both on-premises and Microsoft Azure cloud-based solutions, and how to plan and implement high availability and disaster recovery solutions.

To see more Microsoft related training, Visit the Microsoft Website.

Course Outline

Microsoft 70-465: Designing Database Solutions for Microsoft SQL Server 2012 Course Content

Download Course Outline

Introduction

Designing A Database Server Infrastructure-Part1

Designing A Database Server Infrastructure-Part2

Designing A Database Server Infrastructure-Part3

Designing A Database Server Infrastructure-Part4

Considerations For Database Server Consolidation

Managing Server Resources

Designing A Logical Database Scheme-Part1

Designing A Logical Database Scheme-Part2

Designing A Logical Database Scheme-Part3

Designing A Logical Database Scheme-Part4

Designing A Logical Database Scheme-Part5

Designing A Physical Database Implementation-Part1

Designing A Physical Database Implementation-Part2

Designing A Physical Database Implementation-Part3

Incorporating Data Files Into The Database-Part1

Incorporating Data Files Into The Database-Part2

Incorporating Data Files Into The Database-Part3

Incorporating Data Files Into The Database Demo

Searching Data Files

Searching Data Files Demo

Tuning Database Performance-Part1

Tuning Database Performance-Part2

Tuning Database Performance-Part3

Working With Query Plans-Part1

Working With Query Plans-Part2

Working With Query Plans-Part3

Working With Query Plans-Part4

Designing Database Security-Part1

Designing Database Security-Part2

Contained Databases

Protecting Data With Encryption

Policy Based Management

Policy Based Management Demo

Monitoring Server Health

Monitoring Server Health Demo

Designing Database Backup Solution-Part1

Designing Database Backup Solution-Part2

Designing Database Backup Solution-Part3

Designing Database Backup Solution-Part4

Disaster Recovery Plan-Part1

Disaster Recovery Plan-Part2

Automating Multi Server Maintenance

Managing Multiple Servers

Managing SQL Server WIth Windows Powershell

Windows Powershell Lab

Replicating Data-Part1

Replicating Data-Part2

Replicating Data-Part3

Planning High Availability-Part1

Planning High Availability-Part2

Review Of SQL Statements-Part1

Review Of SQL Statements-Part2

Review Of SQL Statements-Part3

Eleven Rules Of Database Design

Conclusion

$39.99

Course features:

10 Hrs 45 Min

56 VIDEOS

1 Year Access

Available on Web