The Structured Query Language (SQL) server is a database solution that allows applications on the client side to request information. The information stored in the SQL server database is extracted using a query process and the entire record is sent. The courses focus on teaching individuals how to use SQL Server product features, tools, installation, as well as implementing a database.
MOC 2778: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL
This three-day instructor-led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008.
Available dates and detailed description
MOC 2779: Implementing a Microsoft SQL Server 2005 Database
This five-day instructor-led course provides students with the knowledge and skills to implement a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to implementing a database.
Available dates and detailed description
MOC 2780: Maintaining a Microsoft SQL Server 2005 Database
This five-day instructor-led course provides students with the knowledge and skills 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.
Available dates and detailed description
MOC 2793: Implementing and Maintaining Microsoft SQL Server 2005 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. As well as how to use the Reporting Services management and administrative tools to manage a Reporting Services solution.
Available dates and detailed description
MOC 6231: 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. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to maintaining a database.
Available dates and detailed description
MOC 6232: 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. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to implementing a database.
Available dates and detailed description
MOC 6234: Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services
This three-day instructor-led course teaches students how to implement an Analysis Services solution in an organization. The course discusses how to use the Analysis Services development tools to create an Analysis Services database and an OLAP cube, and how to use the Analysis Services management and administrative tools to manage an Analysis Services solution.
Available dates and detailed description
MOC 6235: Implementing and Maintaining Microsoft SQL Server 2008 Integration Services (SSIS)
This three-day instructor-led course teaches students how to implement an Integration Services solution in an organization. The course also discusses how to develop, deploy, and manage Integration Services packages.
Available dates and detailed description
MOC 6236: 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 also 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.
Available dates and detailed description
MOC 6317: Upgrading Your SQL Server 2000 Database Admin (DBA) Skills to SQL Server 2008 DBA Skills
This three-day instructor-led course provides students with the knowledge and skills to upgrade their SQL Server 2000 database administration (DBA) skills to SQL Server 2008 DBA skills. Please note that there is no certification exam related to this course.
Available dates and detailed description