Designing Database Solutions for SQL Server 2012

Réf: MS20465

Durée: 5 jours

Objectifs de la formation

– Describe the key considerations for designing security for SQL Server instances and databases

– Design a logical schema for a database based on application requirements

– Design an appropriate database server infrastructure for a given business application scenario

– Design an optimal replication strategy from a given set of business and technical 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

– Identify and implement the appropriate backup strategy for a given scenario

– Implement SQL Server health monitoring by using SQL Server Utility

– Plan and implement a high availability solution

– Plan and manage indexes to optimize performance

– Plan and manage multi-server maintenance and automation

– Plan policy-based management to manage server instances, databases, and other SQL Server 2012 objects more efficiently

– Plan SQL Server health monitoring

– Understand the benefits of using PowerShell to manage SQL Server 2012.

 

 

Programme de Formation

 

Exercices pratiques et/ou ateliers tout au long de la formation.

Module 1 : Designing a Database Server Infrastructure
• Introduction to Database Server Infrastructure
• Planning a Database Server Infrastructure
• Analyzing Capacity Requirements
• Considerations for Database Server Consolidation
• Migrating Resources in a Database Infrastructure

 

Module 2 : Designing a Logical Database Schema
• Relational Database Design Techniques
• Using Schemas
• Designing Tables
• Providing Users with a Denormalized View of a Database

 

Module 3 : Designing a Physical Database Implementation
• Files and Filegroups
• Partitioning Data
• Compressing Data

 

Module 4 : Designing a Database Solution for BLOB Data
• Considerations for BLOB Data
• Working with FileStream
• Using Full-text Search

 

Module 5 : Tuning Database Performance
• Optimizing Query Performance with Indexes
• Managing Query Plans
• Performance Monitoring and Tuning

 

Module 6 : Designing Database Security
• Designing Server-Level Security
• Designing Database-Level Security
• Transparent Database Encryption
• Auditing Database Activity

 

Module 7 : Using Policy-Based Management
• Introduction to Policy-Based Management
• Implementing Policy-Based Management
• Planning For Policy-Based Management

 

Module 8 : Monitoring Server Health
• Introduction to Health Monitoring
• Options for Monitoring Health
• Using the SQL Server Utility

 

Module 9 : Designing a Database Backup Solution
• SQL Server Backup and Restore
• Planning a Recovery Strategy

 

Module 10 : Automating Multi-Server Maintenance
• Overview of Maintenance Automation
• Managing Multiple Servers

 

Module 11 : Managing SQL Server with PowerShell
• Introduction to PowerShell

 

Module 12 : Replicating Data
• SQL Server Replication
• Planning Replication

 

Module 13 : Designing for High Availability
• High Availability in SQL Server 2012
• AlwaysOn Availability Groups

 

Profil Stagiaires & Pré-requis

‘In addition to their professional experience, students who attend this training should already have the following technical knowledge :

Experience with Transact-SQL. Familiarity with enterprise Windows network and security architecture. Familiarity with objects in a SQL Server database. Familiarity with SQL Server 2012 components and tools.

Individuals who design database solutions for organizations and have experience with database development and administering SQL Server databases’

 

Prix :

Paris uniquement :  2395 € HT

Dates de Formations

Nous Consulter