MS SQL Server 2008 Implementation and Maintenance (Exam 70-432)

In this training course you will learn to implement and manage a Microsoft SQL Server 2008 database. You will also learn the query language Transact-SQL. The training course is part of the Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, implementation and maintenance.

Among the topics covered are installing SQL Server 2008, creating and managing database instances, security, database management, performance monitoring, backups and restoring, Transact-SQL and much more.

Livelab: practice in a live environment

During this training course you are given access to livelabs. In the livelabs you can exercise in a real life environment. A livelab is a computer and/or server into which you logon using your browser. All the software you need to perform practical assignments is installed here. In this way you acquire hands on experience.

Your result

You can install, configure and manage a Microsoft SQL Server 2008 database. You also have extensive knowledge of Transact-SQL and you are ready for exam 70-432.

Audience profile

DBAs, administrators, database designers, support engineers who wish to achieve the MCTS certification Microsoft SQL Server 2008, Implementation and Maintenance.

Contents of the training

The training course comprises various lessons:

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