MCTS: SQL Server 2008, Implementation and Maintenance

Select Industry/Course: Select Course CompTIA Security+ Microsoft Certified Desktop Support Technician (MCDST) Microsoft Certified Systems Administrator (MCSA) Microsoft Certified Systems Engineer (MCSE) Microsoft Certified Technology Specialist: Windows Vista, Configuration Microsoft Certified Technology Specialist: Microsoft Exchange Server 2007, Configuration Sun Certified Java Associate (SCJA) Sun Certified Java Professional (SCJP) Cisco Certified Entry Networking Technician: Interconnecting Cisco Networking Devices Part 1 (ICND1) Cisco Certified Network Associate: Interconnecting Cisco Networking Devices Part 2 (ICND2) CompTIA A+ CompTIA Network+ Microsoft Certified IT Professional: Database Developer Microsoft Exchange Server 2007, Configuration Microsoft Certified IT Professional (MCITP): Database Developer Microsoft Certified IT Professional (MCITP): Enterprise Administrator Microsoft Certified IT Professional (MCITP): Server Administrator Microsoft Certified IT Professional (MCITP): Enterprise Support Technician Microsoft Certified IT Professional (MCITP): Database Administrator Microsoft Cetified Technology Specialist (MCTS): Microsoft SQL Server 2008, Database Development Microsoft Certified Technology Specialist (MCTS): Microsoft SQL Server 2008, Implementation & Maintenance Microsoft Certified Technology Specialist (MCTS): .NET Framework 3.5 ASP .NET Applications Microsoft Certified Technology Software (MCTS): .NET Framwork 3.5 ADO.NET Applications

Target Audience

This course is intended for IT Professionals who administer and maintain SQL Server databases.

Course Overview

This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to maintaining a database.

Course Duration

35 Hours (5 Days)

Assessment

Exam 70-432 (TS: Microsoft SQL Server 2008, Implementation and Maintenance)

Course Outline

• Course Code: 6231 (Maintaining a Microsoft SQL Server 2008 Database)
• Exam Code: 70-432
  
  

  Installing and Configuring SQL Server

  • Preparing to Install SQL Server
  • Installing SQL Server
  • Configuring a SQL Server Installation
    
    

    Managing Databases and Files

  • Planning Databases
  • Creating Databases
  • Using Policy-Based Management
    
    

    Disaster Recovery

  • Planning a Backup Strategy
  • Backing Up User Databases
  • Restoring User Databases
  • Performing Online Restore Operations
    
    

    Managing Security

  • Overview of SQL Server Security
  • Protecting the Server Scope
  • Protecting the Database Scope
  • Protecting the Server Scope
  • Auditing Security
    
    

    Transferring Data

  • Overview of Data Transfer
  • Introduction to SQL Server Integration Services
    
    

    Automating Administrative Tasks

  • Automating Administrative Tasks in SQL Server
  • Using SQL Server Agent
  • Creating Maintenance Plans
  • Implementing Alerts Managing SQL Server Agent Security
    
    

    Implementing Replication

  • Overview of Replication
  • Managing Publications and Subscriptions
  • Configuring Replication in Some Common Secenarios
    
    

    Maintaining High Availability

  • Introduction to High Availability
  • Implementing Log Shipping
  • Implementing Database Mirroring
  • Implementing Server Clustering
  • Using Distributed High Availability Solutions
    
    

    Monitoring SQL Server

  • Viewing Current Activity
  • Using SQL Server Profiler
  • Monitoring with DDL Triggers
  • Using Event Notifications
    
    

    Troubleshooting SQL Server

  • Performance Tuning in SQL Server
  • Using Resource Governor
  • Using Data Collector

Pre-requisites

Before attending this course, students must have:

Basic knowledge of the Microsoft Windows operating system and its core functionality.

Working knowledge of Transact-SQL.

Working knowledge of relational databases.

Some experience with database design.

Course Location

NTUC LearningHub Pte Ltd
10 Anson Road
International Plaza #06-18
Singapore 079903

Methodology

Classroom Instructor Led Training

Certification

MCTS: SQL Server 2008, Implementation and Maintenance

Enquiry

Type of enquiry Corporate Individual

Company Name

Name *

Contact No *

Email *

Preferred Contact Email Telephone Call Morning Noon Evening

Questions & Comments

Enter characters displayed

* Mandatory fields

Our Partners