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

Product type
Level
Logo OnlineITcourses.com

Need more information? Get more details on the site of the provider.

Description

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 int…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Microsoft SQL Server, MCTS, Microsoft Windows Server 2003/2008, PL/SQL, and Microsoft ProClarity.

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
There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.