This course 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 maps to skills and knowledge measured by Microsoft Exam 70-465, and in conjunction with on-the-job experience, can help prepare your for the exam.


  • Module 1: Designing a Database Server Infrastructure
  • Module 2: Designing a Logical Database Schema
  • Module 3: Designing a Physical Database Implementation
  • Module 4: Designing a Database Solution for BLOB Data
  • Module 5: Tuning Database Performance
  • Module 6: Designing Database Security
  • Module 7: Using Policy-Based Management
  • Module 8: Monitoring Server Health
  • Module 9: Designing a Database Backup Solution
  • Module 10: Automating Multi-Server Maintenance
  • Module 11: Managing SQL Server with PowerShell
  • Module 12: Replicating Data
  • Module 13: Designing for High Availability

Global Knowledge is the worldwide leader in IT and business skills training. They deliver via training centers, private facilities, and the Internet, enabling their customers to choose when, where, and how they want to receive training programs and learning services.

See all Global Knowledge Egypt courses

Contact information not available.

Courses you can instantly connect with...
Querying Microsoft SQL Server New Horizons Egypt Mastering PHP & MySQL Helper Learning MCTS: SQL Server 2008, Database Development Helper Learning

Is this the right course for you?

Rate our content

Didn't find what you were looking for ?