Database school training courses in Boise, ID (public, in-house or online)

This course focuses on applications of computer spreadsheets and data bases in financial decision making. The standard software products utilized in financial analysis are introduced, with emphasis placed on using available software to solve problems that frequently arise in finance. Applications include the development of loan amortization schedules, financial statement analysis, capital budgeting, and the valuation of financial securities.

Students Will Learn:Reporting and Analysis
Data Mining
XML Integration
Triggers, Functions, and Stored Procedures
.NET integration
Aggregates
Database Engine Management
Development Studio
Full-text Search
CLR

Description: This class consists of five days of training that focuses on the new features available in SQL Server 2005. You will learn how to install SQL Server 2005; use the SQL Server 2005 client tools to administer databases and create databas...

Full archival course description>>

Students Will Learn:Building a Logical Data Model
Entity-Relationship Diagrams
Data Normalization Forms
SQL Statement Syntax
Manipulating Query Results
Designing for Performance
Table Indexing

Description: This relational database design class develops relational database design skills and techniques. Practical methodologies such as E-R diagrams and normalization forms are emphasized. Attention is placed on designing for data integrity and efficiency at the same t...

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