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

Course objectives

  • Design an appropriate database server infrastructure for a given business application scenario
  • Design a logical schema for a database based on application 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
  • Plan and manage indexes to optimize performance
  • Describe the key considerations for designing security for SQL Server instances and databases
  • Plan policy-based management to manage server instances, databases, and other SQL Server 2012 objects more efficiently
  • Plan SQL Server health monitoring
  • Implement SQL Server health monitoring by using SQL Server Utility
  • Identify and implement the appropriate backup strategy for a given scenario
  • Plan and manage multi-server maintenance and automation
  • Understand the benefits of using PowerShell to manage SQL Server 2012
  • Design an optimal replication strategy from a given set of business and technical requirements

Course Modules

  • 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

It is the first and largest provider of computer software and hardware training in Egypt.

We_They is fast growing training provider over 20 years of experience in the delivery of computer training.

Our organization is dedicated to provide education excellence to meet the needs of each technology, simultaneously, as customer expand designed solutions to meet his particular organization's business needs.

Also Compuek is aimed by great companies and institutions for training their human resources looking for their progress and growth, and to make HR learn this promising technology at that time. For 20 years, the center is supplying the career market by highly qualified HR members who having broad minded, acquired with high technique and capable to work on the most difficult systems by all easiness and facility.

Computek is distinguished by its remote sighted management that enjoyed advanced thinking and firmness in order to enable the trainees to get as much training as possible by easy and simple way and in fine, splendid, and very organized training halls acquired with high capability PCs that are continuously upgraded to maintain high performance.

See all Computek Training Center 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 ?