The first time you sign into developerWorks, a profile is created for you. Select information in your profile (name, country/region, and company) is displayed to the public and will accompany any content you post. You may update your IBM account at any time.

All information submitted is secure.

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerworks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

All information submitted is secure.

My developerWorks:

My notifications:

Sign out

Select a language:

DB2 9 Fundamentals certification 730 prep series

The Fundamentals tutorial series provides an introduction to SQL (Structured Query Language) and covers how DB2® 9 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 not rely on these tutorials as your only preparation for the exam.

In this series

After a quick registration, you can begin a tutorial. Each tutorial should take about an hour to complete. You can take the tutorials online, or download a PDF or zip file.

DB2 9 Fundamentals exam 730 prep, Part 1: Planning
This tutorial introduces the basics of the DB2 products and tools, along with the concepts of data warehousing and OLAP.
DB2 9 Fundamentals exam 730 prep, Part 2: Security
This tutorial introduces you to DB2 security. Learn about DB2 authentication, authorization, and privileges.
DB2 9 Fundamentals exam 730 prep, Part 3: Accessing DB2 data
This tutorial gives you an introduction to the objects that make up a DB2 database, and the different factors which affect how the database is created. After a brief introduction to DB2 objects, learn about the tools available to create, access, and manipulate DB2 objects.
DB2 9 Fundamentals exam 730 prep, Part 4: Working with DB2 data
This tutorial introduces you to Structured Query Language (SQL), and gives you the basics of how DB2 9 uses SQL to manipulate data in a relational database.
DB2 9 Fundamentals exam 730 prep, Part 5: Working with DB2 objects
This tutorial discusses data types, tables, views, and indexes as defined by DB2 9. 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 9 Fundamentals exam 730 prep, Part 6: Data concurrency
This tutorial introduces you to the concept of data consistency and to the various mechanisms that are used by DB2 9 to maintain database consistency in both single and multi-user environments.
DB2 9 Fundamentals exam 730 prep, Part 7: Introducing Xquery
DB2 9 features significant new support for storing, managing, and querying XML data. Learn how to query data stored in XML columns using XQuery.

Once you have the fundamentals mastered, you may be interested in learning more about DB2 database administration tasks. If so, check out the DB2 DBA exam 731 prep tutorials.