Tutorials: DB2 User Certification Preparation
This series of six tutorials is designed to help you prepare for the DB2 Fundamentals Certification (Exam 512). These tutorials provide a solid base for each section of the exam. However, you should not rely on these tutorials as your only preparation for the exam. Each tutorial includes a link to a free DB2 Universal Database Enterprise Edition download. Do these tutorials on your own time, check out the associated references listed with each tutorial, and please visit the certification Web site today for more information about the exam.
DB2 user certification prep, Part 1: DB2 tools, data warehousing and OLAP
This tutorial introduces the basics of the DB2 Tools, and the concepts of data warehousing and OLAP. The material in this tutorial primarily covers the objectives in "Section 1. Installation and Planning". Installation is not covered in this tutorial.
DB2 user certification prep, Part 2: Security and instances
This tutorial introduces you to DB2 security and instances. The material in this tutorial primarily covers the objectives in "Section 2. Security and Instances". In this tutorial, you will learn about DB2 instances, the Database Administration Server (DAS) Instance, and DB2 Security features (DB2 Authentication, Authorization and Privileges).
DB2 user certification prep, Part 3: Creating and accessing DB2 databases
This tutorial introduces you to the objects that make up a DB2 database, how the database is created, and the different tools used to create, access, and manipulate DB2 objects.
DB2 user certification prep, Part 4: SQL usage
This tutorial introduces you to Structured Query Language (SQL), and gives you a good understanding of how DB2 Universal Database uses SQL to define database objects (such as tables, views, or indexes) and to manipulate data in a relational database.
DB2 user certification prep, Part 5: Database objects
This tutorial discusses data types, tables, views and indexes as defined by DB2 Universal Database. It explains the features of these objects, how to create and manipulate them using Structured Query Language (SQL) and how they can be used in an application.
DB2 user certification prep, Part 6: Database concurrency
This tutorial introduces you to the concept of data consistency and to the various mechanisms that are used by DB2 Universal Database to maintain database consistency in both single- and multi-user environments.
After a quick (2 minutes, tops) registration, you can begin a tutorial. Each tutorial should take you about an hour to complete. You can take it online, or download a PDF or zip file of the tutorial.
These tutorials are geared toward Database Administrators (DBAs) familiar with basic database concepts.