MCTS school training courses in Davenport, IA (public, in-house or online)

This course will teach Microsoft Windows 2000 operating system administrators how to take advantage of Windows Script Host (WSH) by using the Microsoft Visual Basic Scripting Edition (VBScript) language.
At Course Completion:
After completing this course, students will be able to: - Run and work with scripts, including writing, debugging, and troubleshooting. - Write scripts that access objects and use an object browser. - Use Visual Basic, Scripting Edition to create effective and efficie...

Full archival course description>>

This course provides students with the knowledge and skills to configure and manage an Exchange Server 2010 messaging environment, as well as provide guidelines, best practices, & considerations that will help you optimize your Exchange Server deployment.
At Course Completion:
After completing this course, students will be able to: - Install and deploy Exchange Server 2010. - Configure Mailbox servers and Mailbox server components. - Manage recipient objects. - Configure the Client Access ...

Full archival course description>>

This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008.
At Course Completion:
After completing this course, students will be able to: - Describe the uses of and ways to execute the Transact-SQL language. - Use querying tool. - Write SELECT queries to retrieve data. - Group and summarize data by using Transact-SQL. - Join data from multiple tables. - Write queries that retrieve and modify data by using subqueries. -...

Full archival course description>>

This course teaches students how to implement an Analysis Services solution in an organization. The course discusses how to use the Analysis Services development and how to use the Analysis Services management.

At Course Completion:
After completing this course, students will be able to: - Describe how SQL Server Analysis Services can be used to implement analytical solutions. - Create multidimensional analysis solutions with SQL Server Analysis Services. - Implement dimensions in an A...

Full archival course description>>

In this course, students learn how to implement an Integration Services solution in an organization. The course discusses how to develop, deploy, and manage Integration Services packages.
At Course Completion:
After completing this course, students will be able to: - Describe SQL Server Integration Services and its tools. - Create an Integration Services package. - Implement control flow in an Integration Services package. - Implement data flow in an Integration Services package. - Impleme...

Full archival course description>>