db2-cert7303-a4 - Accessing DB2 data

db2-cert7303-a4 - Accessing DB2 data - DB2 9 Fundamentals...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: DB2 9 Fundamentals exam 730 prep, Part 3: Accessing DB2 data Skill Level: Introductory George Baklarz ( baklarz@yahoo.com ) DB2 Technical Pre-Sales Support IBM 25 Jul 2006 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, we'll examine the different tools to create, access, and manipulate DB2 objects. This is the third in a series of seven tutorials to help you prepare for the DB2 9 for Linux, UNIX, and Windows Fundamentals exam 730. Section 1. Before you start About this series Thinking about seeking certification on DB2 fundamentals (Exam 730)? If so, you've landed in the right spot. This series of seven DB2 certification preparation tutorials covers all the basics -- the topics you'll need to understand before you read the first exam question. Even if you're not planning to seek certification right away, this set of tutorials is a great place to start getting to learn what's new in DB2 9. About this tutorial This tutorial is the third in a series of seven tutorials that can help you prepare for the DB2 9 Fundamentals Certification (Exam 730). The material in this tutorial primarily covers the objectives in Section 3 of the test, which is entitled "Accessing DB2 Data." DB2 installation is not covered in this tutorial. If you haven't already done so, we strongly recommend that you download and install a copy of IBM DB2 9 , Express Accessing DB2 data Copyright IBM Corporation 1994, 2006. All rights reserved. Page 1 of 50 Community Edition. Installing DB2 will help you understand many of the concepts that are tested on the DB2 9 Fundamentals Certification exam. After you've installed the DB2 product, you will want to get a database up and running as quickly as possible. This tutorial introduces you to the objects that make up a DB2 database, and to the factors that affect how the database is created. After a brief introduction to DB2 objects, we'll examine the different tools to create, access, and manipulate DB2 objects. Objectives After completing this tutorial, you should be able to: Create a DB2 database on your own Catalog it for use by other users Examine and manipulate the objects within that database. Prerequisites The process of installing DB2 is not covered in this tutorial. If you haven't already done so, we strongly recommend that you download and install a copy of DB2 Express - C . Installing DB2 will help you understand many of the concepts that are tested on the DB2 9 Family Fundamentals Certification exam. The installation process is documented in the Quick Beginnings books, which can be found at the DB2 Technical Support Web site under the Technical Information heading....
View Full Document

This note was uploaded on 02/11/2011 for the course IT 232 taught by Professor Drehr during the Spring '11 term at NJIT.

Page1 / 50

db2-cert7303-a4 - Accessing DB2 data - DB2 9 Fundamentals...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online