DB2 9 Fundamentals exam 730 prep, Part 5 Working with DB2 objects

DB2 9 Fundamentals exam 730 prep, Part 5 Working with DB2 objects

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

View Full Document Right Arrow Icon
DB2 9 Fundamentals exam 730 prep, Part 5: Working with DB2 objects Skill Level: Introductory Hana Curtis ( hcurtis@ca.ibm.com ) IBM Certified Solutions Expert IBM 24 Jul 2006 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. This tutorial is the fifth in a series of seven tutorials that you can use to help prepare for DB2 9 Fundamentals Certification 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 The material in this tutorial primarily covers the objectives in Section 5 of the exam, entitled "Working with DB2 Objects." You can view these objectives at: http://www-03.ibm.com/certify/tests/obj730.shtml . Working with DB2 objects © Copyright IBM Corporation 1994, 2008. All rights reserved. Page 1 of 23
Background image of page 1

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

View Full DocumentRight Arrow Icon
Topics covered in this tutorial include: • A description of the built-in data types DB2 provides, and which are appropriate to use when defining a table. (For a different treatment of data type, see the fourth tutorial in this series ). • An introduction to advanced data types. • Tables, views, and indexes. • An explanation of the various types of constraints and their uses. Objectives After completing this tutorial, you should be able to: • Understand data types and advanced data types • Create tables, views, and indexes in a DB2 database • Understand the features and use of unique constraints, referential integrity constraints, and table check constraints • Use views to restrict access to data • Understand the features of indexes System Requirements You do not need a copy of DB2 to complete this tutorial. However, if you'd like, you can download a free trial version of IBM DB2 9 to work along with this tutorial. Section 2. Data types DB2 provides a rich and flexible assortment of data types. DB2 comes with basic data types such as INTEGER , CHAR , and DATE . It also includes facilities to create user-defined data types (UDTs) so that you can create complex, nontraditional data types suited to today's complex programming environments. Choosing which type to use in a given situation depends on the type and range of information that is stored in the column. There are four categories of built-in data types: numeric, string, datetime, and XML.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 23

DB2 9 Fundamentals exam 730 prep, Part 5 Working with DB2 objects

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