Microsoft Training

Service Suites

	Services Home Page
	Infrastructure Consulting Services
	Deployment Services
	Managed Services
	Dell ProSupport

Microsoft Training Solutions

For those who rely on Microsoft^® platforms to run their IT infrastructure, Dell offers training to help increase skills and capabilities of IT staff in deploying and managing Microsoft enterprise environments. Talk to a training consultant to find out about additional training not listed below.

Technical (IT Pro/Dev) & Information Worker Online Training Libraries

Microsoft Office, Windows^® 7, & Windows Vista^TM

Windows^® Server

Hyper-V^TM

Exchange^® Server

Office Communications Server

SQL^® Server

SharePoint^®

Systems Center (SMS)

Software Assurance Vouchers

Microsoft^® SQL^® Server training provides students with the knowledge and skills required to install, configure, program, administer, and troubleshoot a client-server database management system.

SQL Server 2008

MS6158: Updating Your Skills from SQL Server 2005 to SQL Server 2008
This three-day instructor-led course provides students with the knowledge and skills to upgrade their SQL Server 2005 skills to SQL Server 2008. It covers the following topics: Describe the new features of SQL Server 2008; Manage SQL Server 2008; Optimize SQL Server 2008; Secure a SQL Server 2008 Database; Develop databases with SQL Server 2008; Create and maintain highly available SQL Server 2008 databases; Create and use a SQL Server 2008 data warehouse; Use SQL Server 2008 Reporting Services; Use SQL Server 2008 Analysis Services. Audience: experienced SQL Server 2005 developers and database administrators.


	Instructor-led	$11,715 (Onsite - up to 10 students)	SKU 994-6958

MS6231: Maintaining a Microsoft SQL Server 2008 Database
This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 database. It covers the following topics: Install and configure SQL Server 2008; Manage database files; Backup and restore databases; Manage security; Transfer data into and out of SQL Server; Automate administrative tasks; Replicate data between SQL Server instances; Maintain high availability; Monitor SQL Server. Prerequisites: Basic knowledge of the Microsoft Windows operating system and its core functionality; Working knowledge of Transact-SQL; Working knowledge of relational databases; Some experience with database design. Audience: IT Professionals who administer and maintain SQL Server databases.


	Instructor-led	$18,125 (Onsite - up to 10 students)	SKU 994-7077

MS6232: Implementing a Microsoft SQL Server 2008 Database
This five-day instructor-led course provides students with the knowledge and skills to implement a Microsoft SQL Server 2008 database. It covers the following topics: Create databases, database files, data types, and tables; Use XML-related features in Microsoft SQL Server 2008; Plan, create, and optimize indexes; Implement data integrity in Microsoft SQL Server 2008 databases by using constraints and by using triggers; Implement views, stored procedures, and functions; Implement managed code in the database; Manage transactions and locks; Use Service Broker to build a messaging-based solution. Prerequisites: Basic knowledge of the Microsoft Windows operating system and its core functionality; Working knowledge of Transact-SQL; Working knowledge of relational databases; Some experience with database design. Audience: IT Professionals who administer and maintain SQL Server databases.


	Instructor-led	$18,125 (Onsite - up to 10 students)	SKU 994-7077

MS6235: Implementing and Maintaining Microsoft SQL Server 2008 Integration Services
This three-day instructor-led course teaches students how to implement an Integration Services solution in an organization. The course discusses how to develop, deploy, and manage Integration Services packages. Prerequisites: Exposure to enterprise data import and export scenarios; Experience navigating the Microsoft Windows Server environment; Experience with Microsoft SQL Server, including: SQL Server Agent, SQL Server query language (SELECT, UPDATE, INSERT, and DELETE), SQL Server System tables, SQL Server accounts (users and permissions). Audience: IT Professionals and developers who need to implement data transfer or extract, transform, and load (ETL) solutions by using Microsoft SQL Server 2008 Integration Services.


	Instructor-led	$11,715 (Onsite - up to 10 students)	SKU 994-6958

MS6236: Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services
This three-day instructor-led course teaches students how to implement a Reporting Services solution in an organization. The course discusses how to use the Reporting Services development tools to create reports, and how to use the Reporting Services management and administrative tools to manage a Reporting Services solution. This course is intended for IT Professionals and developers who need to implement reporting solutions by using Microsoft SQL Server 2008 Reporting Services.


	Instructor-led	$11,715 (Onsite - up to 10 students)	SKU 994-6958

SQL Server 2005

MS2780: Maintaining a Microsoft SQL Server 2005 Database
This five-day instructor-led course provides students with product knowledge and skills needed to maintain a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to maintaining a database.


	Instructor-led	$18,125 (Onsite - up to 10 students)	SKU 994-7077

MS2784: Tuning and Optimizing Queries using Microsoft SQL Server 2005
This three-day instructor-led workshop provides database developers working in enterprise environments using Microsoft SQL Server 2005 the knowledge and skills to evaluate and improve queries and query response times.


	Instructor-led	$11,715 (Onsite - up to 10 students)	SKU 994-6958

MS2788: Designing High Availability Database Solutions Using Microsoft SQL Server 2005
This three-day instructor-led course provides students with the knowledge and skills to design high availability database solutions using Microsoft SQL Server 2005. The course focuses on teaching experienced database administrators working in enterprise environments to design database solutions that meet the availability needs of their organization.


	Instructor-led	$11,715 (Onsite - up to 10 students)	SKU 994-6958

MS2790: Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005
The purpose of this two-day workshop is to teach database administrators working in enterprise environments how to determine and troubleshoot performance issues using Microsoft SQL Server 2005. The primary focus of this workshop is to teach the overall process of troubleshooting. It includes establishing monitoring standards and baselines, determining performance thresholds, and focusing the investigation on specific issues.


	Instructor-led	$8,510 (Onsite - up to 10 students)	SKU 994-6949

MS2796: Designing an Analysis Solution Architecture Using Microsoft SQL Server 2005 Analysis Services
The purpose of this three day course is to teach business intelligence (BI) professionals working in enterprise environments how to design a multidimensional solution architecture that supports their BI solution. Students will go through the entire process-from capturing business and technical requirements, to deploying a multidimensional solution, to production.


	Instructor-led	$11,715 (Onsite - up to 10 students)	SKU 994-6958

MS2797: Designing a Reporting Solution Architecture Using Microsoft SQL Server 2005 Reporting Services
The purpose of this 2 day course is to teach Business Intelligence (BI) professionals working in enterprise environments to design a reporting solution architecture that supports their BI solution. Students will go through the entire process-from identifying report data to promoting the reporting solution to production. Students will scale a reporting solution.


	Instructor-led	$8,510 (Onsite - up to 10 students)	SKU 994-6949

For more information:

Contact your dedicated Sales Representative, or call 1-800-WWW-DELL.
Email us at: US_Training@Dell.com.

Related Training

Microsoft^® Technical Online Training Library with Live Tutor
This extensive library is comprised of IT Professional, Developer, Security, and Help Desk online courses plus GMS Live Tutor. GMS Live Tutor online chat provides expert answers on demand for success with technology - right from the start. The online courses provide a rich multimedia experience. Official Microsoft Learning hands-on labs are developed by industry-leading instructional designers who provide a safe, networked environment where learners can practice what they have learned without having to set up new software or change system settings. The online training library plus Live Tutor are available 24x7 for one year from invoice date.