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

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

In the course, students create and modify new databases and their various objects. They learn how to maintain data consistency and integrity; improve queries, forms, and reports; and also integrate Accessâ„?2007 with other applications. (Second Edition)

At Course Completion:
Upon successful completion of this course, students will be able to: - examine the basic database concepts and explore the Microsoft Office Access 2007 environment. - design a simple database. - build a new databa...

Full archival course description>>

6232: Implementing a Microsoft SQL Server 2008 Database

2778: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL