Skip to main content

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

Advanced9 Hours 45 Minutes56 Course Videos40 Test Questions

$99.00

Microsoft 70-465: Designing Database Solutions for SQL Server is an advanced online course for database staff who plan SQL Server systems. It runs for 9 hours 45 minutes over 56 videos, with 40 test questions.

  • Login details sent straight after payment
  • Self-paced. Study on any device
  • StemBoss Certificate of Completion
  • 14-day refund promise

Secure checkout. Pay by card, Apple Pay or Google Pay.

Download the course outline (PDF)

Microsoft 70-465: Designing Database Solutions for Microsoft SQL Server is an advanced online course for database professionals who plan SQL Server infrastructure, schemas, security, backup and high availability. It follows the Microsoft 70-465 exam for the MCSE: Data Platform certification. The course lasts 9 hours 45 minutes over 56 videos, with 40 test questions.

The 15 modules move from the server layer down to the data. You start with infrastructure and consolidation, then design schemas and physical storage, tune performance and plan security. Later modules cover monitoring, backup, automation, replication and high availability, and the course ends with a review of SQL statements and eleven rules of good database design.

What you will learn

  • Design a database server setup and plan server consolidation
  • Weigh on-premises and Microsoft Azure options
  • Create logical schemas and physical database designs
  • Bring data files into the database and search them
  • Tune performance using query plans
  • Design database security with contained databases and encryption
  • Use policy-based management and monitor server health
  • Plan backups, disaster recovery, replication and high availability
  • Automate multi-server tasks with Windows PowerShell

Course outline

  1. Designing a database server infrastructure: consolidation and server resources
  2. Designing a logical database schema: planning tables and links
  3. Designing a physical database: how data is stored
  4. Incorporating data files: adding and searching data files
  5. Tuning database performance: working with query plans
  6. Designing database security: contained databases and encryption
  7. Policy-based management: setting and enforcing rules
  8. Monitoring server health: checking server state
  9. Designing a backup solution: backups and a disaster recovery plan
  10. Automating multi-server maintenance: managing many servers
  11. Managing SQL Server with PowerShell: scripting admin tasks with a lab
  12. Replicating data: copying data between servers
  13. Planning high availability: keeping systems online
  14. Review of SQL statements: a refresher on core T-SQL
  15. Eleven rules of database design: practical design principles

Who this course is for

  • Experienced database administrators moving into design roles
  • IT staff who plan SQL Server systems
  • Teams still running SQL Server 2012
  • Learners building towards database architect roles
  • Data engineers who need to understand database design choices

Before you start

This is an advanced design course. You should already be able to run SQL Server and write T-SQL. Microsoft 70-462 and 70-464 are good courses to take first.

About the 70-465 exam

Microsoft 70-465 checked your ability to plan and design database solutions with SQL Server 2012 and 2014, including infrastructure, schemas, security, backup, high availability and on-premises or Azure options. Microsoft issued it as one of the exams for the MCSE: Data Platform certification.

Microsoft retired 70-465 on 31 January 2021 along with the other MCSE exams. The design principles in this course still apply to planning SQL Server systems.

Jobs this course supports

  • Database Architect
  • Database Administrator
  • Data Engineer

Skill level

Advanced
Duration

9 Hours 45 Minutes
Videos

56 Course Videos
Questions

40 Test Questions
Certification

MCSE: Data Platform (retired)
Exam code

70-465
Certification body

Microsoft
Prerequisites

Working SQL Server admin and T-SQL skills.
Best for

Database architects, database administrators, data engineers
Topics covered

Server infrastructure, logical and physical design, performance tuning, database security, policy-based management, backup and disaster recovery, PowerShell, replication and high availability
Format

Online video lessons, self-paced
Language

English
Closed captions

Yes
Certificate

StemBoss Certificate of Completion

What is inside this course

15 modules and 56 lessons. Here is the full outline.

Module 1: Designing A Database Server Infrastructure7 lessons
  1. Introduction
  2. Designing A Database Server Infrastructure-Part1
  3. Designing A Database Server Infrastructure-Part2
  4. Designing A Database Server Infrastructure-Part3
  5. Designing A Database Server Infrastructure-Part4
  6. Considerations For Database Server Consolidation
  7. Managing Server Resources
Module 2: Designing A Logical Database Scheme5 lessons
  1. Designing A Logical Database Scheme-Part1
  2. Designing A Logical Database Scheme-Part2
  3. Designing A Logical Database Scheme-Part3
  4. Designing A Logical Database Scheme-Part4
  5. Designing A Logical Database Scheme-Part5
Module 3: Designing A Physical Database Implementation3 lessons
  1. Designing A Physical Database Implementation-Part1
  2. Designing A Physical Database Implementation-Part2
  3. Designing A Physical Database Implementation-Part3
Module 4: Incorporating Data Files Into the Database6 lessons
  1. Incorporating Data Files Into The Database-Part1
  2. Incorporating Data Files Into The Database-Part2
  3. Incorporating Data Files Into The Database-Part3
  4. Incorporating Data Files Into The Database Demo
  5. Searching Data Files
  6. Searching Data Files Demo
Module 5: Tuning Database Performance7 lessons
  1. Tuning Database Performance-Part1
  2. Tuning Database Performance-Part2
  3. Tuning Database Performance-Part3
  4. Working With Query Plans-Part1
  5. Working With Query Plans-Part2
  6. Working With Query Plans-Part3
  7. Working With Query Plans-Part4
Module 6: Designing Database Security4 lessons
  1. Designing Database Security-Part1
  2. Designing Database Security-Part2
  3. Contained Databases
  4. Protecting Data With Encryption
Module 7: Policy Based Management2 lessons
  1. Policy Based Management
  2. Policy Based Management Demo
Module 8: Monitoring Server Health2 lessons
  1. Monitoring Server Health
  2. Monitoring Server Health Demo
Module 9: Designing Database Backup Solution6 lessons
  1. Designing Database Backup Solution-Part1
  2. Designing Database Backup Solution-Part2
  3. Designing Database Backup Solution-Part3
  4. Designing Database Backup Solution-Part4
  5. Disaster Recovery Plan-Part1
  6. Disaster Recovery Plan-Part2
Module 10: Automating Multi Server Maintenance2 lessons
  1. Automating Multi Server Maintenance
  2. Managing Multiple Servers
Module 11: Managing SQL Server With Windows Powershell2 lessons
  1. Managing SQL Server WIth Windows Powershell
  2. Windows Powershell Lab
Module 12: Replicating Data3 lessons
  1. Replicating Data-Part1
  2. Replicating Data-Part2
  3. Replicating Data-Part3
Module 13: Planning High Availability2 lessons
  1. Planning High Availability-Part1
  2. Planning High Availability-Part2
Module 14: Review of SQL Statements3 lessons
  1. Review Of SQL Statements-Part1
  2. Review Of SQL Statements-Part2
  3. Review Of SQL Statements-Part3
Module 15: Eleven Rules of Database Design2 lessons
  1. Eleven Rules Of Database Design
  2. Conclusion

Your learning path

Where Microsoft 70-465: Designing Database Solutions for Microsoft SQL Server fits. Build your skills one step at a time.

Take firstMicrosoft 70-464: Developing Microsoft SQL Server DatabasesTake firstMicrosoft 70-462: Administering SQL Server Databases
You are hereMicrosoft 70-465: Designing Database Solutions for Microsoft SQL Server
Next stepMicrosoft 70-467 - Designing Business Intelligence Solutions with SQL Server

Frequently asked questions

Can I still take the Microsoft 70-465 exam?

No. Microsoft retired 70-465 on 31 January 2021. The course still teaches sound SQL Server design and planning.

What should I study before this course?

It helps to take Microsoft 70-462 for administration and 70-464 for database development first, as this course builds on both.

Does it cover cloud options?

Yes. You look at on-premises and Microsoft Azure options when planning a database setup.

Is PowerShell included?

Yes. One module covers managing SQL Server with Windows PowerShell, with a lab.

Does it cover disaster recovery?

Yes. You learn to design a backup solution and write a disaster recovery plan, and also plan replication and high availability.

Do I get a certificate?

Yes. You get a StemBoss Certificate of Completion when you finish the course.

Can I get a refund?

Yes, within 14 days if you have completed less than 20% of the course. See our refund policy for details. Read the refund policy.

Related courses

$99.00
Buy course