MOC 20465 - Designing Database Solutions for Microsoft SQL Server 2012

Print

Request an offer for delivery of this course

Course duration

Course Outline

This Microsoft SQL Server 2012 database training describes how to design and monitor high performance, highly available data solutions with SQL Server 2012. This course focuses on creating plans and designs for database structure, storage, objects, and servers. 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.

This course is intended for individuals who design database solutions for organizations and have experience with database development and administering SQL Server databases. These individuals design databases as their primary area of responsibility. They are responsible to plan and design database structure, storage, objects, and servers. They also create the plan for the environment in which the database solution runs.

  1. Designing a Database Server Infrastructure
    1. Introduction to Database Server Infrastructure
    2. Planning a Database Server Infrastructure
    3. Analyzing Capacity Requirements
    4. Considerations for Database Server Consolidation
    5. Migrating Resources in a Database Infrastructure
    6. Lab: Designing a Database Server Infrastructure
      1. Planning for Consolidation
      2. Managing Resources on a Single Instance
      3. Managing Resources for Moltiple SQL Server Instances on a Single Windows Server
      4. Managing Resources on Virtual Servers
  2. Designing a Logical Database Schema
    1. Relational Database Design Techniques
    2. Using Schemas
    3. Designing Tables
    4. Providing Users with a Denormalized View of a Database
    5. Lab: Designing a Logical Database Schema
      1. Designing a Database Schema
      2. Providing Denormalized Views of Data
  3. Designing a Physical Database Implementation
    1. Files and Filegroups
    2. Partitioning Data
    3. Compressing Data
    4. Lab: Designing a Physical Database Implementation
      1. Designing Files and Filegroups
      2. Partitioning Data
      3. Compressing Data
  4. Designing a Database Solution for BLOB Data
    1. Considerations for BLOB Data
    2. Working with FileStream
    3. Using Foll-text Search
    4. Lab: Creating a Database Solution for BLOB Data
      1. Planning for BLOB Data
      2. Creating a FileTable
      3. Using Foll-text Search
      4. Using Statistical Semantic Search
  5. Tuning Database Performance
    1. Optimizing Query Performance with Indexes
    2. Managing Query Plans
    3. Performance Monitoring and Tuning
    4. Lab: Planning for Database Performance
      1. Planning a Strategy for Improving Query Performance
      2. Assessing an Execution Plan
      3. Working with an Execution Plan
  6. Designing Database Security
    1. Designing Server-Level Security
    2. Designing Database-Level Security
    3. Transparent Database Encryption
    4. Auditing Database Activity
    5. Lab: Planning Database Security
      1. Planning Security for MIA-SQL Instance and the Human Resources Database
      2. Implementing Security for Data Access
      3. Implementing Security for SQL Server Agent
      4. Implementing Transparent Data Encryption
  7. Using Policy-Based Management
    1. Introduction to Policy-Based Management
    2. Implementing Policy-Based Management
    3. Planning For Policy-Based Management
    4. Lab: Using Policy-Based Management
      1. Planning Policy-Based Management
      2. Implementing Policy-Based Management
      3. Applying a Policy
  8. Monitoring Server Health
    1. Introduction to Health Monitoring
    2. Options for Monitoring Health
    3. Using the SQL Server Utility
    4. Lab: Monitoring Server Health
      1. Creating a Utility Control Point
      2. Configuring Health Policies
      3. Analyzing Server Health Issues
  9. Designing a Database Backup Solution
    1. SQL Server Backup and Restore
    2. Planning a Recovery Strategy
    3. Lab: Designing a Database Backup Solution
      1. Planning a Backup and Restore Strategy
      2. Testing a DR Strategy
  10. Automating Molti-Server Maintenance
    1. Overview of Maintenance Automation
    2. Managing Moltiple Servers
    3. Lab: Automating Molti-Server Maintenance
      1. Planning and Implementing a Molti-Server Environment
      2. Planning Molti-Server Jobs
  11. Managing SQL Server with PowerShell
    1. Introduction to PowerShell
    2. Lab: Managing SQL Server with PowerShell
      1. Using PowerShell interactively
      2. Backing up a Database by Using PowerShell
      3. Creating a PowerShell Script to Standardize Database Creation
  12. Replicating Data
    1. SQL Server Replication
    2. Planning Replication
    3. Lab: Planning and Implementing SQL Server Replication
      1. Planning a Replication Strategy
      2. Implementing Replication
  13. Designing for High Availability
    1. High Availability in SQL Server 2012
    2. AlwaysOn Availability Groups
    3. Lab: Implementing High Availability
      1. Planning a High Availability Strategy
      2. Implementing an AlwaysOn Availability Group
      3. Testing an AlwaysOn Availability Group

InterSource Geneva, a premier Information Technology training firm, offers over 400 different courses on server, database and programming technologies, as well as end-user classes for the most popular office, graphics and design applications. We serve clients in Switzerland (Geneva, Lausanne, Bern, Basel, Zurich) and throughout Europe (France, Germany, Austria, Finland, Sweden, England, Netherlands, Spain, etc.).


InterSource offers custom, private courses at client sites, standard public courses in our Geneva classroom, and online training via live Web conference. Training is offered in English and many other languages (Francais, Deutsch, Espanol, Italiano.)


For an overall view of our offerings, please visit us at www.intersource.ch.