SQL school training courses in Cedar Rapids, IA (public, in-house or online)

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

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

Objective :
After completing this course, students will be able to: - Install and configure SQL Server 2008. - Manage database files. - Backup and restore databases. - Manage security. - Transfer data into and out of SQL Server. - Automate admini...

Full archival course description>>

This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008.

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

Full archival course description>>