SQL Server 2008 school training courses in Davenport, IA (public, in-house or online)

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 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.
At Course Completion:
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 ad...

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.


Outline:
Lesson 1: Creating Databases and Database Files
Creating Databases
Creating Filegroups
Creating Schemas
Creating Database Snapshots

Lesson 2: Creating Data Types and Tables
Creating Data Types
Creat...

Full archival course description>>

Exam 70-448

6234 Implementing and Maintaining Microsoft® SQL Server 2008 Analysis Services Training;
6235 Implementing and Maintaining Microsoft® SQL Server 2008 Integration Services Training

6236 Implementing and Maintaining Microsoft® SQL Server 2008 Reporting Services Training

6232: Implementing a Microsoft SQL Server 2008 Database

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