Database school training courses in Des Moines, IA (public, in-house or online)

This course provides students with the knowledge and skills to access and modify data by using ADO.NET 3.5.

Objective :
After completing this course, students will be able to: - Describe the purpose and structure of ADO.NET 3.5. - Explain the role of data providers in ADO.NET 3.5. - List the technologies and techniques available for managing data with ADO.NET 3.5. - Insert, update, and delete data by using ADO.NET Command objects. - Implement transactions to control data integrity an...

Full archival course description>>

This course teaches students how to implement a Reporting Services solution in an organization. The course discusses how to use the development tools to create reports, and how to use the Reporting Services management and administrative tools.

Objective :
After completing this course, students will be able to: - Describe SQL Server Reporting Services and its components. - Create a Reporting Services report. - Enhance a Reporting Services report. - Create and manipulate data sets. - U...

Full archival course description>>

This 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.

Objective :
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. - Implement log...

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 tools to create an Analysis Services database and an OLAP cube.

Objective :
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 ...

Full archival course description>>

This 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.

Objective :
After completing this course, students will be able to: - Create databases and database files. - Create data types and tables. - Use XML-related features in Microsoft SQL Server 2008. - Plan, create, and optimize indexes. - Implemen...

Full archival course description>>