Designing Database Solutions for Microsoft SQL Server 2012

Live Online & Classroom Enterprise Training

Location: Bangalore, India | Dubai, UAE

Industry Experienced Instructor  |  Remote Labs  |  Lab Access Post Training

Need help finding the right training?

Course Details

In this course, you will learn to create plans and designs for database structure, storage, objects, and servers through hands-on labs and design tasks. You will learn to design and monitor high performance, highly available data solutions with Microsoft SQL Server 2012 along with data compression, high availability, data migration, security, and scalability.

This course incorporates material from the Official Microsoft Learning Product 20465 and covers the skills and knowledge measured by Exam 70-465: Designing Database Solutions for Microsoft SQL Server 2012 and, in conjunction with on-the-job experience, can help you prepare for the exam.

Course Prerequisites

You should have the following technical knowledge to attend this course:

  • Transact-SQL
  • SQL Server 2012 components and tools
  • Objects in a SQL Server database
  • Enterprise Windows network and security architecture
  • MCSA: SQL Server 2012 certification or the knowledge and skills from the following courses:

Course Agenda

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 Data Partitioning and 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 with Indexes
  • Managing Query Plans
  • Performance Monitoring

6. Designing Database Security

  • Security Planning
  • Plan Security
  • Contained Databases
  • Protecting Data with Encryption

7. Policy-Based Management

  • Basics of Policy-Based Management
  • Planning and Implementing Policy-Based Management

8. Monitoring Server Health

  • Basics of 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

  • Maintenance Automation
  • Managing Multiple Servers

11. Managing SQL Server with PowerShell

  • Windows PowerShell
  • Scripting with Windows PowerShell

12. Replicating Data

  • SQL Server Replication
  • Planning Replication

13. Designing for High Availability

  • High Availability in SQL Server 2012
  • AlwaysOn Availability Groups