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.

Course Modules & Videos

The Microsoft 70-465: Designing Database Solutions for Microsoft SQL Server 2012 course is organized into the following modules. Click a module title to view the video list contained in each section.

Module 1: Designing A Database Server Infrastructure

  • 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

Module 2: Designing A Logical Database Scheme

  • 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

Module 3: Designing A Physical Database Implementation

  • Designing A Physical Database Implementation-Part1
  • Designing A Physical Database Implementation-Part2
  • Designing A Physical Database Implementation-Part3

Module 4: Incorporating Data Files Into the Database

  • 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

Module 5: Tuning Database Performance

  • 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

Module 6: Designing Database Security

  • Designing Database Security-Part1
  • Designing Database Security-Part2
  • Contained Databases
  • Protecting Data With Encryption

Module 7: Policy Based Management

  • Policy Based Management
  • Policy Based Management Demo

Module 8: Monitoring Server Health

  • Monitoring Server Health
  • Monitoring Server Health Demo

Module 9: Designing Database Backup Solution

  • 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

Module 10: Automating Multi Server Maintenance

  • Automating Multi Server Maintenance
  • Managing Multiple Servers

Module 11: Managing SQL Server With Windows Powershell

  • Managing SQL Server WIth Windows Powershell
  • Windows Powershell Lab

Module 12: Replicating Data

  • Replicating Data-Part1
  • Replicating Data-Part2
  • Replicating Data-Part3

Module 13: Planning High Availability

  • Planning High Availability-Part1
  • Planning High Availability-Part2

Module 14: Review of SQL Statements

  • Review Of SQL Statements-Part1
  • Review Of SQL Statements-Part2
  • Review Of SQL Statements-Part3

Module 15: Eleven Rules of Database Design

  • Eleven Rules Of Database Design
  • Conclusion

Instructor led lectures

All ITNO Courses replicate a live class experience with an instructor on screen delivering the course’s theories and concepts.

These lectures are pre-recorded and available to the user 24/7. They can be repeated, rewound, fast forwarded.

Visual Demonstrations, Educational Games & Flashcards

ITNO recognizes that all students do not learn alike and different delivery mediums are needed in order to achieve success for a large student base. With that in mind, we delivery our content in a variety of different ways to ensure that students stay engaged and productive throughout their courses.

Mobile Optimization & Progress Tracking

Our courses are optimized for all mobile devices allowing students to learn on the go whenever they have free time. Students can access their courses from anywhere and their progress is completely tracked and recorded.

Practice Quizzes and Exams

ITNO Online’s custom practice exams prepare you for your exams differently and more effectively than the traditional exam preps on the market. Students will have practice quizzes after each module to ensure you are confident on the topic you are learning.

World Class Learning Management System

ITNO provides the next generation learning management system (LMS). An experience that combines the feature set of traditional Learning Management Systems with advanced functionality designed to make learning management easy and online learning engaging from the user’s perspective.