?

Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Implementation and Maintenance

Overview

The Microsoft Certified Technology Specialist (MCTS): SQL Server 2008 credential will develop skills and knowledge to implement and maintain databases using specific instructions and specifications, including understanding how to use tools and the Transact-SQL language, and know how to explore the user interface. The course is aimed at IT database generalists or systems administrators, those working with third-party applications that are built on SQL Server 2008, and developers who build applications that use SQL Server 2008.

To help prepare for the exams, we provide you with all the required resources including the online self-paced courses, access to an Exam Coach to help plan your study and answer course related questions, access to live servers to practice your skills, and an online reference library of eBooks (including Microsoft Press and SAMS books) and how-to articles.

Click here for a free consultation

Our Quality Guarantee

Our courses are of the highest quality – In fact we partnered with Microsoft to develop them. Not only are they Microsoft authorised, Microsoft uses them in their own internal training – the ultimate seal of approval!

Who is this course aimed at?

  • Database Administrator
  • Database Developer
  • Business Intelligence Developer
  • Enterprise Developer

What’s included?

  • Online self-paced courses,
  • vLab virtual labs
  • Exam Coach and Mentoring
  • Online Reference Library
  • Discussion Forum
Study Time Approximately 40 hrs Duration 12 months
Pre-requisites none
Requirements Click here for a list of technical requirements

Required Exams

70-432: TS: Microsoft SQL Server 2008, Installation and Maintenance

Course Outline:

  • An Introduction to Transact-SQL
  • Querying and Filtering Data
  • Grouping and Summarizing Data
  • Joining Data from Multiple Tables
  • Working with Sub-queries
  • Modifying Data in Tables
  • Integrated Full Text Search and Returning XML Result Sets
  • An Introduction to Programming Objects
  • Querying Metadata
  • Installing and Configuring Microsoft SQL Server 2008
  • Creating and Managing Databases
  • Planning, Creating, and Optimizing Indexes
  • Backing Up and Restoring Databases
  • Managing Security
  • Automating Administrative Tasks
  • Monitoring and Controlling Resources
  • Implementing High Availability and Replication