English French German Italian Portuguese Russian Spanish


  • Database Training

    databaseInterSource offers live instructor-led courses on all important database programming technologies, including Crystal Reports, Microsoft Access, MySQL, Oracle, SQL, SQL Server, SSAS, SSIS, SSRS and Xcelsius.

    These live classes are offered both on client sites, at our Geneva training center, and via a Web interface.

  • About Database

    A database is a collection of data stored and maintained for one or more uses. Most modern databases are managed by a Database Management System (DBMS), a set of computer programs that controls the creation, maintenance, and the use of the database with computer as a platform or of an organization and its end users. It allows organizations to place control of organization-wide database development in the hands of database administrators (DBAs) and other specialists.

    The proper integration of databases can dramatically increase the functionality of all types of applications, whether or not Web-enabled.

    Read More
  • Course Details Database

    Classes are offered at client sites, at our Geneva training center, and via a live web conference. For detailed course outlines and scheduled classes, please see below.

    To book training, navigate to the course you need, then:

    • For scheduled online classes, register from the choices indicated.
    • If you need an alternative dates, time or location, or if you want a live classroom course, click on “request an offer for this course,” to complete the form.

    InterSource clients are active globally. Live web courses run during Eastern Standard Time (New York) business hours and are priced in US dollars.

    We also run live web conference classes during European business hours, which can be invoiced in local currencies. To discuss your requirements please contact us on +41 (22) 958 0114.

MOC 20465 - Designing Database Solutions for Microsoft SQL Server 2012

 PDF PrintEmail

Course duration

  • 5 Days

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.

  • Learn to design an appropriate database server infrastructure for a given business application scenario
  • Learn to design a logical schema for a database based on application requirements
  • Learn to design the physical implementation of a database for a given set of requirements
  • Learn to evaluate options for including binary large object data in a database design
  • Learn to plan and manage indexes to optimize performance
  • Describe the key considerations for designing security for SQL Server instances and databases
  • Learn to plan policy-based management to manage server instances, databases, and other SQL Server 2012 objects more efficiently
  • Learn to plan SQL Server health monitoring
  • Learn to implement SQL Server health monitoring by using SQL Server Utility
  • Learn to identify and implement the appropriate backup strategy for a given scenario
  • Learn to plan and manage multi-server maintenance and automation
  • Understand the benefits of using PowerShell to manage SQL Server 2012
  • Learn to design an optimal replication strategy from a given set of business and technical requirements
  • Learn to plan and implement a high availability solution
  • Experience with Transact-SQL
  • Familiarity with SQL Server 2012 components and tools
  • Familiarity with objects in a SQL Server database
  • Familiarity with enterprise Windows network and security architecture
  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.