Skip to main content

By clicking Submit, you agree to the developerWorks terms of use.

The first time you sign into developerWorks, a profile is created for you. Select information in your developerWorks profile is displayed to the public, but you may edit the information at any time. Your first name, last name (unless you choose to hide them), and display name will accompany the content that you post.

All information submitted is secure.

  • Close [x]

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.

By clicking Submit, you agree to the developerWorks terms of use.

All information submitted is secure.

  • Close [x]

Select a language:

  • Close [x]
  • Close [x]

DB2 fundamentals for professionals: Certification preparation

Date:  07 Oct 2011 (Published 06 Jun 2011) |Level: Introductory ||

Sign in to save your progress (Learn more)

Saving your progress (Learn more)

1. Get comfortable with the fundamentals of DB2

Dive into DB2, starting with the basics of DB2 9 products, tools, and concepts. Then learn the different security issues relating to DB2, including authentication, authorization, and privileges.

Read: DB2 9 Fundamentals exam 730, prep, Part 1: DB2 planningItem marked not complete - Click to mark complete

Read: DB2 9 Fundamentals exam 730 prep, Part 2: SecurityItem marked not complete - Click to mark complete

2. Work with DB2 data

Prepare for database creation and cataloging, SQL procedures and how to invoke user-defined functions from the command line, and how to manipulate various DB2 objects using SQL and use them in applications.

Read: DB2 9 Fundamentals exam 730 prep, Part 3: Accessing DB2 data Item marked not complete - Click to mark complete

Read: DB2 Fundamentals exam 730 prep, Part 4: Working with DB2 dataItem marked not complete - Click to mark complete

Read: DB2 Fundamentals exam 730 prep, Part 5: Working with DB2 objectsItem marked not complete - Click to mark complete

3. Lay your foundation in data concurrency

Compare the various mechanisms that DB2 9 uses to maintain database consistency in both single and multi-user environments.

Read: DB2 Fundamentals exam 730 prep, Part 6: Data concurrencyItem marked not complete - Click to mark complete

4. Find out how Xquery works

Delve into DB2 to understand how you can use XQuery to store, manage, and query XML data.

Read: DB2 Fundamentals exam 730 prep, Part 7: Introducing XqueryItem marked not complete - Click to mark complete




Rate this content



Give us feedback

Submission failed. Please try again.

Please complete one of the following questions before submitting.

1. Are you finished with this knowledge path?

       

2. How much did you learn?

           

3. Tell us more

  • What did you like/dislike?
  • What can we do better?

2500 characters left

Disabled Submit button

Close [x]

Add to My dW interests

Submission failed. Please try again.

Topics:

  • About the product
  • Access
  • DB2
  • Data access
  • Databases and data management
  • Security
  • XQuery (XML Query Language)

My profile

Close [x]

developerWorks: Sign in


Need an IBM ID?
Forgot your IBM ID?


Forgot your password?
Change your password

By clicking Submit, you agree to the developerWorks terms of use.

 

The first time you sign into developerWorks, a profile is created for you. Select information in your developerWorks profile is displayed to the public, but you may edit the information at any time. Your first name, last name (unless you choose to hide them), and display name will accompany the content that you post.

All information submitted is secure.

Close [x]

Choose your display name

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.

(Must be between 3 – 31 characters.)

By clicking Submit, you agree to the developerWorks terms of use.

 

All information submitted is secure.

Close [x]

Save your progress Green checked checkmark

When you sign in, we will save this item to your developerWorks community home page and track your progress so you know what you've completed and where to resume when you return.

For a list of your saved items, see your My Home > My saved items page.

Close [x]

Thank you for your feedback. We appreciate your sharing your opinion with us.

Close [x]

Do you want to save your progress?

, Sign in to save your progress

Close [x]

Save your progress

Sorry. Our server is not available, and we cannot display your saved progress at this time.

Your progress will be displayed when the server is available again. Any previous progress is retained, and additional progress is being tracked.

If your most recent progress is not displayed within 24 hours, you can click the checkmark to indicate completion.

Close [x]

Help: Update or add to My dW interests

What's this?

This little timesaver lets you update your developerWorks profile. The general subjects of this content will be added to the interests section of your profile, along with the associated technical topics. You only need to be signed in to developerWorks.

And what's the point of adding your interests to your profile? That's how you find other users with the same interests as yours, and see what they're reading and contributing to the community. Your interests also help us recommend relevant developerWorks content to you.

View your developerWorks profile

Return from help

About this knowledge path

This Knowledge Path will help you prepare to take the DB2 9 Fundamentals 730 certification exam. It guides you through a series of seven developerWorks tutorials that cover material corresponding to a section of the certification exam. Even if you're not planning to seek certification right away, this set of tutorials is a great place to start building your DB2 skills and learn what's new in DB2 9.

Activities in this path

  1. Get comfortable with the fundamentals of DB2
  2. Work with DB2 data
  3. Lay your foundation in data concurrency
  4. Find out how Xquery works

Related resources

Share this page:

  • Close [x]

Follow developerWorks:

  • Close [x]
static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=756140
publish-date=10072011