Mississauga College of Technology

Tel: 905.232.8628 Fax: 905.232.1672

Address: 240-33 City Centre Dr. Mississauga, ON. L5B 2N5

E-mail: info@mississaugacollege.com

Microsoft SQL Server 2008   <MSQL411>
[Implementation and Maintenance: Exam 70-432]

Scope

Covers complete Implementation, configuration, backing up and restoring the database and maintaining with different scenarios.

Objective

To provide instructor lead and hands-on experience while implementing and managing SQL Server 2008

Topics

  • - Installing and Configuring SQL Server 2008 Understanding system requirements, configuration and Installation
  • - Database Configuration and Maintenance Working with transaction logs, files, filegroups, filestream data, Maintaining and recovering database
  • - Tables Working with objects and constraints
  • - Designing SQL Server Indexes Index architecture (B-Trees), and designing such as XML, Spatial
  • - Full Text Indexing Full text catalog, Indexes, Freetext
  • - Distributing and Partitioning Data Creating Partition schemes, Tables, and indexes, managing and review
  • - Backing up and restoring a Database Importing, exporting, and backing up with different options, and restoring
  • - Designing Policy Base Management Designing policies, target and categories, and implementation
  • - Automating SQL server Creating Jobs and Alerts
  • - Designing SQL Server Security Configuring SQL server, TCP endpoints, principals, permissions, and Auditing
  • - Monitoring Microsoft SQL Server Defining trace, specifying events, Diagnosing failures, deadlock issue, Managing and Encrypting data
  • - Optimizing Performance and Failover Clustering Database tuning, collecting Statistical data, Designing windows and server failover clusters
  • - Database Mirroring Importance and Designing and establishing Mirroring
  • - Log Shipping and Replication Initializing log and replicating transactional and Merge Replication

Achievements

With the help of practical experience the student shall be able to work confidently and independently on SQL server, and to appear for Implementation and Maintenance Server 2008 [Exam 70-432]

Pre-requisites

Windows, database, and networking knowledge

Audience

A+ certified, Network administrator, Database Administrator, Project Manager

Duration:39 hours

Fee:$880.00

Copyright © 2012 Mississauga College of Technolog All Rights Reserved
Call Today: 905-232-8628
blogger
linkedin
twitter
facebook
EmailEmail: info@mississaugacollege.com
AddressAddress: 240-33 City Centre Dr. Mississauga, ON. L5B 2N5
Developed by Jimvisual