Microsoft SQL Server 2012 データベースソリューションの設計 (#20465B)

コースの概要

• Design an appropriate database server infrastructure for a given business application scenario
• Design a logical schema for a database based on application requirements
• Design the physical implementation of a database for a given set of requirements
• Evaluate options for including binary large object data in a database design
• Plan and manage indexes to optimize performance
• Describe the key considerations for designing security for SQL Server instances and databases
• Plan SQL Server health monitoring
• Implement SQL Server health monitoring by using SQL Server Utility
• Identify and implement the appropriate backup strategy for a given scenario
• Plan and manage multi-server maintenance and automation
• Understand the benefits of using PowerShell to manage SQL Server 2012
• Design an optimal replication strategy from a given set of business and technical requirements
• Plan and implement a high availability solution

前提知識

• Transact-SQLの経験
• SQL Server 2012のコンポーネントとツールの使用経験
• SQL Serverデータベースのオブジェクトの基本知識
• 企業のWindowsネットワークとセキュリティアーキテクチャの基本知識
• MCSA：SQL Server 2012を取得済みか、前提コースを受講済みであること

主な対象者

• 組織のデータベースソリューションの設計をするSQL Serverの開発・管理エンジニア

コースの説明

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 a Partitioning Data
   • Planning 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 by Using Indexes
   • Working with Query Plans
   • Performance Monitoring
   
   
6. Designing Database Security
   • Introduction to Security Planning
   • Planning Security
   • Contained Databases
   • Protecting Data with Encryption
   
   
7. Policy Based Management
   • Introduction to Policy-Based Management
   • Planning and Implementing Policy-Based Management
   
   
8. Monitoring Server Health
   • Introduction to 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
    • Overview of Maintenance Automation
    • Managing Multiple Servers
    
    
11. Managing SQL Server with PowerShell
    • Introduction to Windows PowerShell
    • Scripting with Windows PowerShell
    
    
12. Managing SQL Server with PowerShell
    • SQL Server Replication
    • Planning Replication
    
    
13. Planning High Availability
    • High Availability in SQL Server 2012
    • AlwaysOn Availability Groups