Course Details
In this course, you will learn to create plans and designs for database structure, storage, objects, and servers through hands-on labs and design tasks. You will learn to design and monitor high performance, highly available data solutions with Microsoft SQL Server 2012 along with data compression, high availability, data migration, security, and scalability.
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.
Course Prerequisites
You should have the following technical knowledge to attend this course:
- Transact-SQL
- SQL Server 2012 components and tools
- Objects in a SQL Server database
- Enterprise Windows network and security architecture
- MCSA: SQL Server 2012 certification or the knowledge and skills from the following courses:
Course Agenda
1. Designing a Database Server Infrastructure
- Planning a Database Server Infrastructure
- Planning Server Hardware
- Considerations for Database Server Consolidation
- Managing Server Resources in a Consolidated Database Infrastructure
2. Designing a Logical Database Schema
- Relational Database Design Techniques
- Planning Schemas and Tables
3. Designing a Physical Database Implementation
- Planning Files and Filegroups
- Planning Data Partitioning and Compression
4. Incorporating Data Files into Databases
- Considerations for Working with Data Files in SQL Server 2012
- Implementing FileStream and FileTables
- Searching Data Files
5. Tuning Database Performance
- Optimizing Query Performance with Indexes
- Managing Query Plans
- Performance Monitoring
6. Designing Database Security
- Security Planning
- Plan Security
- Contained Databases
- Protecting Data with Encryption
7. Policy-Based Management
- Basics of Policy-Based Management
- Planning and Implementing Policy-Based Management
8. Monitoring Server Health
- Basics of Server Health Monitoring
- SQL Server Utility
9. Designing a Database Backup Solution
- SQL Server Backup and Restore
- Planning a Recovery Strategy
10. Automating Multi-Server Maintenance
- Maintenance Automation
- Managing Multiple Servers
11. Managing SQL Server with PowerShell
- Windows PowerShell
- Scripting with Windows PowerShell
12. Replicating Data
- SQL Server Replication
- Planning Replication
13. Designing for High Availability
- High Availability in SQL Server 2012
- AlwaysOn Availability Groups