DB2 10.1 Fundamentals certification exam 610 prep series

If you are knowledgeable about the fundamental concepts of DB2® 10.1, you may benefit from becoming an IBM Certified Database Associate.

In this series

This series of tutorials is designed to help you prepare for the DB2 10.1 Fundamentals certification exam (Exam 610) to attain the certification IBM Certified Database Associate - DB2 10.1 Fundamentals.

This series provides an introduction to SQL (Structured Query Language) and covers how DB2 10.1 is packaged and installed, how to create databases and database objects, and the basics of database security and transaction isolation.

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 610, 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 in-depth DB2 database administration concepts and capabilities, see the DB2 10.1 DBA for Linux, UNIX, and Windows certification exam 610 prep series.

The tutorials available for this series are:

  • + ExpandDB2 10.1 fundamentals certification exam 610 prep, Part 1: Planning

    Online tutorial¦PDF

    This tutorial introduces you to the basics of the DB2 10.1 product editions, capabilities and tools, along with underlying concepts that describe different types of data applications such as OLTP, data warehousing / OLAP, non-relational concepts and more. It briefly introduces you to many of the concepts covered by other tutorials in this series. The material in this tutorial covers the objectives in Section 1 of exam 610.

  • + ExpandDB2 10.1 fundamentals certification exam 610 prep, Part 2: DB2 security

    Online tutorial¦PDF

    This tutorial introduces you to DB2 security. Learn about DB2 authentication, authorization, privileges, row and column access control (RCAC), roles, and trusted Contexts. The material in this tutorial covers the objectives in Section 2 of exam 610.

  • + ExpandDB2 10.1 fundamentals certification exam 610 prep, Part 3: Working with databases and database objects

    Online tutorial¦PDF

    This tutorial shows you the basic steps and requirements to create and connect to a database in DB2 10.1. Also, it introduces you to the database objects as well as how to create them and manipulate them. The material in this tutorial covers the objectives in Section 3 of exam 610.

  • + ExpandDB2 10.1 fundamentals certification exam 610 prep, Part 4: Working with DB2 Data using SQL

    Online tutorial¦PDF

    This tutorial shows you how to use SQL statements to manipulate the data in tables, to perform transactions, to create stored procedures and user-defined functions, and to use temporal tables. The material in this tutorial covers the objectives in Section 4 of exam 610.

  • + ExpandDB2 10.1 fundamentals certification exam 610 prep, Part 5: Working with tables, views, and indexes

    Online tutorial¦PDF

    This tutorial discusses IBM DB2 10.1 support for data types, tables, views, triggers, constraints and indexes. It explains the capabilities of these objects, how to create and manipulate them by using Structured Query Language (SQL), and how they can be used in an application. The material in this tutorial covers the objectives in Section 5 of exam 610.

  • + ExpandDB2 10.1 fundamentals certification exam 610 prep, Part 6: Data concurrency

    Online tutorial¦PDF

    This tutorial introduces you to the concept of data consistency and to the mechanisms that maintain data consistency in both single-user and multi-user database environments. The material in this tutorial covers the objectives in Section 6 of exam 610.

Summary

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