Designing Database Solutions for Microsoft SQL Server 2012 MOC 20465

Transcription

1 Designing Database Solutions for Microsoft SQL Server 2012 MOC Course Outline Module 1: Designing a Database Server Infrastructure This module explains how to design an appropriate database server infrastructure for a given business application scenario - including how to decide between on-premise, cloud-based, and hybrid database servers, hardware capacity planning, considerations for storage hardware, and strategies for consolidating database server hardware. 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 Planning for Consolidation Managing Resources for an Instance of SQL Server Managing Resources for Multiple SQL Server Instances on a Single Windows Server Describe the options and considerations for creating a database server infrastructure. Describe how to plan hardware requirements for SQL Server Describe the benefits of database and server consolidation and the different options for consolidating. Describe the methods of managing server resources in a range of database infrastructure consolidation scenarios. Module 2: Designing a Logical Database Schema This module explains how to design a logical schema for a database based on application requirements. This includes planning the level of normalization, and schema and table design, and the use of views. Relational Database Design Techniques Planning Schemas and Tables

2 Lab : Designing a Logical Database Schema Plan a Database Schema Create a View to Display Employee Payment Information Describe the key techniques for designing a logical database schema. Describe the considerations for table and schema design in a relational database. Describe how to use views to provide a denormalized view of database tables to enable users to work with data more easily. Module 3: Designing a Physical Database Implementation This module explains how to design the physical implementation of a database for a given set of requirements. The design will include data files, log files, filegroups, and data partitioning, as well as whether or not to use data compression. Planning Files and Filegroups Planning a Partitioning Data Planning Compression Lab : Designing a Physical Database Implementation Planning Files and Filegroups Implement the Timesheet Archive Strategy Describe the considerations for creating and placing SQL Server data and log files. Describe how to use partitioning to improve manageability. Describe the benefits of using compression to improve performance and storage efficiently. Module 4: Incorporating Data Files into Databases This modules discusses how to consider options for including data files in a database design. 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 Exercise 1: Creating a FileTable Exercise 2: Creating and using a Full-Text Index

3 Describe the considerations for designing databases that incorporate data files. Describe the benefits and design considerations for using FileStream and FileTables to store data files. Describe the benefits of full text indexing and semantic search, and explain how to use these features to search data files in SQL Server. Module 5: Tuning Database Performance This module explains how to plan and manage indexes and how to use query plans to optimize database performance. Optimizing Query Performance by Using Indexes Working with Query Plans Performance Monitoring Lab : Using Indexes and Plan Guides Planning Indexes Testing Indexing Strategies Working with Execution Plans Describe how to plan indexes to optimize query performance. Describe how to use query plans to improve performance. Describe how to monitor performance. Module 6: Designing Database Security This module explains the key considerations for designing security for SQL Server instances and databases. Introduction to Security Planning Planning Security Contained Databases Protecting Data with Encryption Lab : Planning and Implementing Security Planning Server and Database Security Implementing a Data Access Strategy Implementing Transparent Data Encryption Describe the benefits of security planning. Describe the design considerations for planning security. Describe how to use contained databases. Describe the options for encrypting data.

6 Describe the benefits of replication and the options for planning replication in SQL Server Identify the appropriate replication solution for a given scenario. Module 13: Planning High Availability This module explains how to plan and implement a high availability solution. High Availability in SQL Server 2012 AlwaysOn Availability Groups Lab : Implementing High Availability Creating an AlwaysOn Availability Group Using an AlwaysOn Availability Group Testing Failover for an AlwaysOn Availability Group Choose a high availability strategy for a given scenario. Describe how to implement and test AlwaysOn Availability Groups

7 Describe the migration process. Describe migration and coexistence topologies. Plan for device support and device requirements. Design a software deployment strategy. Additional Reading To help you prepare for this class, review the following resources: None

The focus of this five-day instructor-led course is on planning and implementing enterprise database infrastructure solutions by using SQL Server 2014 and other Microsoft technologies. It describes how

Page 1 of 8 Overview The focus of this five-day instructor-led course is on planning and implementing enterprise database infrastructure solutions by using SQL Server 2014 and other Microsoft technologies.

Course 20465: Designing a Data Solution with Microsoft SQL Server Overview About this course The focus of this five-day instructor-led course is on planning and implementing enterprise database infrastructure

Course 20465C: Designing a Data Solution with Microsoft SQL Server Five days, instructor-led About this Course The focus of this five-day instructor-led course is on planning and implementing enterprise

6231A - Maintaining a Microsoft SQL Server 2008 Database Course Number: 6231A Course Length: 5 Days Certification Exam This course will help you prepare for the following Microsoft Certified Professional

20465C: Designing a Data Solution with Microsoft SQL Server Course Details Course Code: Duration: Notes: 20465C 5 days This course syllabus should be used to determine whether the course is appropriate

Course Summary Description The focus of this five-day instructor-led course is on planning and implementing enterprise database infrastructure solutions by using SQL and other Microsoft technologies. It

20465D: Designing Solutions for Microsoft SQL Server 2014 Course Details Course Code: Duration: Notes: 20465D 3 days This course syllabus should be used to determine whether the course is appropriate for

Course 6231A: Maintaining a Microsoft SQL Server 2008 Database About this Course Elements of this syllabus are subject to change. This five-day instructor-led course provides students with the knowledge

Key Data Product #: Course #: 6231A Number of Days: 5 Format: Certification Exams: 70-432, 70-433 Instructor-Led This course syllabus should be used to determine whether the course is appropriate for the

PowerShell for SQL Server Administrators 55069 - PowerShell for SQL Server Administrators About this Course This two-day instructor-led course provides candidates with the knowledge and skills needed to

SQL Server for Database Administrators Course Syllabus 1. Description This course teaches the administration and maintenance aspects of Microsoft SQL Server. It covers all the roles performed by administrative

This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. The course focuses on teaching individuals how to use SQL Server 2014

MCSE: Data Platform Description As you move from your role as database administrator to database professional in a cloud environment, you ll demonstrate your indispensable expertise in building enterprise-scale

Designing a Windows Server 2008 Active Directory Infrastructure and Services MOC6436 About this Course At the end of this five-day course, students will learn how to design an Active Directory Infrastructure

Page 1 of 5 Overview Who should attend? This three-day instructor-led course provides existing SQL Server database professionals with the knowledge and skills to use new and enhanced capabilities in SQL.

20462C: Administering Microsoft SQL Server Databases Course Details Course Code: Duration: Notes: 20462C 5 days This course syllabus should be used to determine whether the course is appropriate for the

SQL Server 2008 Designing, Optimizing, and Maintaining a Database Course The SQL Server 2008 Designing, Optimizing, and Maintaining a Database course will help you prepare for 70-450 exam from Microsoft.

Course 20533: Implementing Microsoft Azure Infrastructure Solutions Overview About this course This course is aimed at experienced IT Professionals who currently administer their on-premises infrastructure.

Implementing Microsoft Azure Infrastructure About this Course This course is aimed at experienced IT Professionals who currently administer their on-premise infrastructure. The course introduces the student

www.peaklearningllc.com 6436: Designing a Windows Server 2008 Active Directory Infrastructure and Services (5 Days) Introduction At the end of this five-day course, students will learn how to design an

About this Course Core Solutions of Microsoft Lync This instructor-led course teaches IT professionals how to plan, design, deploy, configure, and administer a Microsoft Lync solution. The course emphasizes

Description Course Summary This five-day instructor-led course teaches students how to install, configure, and administer Microsoft SharePoint and also how to manage and monitor sites and users by using

10775A Administering Microsoft SQL Server 2012 Databases Five days, instructor-led About this Course This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft

Course 10775A: Administering Microsoft SQL Server 2012 Databases OVERVIEW About this Course This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL