NewEra Technology Facebook
20465 Designing Database Solutions for Microsoft® SQL Server® 2012 - Virtual Led Training - Course Information
PRINT
SEND TO A FRIEND
Name: 20465 Designing Database Solutions for Microsoft® SQL Server® 2012 - Virtual Led Training
Category: Microsoft Official Curriculum Courses
Length (Days): 5
Course Price (CAD): 2750
Description:
Students will have the opportunity to practices hands-on skills and design tasks in a virtual lab environment and will learn about topics such as data compression, high availability, data migration, security, and scalability.
Prerequisites:
•10774 Querying Microsoft SQL Server 2012
•10775 Administering Microsoft SQL Server 2012 Databases
•10776 Developing Microsoft SQL Server 2012 Databases
Outline:
Lesson 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
◦Lab : Planning Database Server Consolidation

Lesson 2 - Designing a Logical Database Schema
◦Relational Database Design Techniques
◦Planning Schemas and Tables
◦Lab : Designing a Logical Database Schema

Lesson 3 - Designing a Physical Database Implementation
◦Planning Files and Filegroups
◦Planning a Partitioning Data
◦Planning Compression
◦Lab : Designing a Physical Database Implementation

Lesson 4 - Incorporating Data Files into Databases
◦Considerations for Working with Data Files in SQL Server 2012
◦Implementing FileStream and FileTables
◦Searching Data Files
◦Lab : Implementing a Solution for Storing Data Files

Lesson 5 - Tuning Database Performance
◦Optimizing Query Performance by Using Indexes
◦Working with Query Plans
◦Performance Monitoring
◦Lab : Using Indexes and Plan Guides

Lesson 6 - Designing Database Security
◦Introduction to Security Planning
◦Planning Security
◦Contained Databases
◦Protecting Data with Encryption
◦Lab : Planning and Implementing Security

Lesson 7 - Policy Based Management
◦Introduction to Policy-Based Management
◦Planning and Implementing Policy-Based Management
◦Lab : Planning Policy-Based Management

Lesson 8 - Monitoring Server Health
◦Introduction to Server Health Monitoring
◦SQL Server Utility
◦Lab : Monitoring Server Health

Lesson 9 - Designing a Database Backup Solution
◦SQL Server Backup and Restore
◦Planning a Recovery Strategy
◦Lab : Planning and Implementing a Backup Strategy

Lesson 10 - Automating Multi-Server Maintenance
◦Overview of Maintenance Automation
◦Managing Multiple Servers
◦Lab : Automating Multi-Server Maintenance

Lesson 11 - Managing SQL Server with PowerShell
◦Introduction to Windows PowerShell
◦Scripting with Windows PowerShell
◦Lab : Managing SQL Server with Windows PowerShell

Lesson 12 - Replicating Data
◦SQL Server Replication
◦Planning Replication
◦Lab : Planning and Implementing SQL Server Replication

Lesson 13 - Planning High Availability
◦High Availability in SQL Server 2012
◦AlwaysOn Availability Groups
◦Lab : Implementing High Availability
Guaranteed to run courses