Microsoft 70-465: Designing Database Solutions For Microsoft Sql Server 2012

Module 1: Designing A Database Server Infrastructure

• 1.1 Introduction
• 1.2 Designing A Database Server Infrastructure Part 1
• 1.3 Designing A Database Server Infrastructure Part 2
• 1.4 Designing A Database Server Infrastructure Part 3
• 1.5 Designing A Database Server Infrastructure Part 4
• 1.6 Considerations for Database Server Consolidation
• 1.7 Managing Server Resources

Module 2: Designing A Logical Database Scheme

• 2.1 Designing A Logical Database Scheme Part 1
• 2.2Designing A Logical Database Scheme Part 2
• 2.3 Designing A Logical Database Scheme Part 3
• 2.4 Designing A Logical Database Scheme Part 4
• 2.5 Designing A Logical Database Scheme Part 5

Module 3: Designing A Physical Database Implementation

• 3.1 Designing A Physical Database Implementation Part 1
• 3.2 Designing A Physical Database Implementation Part 2
• 3.3 Designing A Physical Database Implementation Part 3

Module 4: Incorporating Data Files into the Database

• 4.1 Incorporating Data Files into The Database Part 1
• 4.2 Incorporating Data Files into The Database Part 2
• 4.3 Incorporating Data Files into The Database Part 3
• 4.4 Incorporating Data Files into The Database Demo
• 4.5 Searching Data Files
• 4.6 Searching Data Files Demo

Module 5: Tuning Database Performance

• 5.1 Tuning Database Performance Part 1
• 5.2 Tuning Database Performance Part 2
• 5.3 Tuning Database Performance Part 3
• 5.4 Working with Query Plans Part 1
• 5.5 Working with Query Plans Part 2
• 5.6 Working with Query Plans Part 3
• 5.7 Working with Query Plans Part 4

Module 6: Designing Database Security

• 6.1 Designing Database Security Part 1
• 6.2 Designing Database Security Part 2
• 6.3 Contained Databases
• 6.4 Protecting Data with Encryption

Module 7: Policy Based Management

• 7.1 Policy Based Management
• 7.2 Policy Based Management Demo

Module 8: Monitoring Server Health

• 8.1 Monitoring Server Health
• 8.2 Monitoring Server Health Demo

Module 9: Designing Database Backup Solution

• 9.1 Designing Database Backup Solution Part 1
• 9.2 Designing Database Backup Solution Part 2
• 9.3 Designing Database Backup Solution Part 3
• 9.4 Designing Database Backup Solution Part 4
• 9.5 Disaster Recovery Plan Part 1
• 9.6 Disaster Recovery Plan Part 2

Module 10: Automating Multi Server Maintenance

• 10.1 Automating Multi Server Maintenance
• 10.2 Managing Multiple Servers

Module 11: Managing SQL Server with Windows Powershell

• 11.1 Managing SQL Server With Windows Powershell
• 11.2 Windows Powershell Lab

Module 12: Replicating Data

• 12.1 Replicating Data Part 1
• 12.2 Replicating Data Part 2
• 12.3 Replicating Data Part 3

We've put together a list of relevant job titles you can apply for after achieving the Microsoft 70-465: Designing Database Solutions for Microsoft SQL Server 2012 certification (note that some careers may require further study, training and/or work experience):

• Database Administrator
• Database Developer
• Database Analyst

• 

  Flexible Learning

  Study247 anytime, anywhere on any device.

• 

  World Class E-learning Platform

  Study in a user friendly, state-of-the-art e-learning platform.

• 

  Expert Instructor-Led Training

  Access step-by-step video tutorials delivered by leading industry experts.

• 

  Visual Demonstrations & Multimedia Presentations

  Develop your skills based on real world scenarios.

• 

  Quizzes & Mock Exam

  Interactive quizzes after each module and a mock exam at the end of your course to ensure you're fully prepared for your final certification exam.

• 

  Flash Cards & Educational Games

  Allow you to train in ways that keep you engaged and focus.

• 

  Social Learning & Networking

  Interact and collaborate with other students, form study groups, engage in discussions, rate different courses and stay up to date with all the latest industry knowledge.

• 

  Navigation & Controls

  Allows you to study in bite-size chunks. You can pause, rewind or fast forward your tutorials, take study notes and more.

As a bolt-on option, we offer Practice Labs as it provides users with an online lab platform to develop their practical skills in IT technologies such as CompTIA, Microsoft, Cisco and VMWare.

In addition to the hardware you require, you also gain access to high quality practical exercises covering exam topics to help you to maximize your study time and increase your results. Practice Labs are highly effective and offer a cheaper alternative to setting up your own test environment.

You will gain unlimited access to the Practice Labs for 12 months- helping you to consolidate your learning and prepare you for work.Learn More

When you enrol on a course with us, you automatically qualify for an XO student discount card which will enable you to enjoy savings from not only high street retailers, bars and restaurants, but also travel companies across the United Kingdom. Learn More