Description
Course info
Rating
(18)
Level
Intermediate
Updated
Nov 18, 2016
Duration
1h 13m
Description

When studying for the Designing Database Solutions for Microsoft SQL Server (70-465) exam, it is essential to know how to design a database environment. In this course, Design a Database Environment with SQL Server 2014 (70-465), you'll learn the knowledge needed for the exam. First, you will learn how to design a migration and upgrade strategy. Next, you'll learn how to design SQL Server instances. Finally, you'll learn how to design a restore and backup strategy for data recovery. When you're finished with this course, you will have the skills and knowledge to design a database environment. Software required: SQL Server 2014.

About the author
About the author

David Peter is a Microsoft Certified Master (MCM) and has over a decade of experience with database development and administration on SQL Server, the Microsoft Business Intelligence platform, and Big Data. He specializes in scalable architecture and performance tuning on large-scale data warehouses and business analytics solutions.

More from the author
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi everyone. My name is David Peter Hansen. Welcome to my course, Design a Database Environment with SQL Server 2014. I am a data platform engineer working mainly with SQL Server and business intelligence. SQL Server is a relational database management system developed by Microsoft. This course is part of a series for those studying for the 70-465 exam, also known as Designing Database Solutions for Microsoft SQL Server. Some other major topics that we cover include how to upgrade and migrate database environments, how to design SQL Server instances, and design and restore backup strategy for data recovery. By the end of this course, you will have a solid foundation in designing a database environment. I hope you'll join me on this journey to study for the 70-465 exam with a Design a Database Environment with SQL Server 2014 course at Pluralsight.

Introduction to Database Environments
Hi, my name is David Peter Hansen, and welcome to Design a Database Environment with SQL Server 2014. This course is designed to help you with the Microsoft exam 70-465. Throughout this course, we'll take a look at three main things. What is a database environment? What issues should we be aware of when designing a database environment? And how can we design a good environment?

How to Upgrade and Migrate Database Environments
In this module, we're going to take a look at how we can upgrade and migrate our database environments to SQL Server 2014. Understanding when to upgrade and when to migrate is an essential part of the 70-465 certification. We're going to take a look at two main things in this module. First, we'll take a look at how to upgrade a database environment. We will look at what to be aware of before an upgrade, when we should upgrade, and what the process would look like. Then we will look at how to migrate a database environment with minimum downtime. We will go through the migration process and take a look at when and how to do a cross-cluster migration. We'll go through the migration process and also take a look at when and how to do a cross-cluster migration.

How to Design SQL Server Instances
In this module, we're going to take a look at how we can design SQL Server instances. We'll not cover everything there is to know, but we'll take a look at those topics that are essential for the 70-465 certification. We're going to take a look at four things in this module. First, we will take a look at how to use SysPrep to prepare a standalone instance, which then, later, can be configured. Then we will look at how we can use product update with SQL Server setup to integrate the latest updates with the main installation. Next, we will look at the use of an SMB fileshare as a storage option for our databases. And last, we will look at how to configure memory allocation for our SQL Server instance.

Design a Restore/Backup Strategy for Data Recovery
In this module, we're going to take a look at how we can design a restore and backup strategy for data recovery. Knowing how to design such strategy is an essential part of the 70-465 certification. We're going to take a look at four things in this module. First, we need to take a look at what we need for designing a restore and backup strategy, and what business requirements we need to be aware of. Then we need to look at how to backup and restore a database, and why we need to decide which recovery model we will choose for our database. We will then move on to database snapshots, and what we can use those for. Last, but not least, we will look at how to backup and restore system databases.