Database 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 teaches students how to implement an Analysis Services solution in an organization. The course discusses how to use the Analysis Services development and how to use the Analysis Services management.

At Course Completion:
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 in an A...

Full archival course description>>

In this course, students learn how to implement an Integration Services solution in an organization. The course discusses how to develop, deploy, and manage Integration Services packages.
At Course Completion:
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. - Impleme...

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