HPES Singapore - Course information

HG798S, 6231+6232 - Learning to Implement and Maintain a SQL Server 2008 R2 Database Server Boot Camp (MOC6231/MOC6232)

HPES Singapore


»	Curriculum paths
»	Course search
»	Late availabilities
»	Registration for course



»	Consulting solutions
»	Courses & Certifications supported by CITREP Expanded
»	HP Care Pack
»	Cloud security alliance selects HP for new master training partner program



»	ITRC/online courses



»	News & Events
»	Offers & promotions



»	Terms & conditions
»	Training locations
»	Select a country



»	Contact HP education

Course information

code:	title:	price:	duration:
HG798S [MOC 6231+6232]	Learning to Implement and Maintain a SQL Server 2008 R2 Database Server Boot Camp (MOC6231/MOC6232)	SGD$ 3000	5 days

» view schedule		» view curriculum

Special offers

This SQL 2008 course is a boot camp offering with self study expected during after class hours. Some days, the labs will not be finished during classroom hours. This course combines 10 days of content from Microsoft’s 5-day Implementing a Microsoft SQL Server 2008 Database (HG793/MOC 6232) and 5-day Maintaining a Microsoft SQL Server 2008 Database (HG792/ MOC 6231) classes. Students will receive the full contents of both student workbooks.

	Overview

	This 5-day instructor-led, boot camp-style course includes the content of the Implementing a Microsoft SQL Server 2008 Database (HG793S / MOC 6232) and Maintaining a Microsoft SQL Server 2008 Database (HG792S / MOC 6231) courses. This course provides students with the knowledge and skills to implement and maintain Microsoft SQL Server 2008 R2 database systems. The course focuses on teaching individuals how to use the SQL Server 2008 R2 main product features and tools related to implementing and maintaining SQL Server 2008 R2 features and databases. All modules from both base courses will be included, with certain modules slated for student self-study (refer to course outline).

Audience

•	This boot camp is intended for IT Professionals wanting to become skilled on SQL Server 2008 R2 product features and technologies for implementing and maintaining a database.

•	Database Administrators responsible for installing, configuring, and maintaining SQL Server 2008 databases

•	Database Developers responsible for developing applications based on SQL server 2008 databases

•	Business Intelligence Developers responsible for architecting and developing Business Intelligence solutions based on SQL Server 2008

Prerequisites

Before attending this course, students must have:

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

Key topics

After completing this course, students will be able to:

•	Create data types and tables

•	Plan, create, and optimize indexes

•	Implement functions

•	Use Service Broker to build a messaging-based solution

•	Implement a Backup and Restore Strategy

•	Monitor and track SQL Server related activity

•	Understand the methods available to transfer data

•	Create databases and database files

•	Use XML related features in Microsoft SQL Server 2008

•	Implement stored procedures

•	Implement managed code in the database

•	Install and configure a SQL Server 2008 system

•	Implement a Security Strategy

•	Automate administrative tasks

•	Understand High Availability options and implement in a SQL Server environment

Next steps

•	Writing Queries Using Microsoft SQL Server 2008 Transact-SQL (MOC 2778) HG794S

Course schedule:

There is currently no schedule information available for this course.

Please contact hp education services on 65 6824 3770 or click here if you would like us to contact you with the next availability.

Printable version


Privacy statement	Using this site means you accept its terms

© 2013 Hewlett-Packard Development Company, L.P.