MCTS Accelerated: SQL Server 2008 Implementation and Maintenance

5 Day Course
Hands On
Code QAMCTSSQIM

Book Now - 1 Delivery Method Available:

Scheduled Online Onsite

This Accelerated certification programmes provide you with everything you need to gain certification in a shortest time. Including:

  • Course based on Microsoft Official Curriculum
  • All events delivered by QA’s expert MCT team
  • Extended delivery days – normally 8:30am – 6:00pm
  • Practice tests taken with full support from your instructor
  • Exam 70-432 TS: Microsoft SQL Server 2008, Implementation and Maintenance exam taken on the final day of your course

Course Topics (17 topics)

  • Installing and Configuring SQL Server
  • Managing Databases and Files
  • Disaster Recovery
  • Managing Security
  • Transferring Data
  • Automating Administrative Tasks
  • Implementing Replication
  • Maintaining High Availability
  • Monitoring SQL Server
  • Troubleshooting and Performance Tuning
  • Creating Databases, Database Files, Data Types and Tables
  • Implementing Data Integrity by Using Constraints and Triggers
  • Using XML
  • Implementing Views, Stored Procedures and Functions
  • Implementing Managed Code in the Database
  • Managing Transactions and Locks
  • Using Service Broker

* Basic knowledge of the Microsoft Windows operating system and its core functionality. (Use windows explorer / internet explorer (i.e. things like find web page , create a folder); Login (CTRL+ALT+DELETE); Start a service using services add-in. (administration tools); Use a mouse, start menu etc.) * Working knowledge of Transact-SQL. * Working knowledge of relational databases. * Some experience with database design.

Additional Learning

The courses below may help you meet the knowledge level required to take this course. If you are unsure please ask a training advisor

  • SQL Language

    The SQL Language training course will teach the student how to read and write good SQL for querying, updating and maintaining SQL databases

    course code DBSQLLG-2 11 Classroom dates 1 Online date 6 locations
Ask a Question

or call:408-759-5074

Course PDF

Print

Share this Course

+1
Share

Recommend this Course