Database Admin school training courses in Denver, CO (public, in-house or online)

This is an intermediate course for database administrators, application developers, and consultants who plan, implement, or maintain DB2 UDB partitioned databases. This course is appropriate for students requiring knowledge of DB2 UDB Enterprise Server Edition (ESE) in a Data Partitioning Feature (DPF) environment.


Skills Taught

--------------------------------------------------------------------------------

Describe the steps to install and customize DB2 UDB in a pa...

Full archival course description>>

Learn how to perform database administration tasks such as creating DB2 instances, creating and populating databases, and using logical design to support concurrency and recovery requirements with DB2 9 for Linux, UNIX, and Windows. New features, such as range partitioning, data row compression, and pureXML (native XML storage) will be introduced. Use a Linux operating system during hands-on labs.

This is an intermediate course for system administrators, database administrators and other...

Full archival course description>>

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

Install and Upgrade MySQL 5.0 for the most common operating systems

Utilize the MySQL Administrator Graphical User Interface (GUI) to manage a MySQL server

Use the INFORMATION_SCHEMA database to access metadata

Perform the MySQL start and shutdown operations

Configure MySQL server options at runtime

Evaluate data types and character sets for performance issues

Understand data locking concepts and the different levels of locking in MySQL

...

Full archival course description>>

Select the Informix data types appropriate for storing your data
Create and maintain databases, tables, and indexes
Estimate size and extent requirements for tables and indexes
Create index strategies to improve performance
Create and maintain table and index partitioning (fragmentation)
Implement referential and entity integrity
Manage database and table modes
Manage violations logging
Describe how the optimizer builds an optimal query plan
Use the SET EXPLAI...

Full archival course description>>