JULY SITEWIDE DEALS | UP TO 50% Off
40% OFF SITEWIDE LABOR DAY SALE

Shop our Labor Day sale and take 40% off all regularly priced courses and bundles sitewide.  Just add to cart to see your discounts.

Lock In At Our Lowest Price Ever: $14.99/month for 2,500+ hours of IT training.
Limited time only. Enroll now, cancel anytime!

Microsoft 70-465: Designing Database Solutions

In this course you will learn how to plan and implement enterprise database infrastructure solutions by using SQL Server 2012 and other Microsoft technologies. This course will teach you 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. You will learn how to create plans and designs for database structure, storage, objects, and servers.

Included In This Course

Included In This Course

Total Hours
10  Training Hours
Microsoft 70-465: Designing Database Solutions
56 On-demand Videos
Closed Caption

Closed Captions

Course Topics
15  Topics
Prep Questions
40 Prep Questions
Microsoft 70-465: Designing Database Solutions

Certificate of Completion

Course Description

Note: Although the associated examination for this course has been retired, it is a good resource for training.

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.

Frequently Asked Questions About Microsoft 70-465: Designing Database Solutions

What will I learn in the Microsoft 70-465 course?

In this course, you’ll learn to plan and implement enterprise database infrastructure solutions using SQL Server 2012 and other Microsoft technologies. You’ll get to work with both on-premises and Microsoft Azure cloud-based solutions, and learn how to plan for high availability and disaster recovery solutions. Basically, it’s all about creating plans and designs for database structure, storage, objects, and servers.

How is the course structured?

The course is pretty extensive with 10 training hours, 56 videos, and 15 topics. There are also 40 practice questions to help reinforce what you’ve learned.

I heard the associated exam has been retired. Is this course still useful?

Good question! Although the associated exam for this course has been retired, the course itself can still be a valuable resource for training. It’s a great way to deepen your understanding of SQL Server 2012 and related technologies.

How do I get access to the course?

You can access this course through the All Access Monthly Subscription. This subscription will also give you access to over 2,500 hours of on-demand content. Plus, you can start with a 7-day free trial with no obligation, and you can cancel anytime​.

Does ITU Online offer other courses as well?

Absolutely! ITU Online offers a wide range of courses in different categories, including Adobe, Business & Management, Cisco, Cloud Computing, CompTIA, Cybersecurity, Data Administration, Data Analysis, Development & Programming, and many more. You’ll have plenty to choose from​.

Can I ask more questions or get help if I’m stuck?

Sure thing! You can reach out to ITU Online customer service. They’re available Monday to Friday, from 9:00 am to 5:00 pm ET. You can call them at +1 855.488.5327 or send an email to customerservice@ituonline.com

Proudly Display
Your Achievement

Upon completion of your training, you’ll receive a personalized certificate of completion to help validate to others your new skills.
Example Certificate

Course Outline

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

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

Add a review
Microsoft 70-465: Designing Database Solutions Microsoft 70-465: Designing Database Solutions
Rating*
0/5
* Rating is required
Your review
* Review is required
Name
* Name is required
4.8
Based on 49 reviews
5 star
78
78%
4 star
22
22%
3 star
0%
2 star
0%
1 star
0%
1-5 of 49 reviews
  1. I was looking for an online course for Six Sigma as my new boss is a true believer and I wanted to have a better handle of what is Six Sigma. I started looking around and found ITU, and bought the course, and could not be happier. I have no intention of getting certified, but at least now I can speak the jargon and understand what my boss is talking about.

  2. The educators at ituonline.com are highly skilled but could improve their methods of instruction. In the CCNA 200-301 course, there’s a heavy emphasis on oral lectures, and it would be beneficial to include more in-depth visual aids. Annotating labs and graphics could also make the educational journey more effective. On the other hand, the N10-008 course instructor consistently offers top-notch material.

  3. The CompTIA PenTest was an excellent course and the instructor, Chrys, explained the material in a clear and easy way for me to understand and comprehend essential techniques. Highly recommend!

  4. This course is super detailed but not boring, and they give you cool projects to actually practice what you’re learning.

Microsoft 70-465: Designing Database Solutions
 

$49.00

OR

Subscribe To All-Access

Gain access to this training and all our other courses, offering over 2,500 hours of content, with our cost-effective monthly subscription. No obligations. Cancel anytime.

$49.00 $14.99 Monthly

Microsoft 70-465: Designing Database Solutions

Microsoft 70-465: Designing Database Solutions for Microsoft SQL Server
Microsoft 70-465: Designing Database Solutions
Additional Options to Access This Training
This training is also part of our extensive training library containing over 225 courses, 12,000+ videos and over 19,000 practice test questions.

Monthly All-Access Subscription
7 Days Free - $39.00 / month

A great option at an affordable monthly price.

Annual All-Access Subscription
$229 / year

A discounted price when paying for your All Access library on an annual basis.

Lifetime All-Access Library
$379 One time payment

Exceptional Value. Pay once, never have to buy IT training again.

Related Courses

$49.00

Learn how to handle Big Data with Microsoft SQL 2019. Master the art of data analysis & management with our online training course. Enroll now!

Dive into the depths of SQL Server with this Microsoft SQL – SQL Big Data course and discover one of its most invaluable tools, SQL Big Data Clusters. Here, you will fully explore data virtualization and lakes in order to build a complete artificial intelligence (AI) and machine learning (ML) platform directly within the SQL Server database engine.

$49.00

Master the skills to become a Microsoft Certified Solutions Associate with our 70-462 Administering SQL Server course. Enroll now and start your journey!

In this Microsoft 70-462: Administering SQL Server Databases course you will learn how to perform installation, maintenance, and configuration tasks. This course will also teach you other responsibilities including setting up database systems, making sure those systems operate efficiently, and regularly storing, backing up, and securing data from unauthorized access. This course will provide students with the knowledge and skills to maintain a Microsoft SQL Server 2012 database and focuses on teaching individuals how to use SQL Server 2012 product features and tools related to maintaining a database.

$49.00

Learn how to develop cutting-edge web applications with Microsoft .NET 4.5 Programming and HTML5. Enroll now and get certified!

In this online IT learning course you will learn the .NET open source developer platform. This platform provides a comprehensive and consistent programming model for building web applications that have visually stunning user experiences and seamless and secure communication. HTML 5, Javascript and CSS3 can integrate with this platform.