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

Study247

Course

Online

Price on request

The best SQL Server courses

See all

See all

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

Course Description
Microsoft SQL Server 2012 is the one of the latest versions of Microsoft SQL Server, the extremely popular and widely used database system in the world.
This course describes how to design and monitor high performance, highly available data solutions with SQL Server 2012.Study247 Academy offers Designing Database Solutions for Microsoft SQL Server 2012 course which focuses on creating plans and designs for database structure, storage, objects, and servers.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

Who Is This Course For?
Professionals who plan and design database solutions for organisations and have experience with database development and administering SQL Server databases.
By choosing online learning instead of a classroom based course, it eliminates the need for time away from work, saving you valuable time and money. It is ideal for those with tight schedules as our online courses give you 12 months unlimited access to all the course materials, so you can study at a pace that suits you. Allowing you to easily resume your studies whenever you have the time. All you need is internet connection to study, so you can study from the comfort of your home or any environment that suits you.

Requirements
Our training works on all devices including Mobile phones, IPad’s, Android tablets, Macs and PC’s.
For the best viewing experience on our state-of-the-art eLearning platform we recommend an internet connection of 10Mbps or better. Please also use Google Chrome or Mozilla Firefox as your browser with Adobe Flash Player.

Certification Details
In order to earn your certification, you’ll have to sit an exam after completing your course with us. To prepare you for your exam, we provide interactive quizzes after each module and a mock exam at the end of your course to ensure you’re fully prepared for the real thing. Once you’ve passed with at least 85%, you’ll be ready to book your exam as a private candidate.
Booking your exam is pretty simple, just purchase your exam voucher and schedule your exam. To make life easier, we can help you find an appropriate exam centre and give you all the information you need to secure your place.
Please note that the exam fees aren’t included in the course price.
Got a question about exams? Contact one of our course advisors. We’re happy to help!

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Monitoring
  • Windows
  • Server
  • Database
  • SQL
  • Database training

Course programme

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

See related categories

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

Price on request

The best SQL Server courses

See all

See all