In this course, you will learn to plan and implement enterprise database infrastructure solutions using Microsoft SQL Server 2012 and 2014. You will be introduced to Enterprise Data Architecture along with multi-server configuration management. You'll then delve into database solutions including: consolidating database workloads, cloud data, Microsoft Azure services, high availability, clustering, AlwaysOn Availability, disaster recovery, and data replication.
This course incorporates material from the Official Microsoft Learning Product 20465 and covers the skills and knowledge measured by Exam 70-465: Designing Database Solutions for Microsoft SQL Server 2012 and, in conjunction with on-the-job experience, can help you prepare for the exam.
Our Microsoft Training Exclusives
- Six months of anytime access to your course labs and lab environment
- Six months of 24/7 access to mentoring via chat, email, and phone
- Six months of on-demand access to indexed, searchable recordings of your Virtual Classroom Live or Virtual Classroom Fit class
- Six months of unlimited retakes of your class
What You'll Learn
- Access an Existing Enterprise Environment
- Plan and Implement Policy-Based Management
- Consolidation Workloads
- Private Cloud Considerations
- Microsoft Azure Storage
- Implement and Configure Databases in Microsoft Azure Database and in Microsoft Azure Virtual Machines
- Windows Server Failover Clustering and AlwaysOn Failover Cluster Instance
- AlwaysOn Availability Groups Implementation
- High Availability and Disaster Recovery Solutions
- Plan and Implement Database Replication
Who Needs to Attend
- IT professionals who design database solutions and have experience with database development and administration of SQL Server databases
- IT professionals who need to learn database infrastructure, consolidation strategies, IT scenarios for on-premise, cloud and hybrid, high availability and disaster recovery solutions
Prerequisites
- You should have technical knowledge of relational databases, including
- Database planning, implementation, and management
- Querying with Transact-SQL
- Basic knowledge of high availability, disaster recovery, and Microsoft Azure technologies around cloud computing
Knowledge and skills from the following courses:
- Querying Microsoft SQL Server 2012 (M10774)
- Administering Microsoft SQL Server 2012 Databases (M10775)
- Developing Microsoft SQL Server 2012 Databases (M10776)
Follow-On Courses
There are no follow-ons for this course.
Certification Programs and Certificate Tracks
This course is part of the following programs or tracks:
Course Outline
1. Introduction to Enterprise Data Architecture
- Enterprise Data Considerations
- Access an Existing Infrastructure
2. Multi-Server Configuration Management
- Policy-based Management
- Microsoft System Center
3. Consolidate Database Workloads with SQL Server 2014
- Database Server Consolidation Considerations
- Resource Management in a Consolidated Database Infrastructure
4. Introduction to Cloud Data Solutions
- Cloud Computing
- SQL Server in a Private Cloud
5. Introduction to Microsoft Azure
- Microsoft Azure Overview and Microsoft Storage
6. Microsoft Azure SQL Database
- Introduction to Microsoft Azure SQL Database
- Microsoft Azure SQL Database Security
- Implement and Manage Databases
7. SQL Server in Microsoft Azure Virtual Machines
- Introduction to Microsoft Azure Virtual Machines
- Microsoft Azure Virtual Machine Connectivity and Security
- Create Databases in a Microsoft Azure Virtual Machine
8. Introduction to High Availability in SQL Server 2014
- High Availability Concepts and Options in SQL Server 2014
- Log Shipping
9. Clustering with Windows Server and SQL Server 2014
- Introduction to Windows Server Failover Clustering
- SQL Server AlwaysOn Failover Cluster Instances
10. Automating Multi-Server Maintenance AlwaysOn Availability Groups
- AlwaysOn Availability Groups Introduction and Considerations
11. Plan High Availability and Disaster Recover
- High Availability and Disaster Recovery with SQL Server 2014
- High Availability and Disaster Recovery for Databases in Microsoft Azure
12. Replicating Data
- SQL Server Replication
- Planning Replication
Labs
Lab 1: Assess an Existing Enterprise Data Infrastructure
- MAP Toolkit
- Review MAP Toolkit Reports
Lab 2: Plan and Implement Policy-Based Management
Lab 3: SQL Server Consolidation
- Prepare for Database Consolidation
- Manage Resources for an Instance of SQL Server
- Manage Resources for Multiple Instances on a Windows Server
Lab 4: Prepare a SQL Server Installation in a Virtual Machine Template
- Create and Complete a Prepared Instance
Lab 5: Microsoft Azure
- Create a Microsoft Azure Storage Account
- Backup a Database to Microsoft Azure
Lab 6: Microsoft Azure SQL Database
- Provision a Microsoft Azure SQL Database
- Configure Microsoft Azure SQL Database Security
- Migrate a Database to Microsoft Azure SQL Database
Lab 7: Plan Policy-Based Management Microsoft Azure Virtual Machines
- Create a Microsoft Azure Virtual Machine
- Configure Microsoft Azure Virtual Machine Security and Connectivity
- Create Databases on a Virtual Machine
Lab 8: Log Shipping
- Configure and Test Log Shipping
- Test Failover
Lab 9: Implement an AlwaysOn Failover Cluster Instance
- Windows Server Failover Cluster Configuration
- Install an AlwaysOn Failover Cluster Instance
- Configure tempdb to use Local Storage
- Test Automatic Failover and Failback
Lab 10: Implement and Test an AlwaysOn Availability Group
- Implement and Connect to an AlwaysOn Availability Group
- Test Failover
- Configure Quorum Voting
Lab 11: Plan High Availability and Disaster Recovery
- High Availability and Disaster Recovery Solutions with SQL Server 2014 and using Microsoft Azure
Lab 12: Plan and Implement Replication
