Course Name : DB2 UDB for SQL Server Administrators
L1252V4 Instructor Led 3 days

Course Description:

This course provides cross-training as a DB2 UDB administrator and DBA for students with prior experience as either an SQL Server system administrator or DBA. The course trains the student to use DB2 UDB version 7.2 or 8.1 and assumes equivalent Microsoft SQL Server experience with version 7.0 or 2000. During the course the student will build and run a DBS UDB database using data made available in SQL Server unload format. For copyright reasons we cannot use an SQL Server-designed database similar to that used in SQL Server training—and thus the database used will be the simple, well-documented database previously used to teach IBM Informix classes.

Your New Skills:

· Understand SQL Server and DB2 UDB terminology differences

· Create a DB2 UDB instance

· Create a database in DB2 UDB with data migrated from SQL Server databases

· Migrate SQL Server data to a DB2 UDB database

· Understand SQL Server and DB2 UDB indexing differences

· Compare SQL Server and DB2 UDB constraint methods

· Perform DB2 UDB backup and recovery tasks

· Explore DB2 UDB performance tuning methods

Who Should Attend

Application developers, database and systems administrators, and technical support personnel.

Prerequisites:

· Understanding and use of relational database elements

· Understanding and use of SQL statements

· SQL Server System Administration or DBA knowledge

· UNIX/Linux systems knowledge

· Microsoft Windows knowledge