DB2 10.1 DBA for Linux, UNIX, and Windows certification exam 611 prep series

If you are knowledgeable with DB2 10.1 and are capable of performing the intermediate to advanced skills required in the day-to-day administration of DB2 instances and databases, you may benefit from becoming an IBM Certified Database Administrator.

In this series

This series of tutorials is designed to help you prepare for the DB2® 10.1 DBA for Linux®, UNIX® and Windows™ (Exam 611) certification exam to attain the certification IBM Certified Database Administrator - DB2 10.1 for Linux, UNIX and Windows.

These tutorials provide a solid base for each section of the exam. However, you should use other preparation resources for the exam. For additional resources that are available to prepare for exam 611, see Resources.

You can take these tutorials online or download a PDF or zip file and go through them at your own pace.

If you are interested in learning more about DB2 database administration, begin with the DB2 10.1 Fundamentals exam 610 prep tutorials.

The tutorials available for this series are:

  • + ExpandDB2 10.1 DBA for Linux, UNIX, and Windows certification exam 611 prep, Part 1: Server management

    Online tutorial¦PDF

    Learn skills that help you to properly manage your DB2 database servers. This tutorial helps you learn the skills required to manage DB2 database servers, instances and databases. Also, you will learn about DB2 autonomic computing capabilities, how to perform database administration tasks such as job scheduling and generating diagrams of access plans with IBM data Studio. The material in this tutorial covers the objectives in Section 1 of exam 611.

  • + ExpandDB2 10.1 DBA for Linux, UNIX, and Windows certification exam 611 prep, Part 2: Physical design

    Online tutorial¦PDF

    Learn how to create DB2 databases, and about the mechanisms available for storing your tables, indexes, and data within the database. This tutorial focuses on partitioning, compression, XML, multi-temperature date, and new table features which are all important performance and application development concepts that you need to know to store and access data quickly and efficiently. The material in this tutorial covers the objectives in Section 2 of exam 611.

  • + ExpandDB2 10.1 DBA for Linux, UNIX, and Windows certification exam 611 prep, Part 3: Business rules implementation

    Online tutorial¦PDF

    Learn the skills to implement business rules in a DB2 database environment. Take the various steps required to manage some of the objects within DB2. This tutorial includes overview information for topics such as indexes, constraints, referential integrity, and views. The material in this tutorial covers the objectives in Section 3 of exam 611.

  • + ExpandDB2 10.1 DBA for Linux, UNIX, and Windows certification exam 611 prep, Part 4: Monitoring DB2 activity

    Online tutorial¦PDF

    Learn the different options for monitoring and tuning DB2 environments. This tutorial introduces you to the set of monitoring tools and problem determination tools that are available with DB2 10.1. Also, it shows you how to capture and analyze visual explain information. The material in this tutorial covers the objectives in Section 4 of exam 611.

  • + ExpandDB2 10.1 DBA for Linux, UNIX, and Windows certification exam 611 prep, Part 5: DB2 utilities

    Online tutorial¦PDF

    Find out what utilities are provided with DB2 servers for data movement and maintenance. This tutorial shows you how to extract data, populate tables, use db2 commands such as db2move and db2look, and use the DB2 Design Advisor. The material in this tutorial covers the objectives in Section 5 of exam 611.

  • + ExpandDB2 10.1 DBA for Linux, UNIX, and Windows certification exam 611 prep, Part 7: Security

    Online tutorial¦PDF

    Learn how to configure and manage security for DB2 databases. This tutorial introduces the concepts of authentication, authorities, privileges, audit facility, trusted context, RCAC, and LBAC. A basic knowledge of database concepts and operating system security is required. The material in this tutorial covers the objectives in Section 7 of exam 611.

  • + ExpandDB2 10.1 DBA for Linux, UNIX, and Windows certification exam 611 prep, Part 8: Connectivity and networking

    Online tutorial¦PDF

    Learn how to connect to DB2 databases and how use DB2 discovery and Lightweight Directory Access Protocol (LDAP). This tutorial shows how to configure communications and how to catalog databases, remote servers (nodes), and Database Connection Services (DCS) databases. Also, it introduces you to DB2 Discovery and LDAP. This tutorial prepares you for the objectives in Section 8 of exam 611.

Summary

The following list shows all the links to the online tutorials and the PDF downloads.