Cours: DB2 9 pour UNIX Administration des bases

• Overview of DB2 on Linux, UNIX and Windows
• Command Line Processor (CLP) and GUI usage
• The DB2 environment
• Creating databases and data placement
• Creating database objects
• Moving data
• Backup and recovery
• Locking and concurrency
• Problem determination
• Security

Voir ce cours dans d'autres pays

Début

System administrators, database administrators, and technical personnel involved in planning, implementing, and maintaining DB2 databases.

Début

You should be able to:

• Use basic OS functions such as utilities, file permissions, hierarchical file system, commands, and editor
• State the functions of the Structured Query Language (SQL), and be able to construct DDL, DML, and authorization statements
• Discuss basic relational database concepts and objects such as tables, indexes, views, and joins

These skills can be developed by taking:

• OS Training:
  • AIX 5L Basics
  • Linux Basics and Administration
  • Windows Systems Administration
  • Or by having equivalent HP-UX or Solaris administration experience

• DB2 SQL Workshop
• DB2 Fundamentals

Début

• List and describe the components of DB2
• Manage System Managed Storage (SMS), Database Managed Storage (DMS), and Automatic Storage databases and apply data placement principles
• Administer a DB2 database system using commands and GUI tools
• Implement a given logical database design using DB2 to support integrity and concurrency requirements
• Use autonomic features of DB2
• Define a DB2 recovery strategy and perform the tasks necessary to support the strategy
• Implement DB2 security

Début

Please refer to Course Overview for description information.

Début