Database school training courses in Eugene, OR (public, in-house or online)

In this course, students will create a basic report by connecting to a database and modifying its presentation.

Objective :
Upon successful completion of this course, students will be able to: - explore the Crystal Reports interface. - create a basic report and modify it. - use formulas for filtering data. - build a parameterized report. - group report data. - enhance a report. - create a report using data sourced from an Excel database. - distribute data.

At Course Completio...

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)

Objective :
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 database with re...

Full archival course description>>

6232: Implementing a Microsoft SQL Server 2008 Database

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

After completing this SQL Server 2008 R2 training course, students will be able to:
Explain SQL Server 2008 R2 architecture, resources requirements and perform pre-checks of I/O subsystems
Plan, install and configure SQL Server 2008 R2
Backup and restore databases
Import and export wizards and explain how they relate to SSIS
Use BCP and BULK INSERT to import data
Manage security
Assign, configure fixed database roles and create and assign user defined database roles
Full archival course description>>

After completing this SQL Server 2008 R2 training course, students will be able to:
Understand the product, its components, and basic configuration.
Work with the data types supported by SQL Server.
Design and implement tables and work with schemas.
Design and implement views and partitioned views.
Describe the concept of an index and determine the appropriate data type for indexes and composite index structures.
Identify the appropriate table structures and implement clus...

Full archival course description>>