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 10.1 Fundamentals certification exam 610 prep: Part 5: Working with tables, views, and indexes

Rob Strong (rstrong@us.ibm.com), IT Architect, Certified: Information Architecture, IBM Australia

Rob Strong provides technical consultation to IBM Business Partners on Information Management products. He has more than twenty years of experience with DB2 databases on multiple platforms, from conception through implementation and support. Much of this experience was acquired creating high performance, high availability solutions for IBM's own manufacturing lines. He is a Certified IT Architect. He is an expert in data systems architecture, data modeling, data access, and in application development and maintenance processes.

Hana Curtis (hcurtis@ca.ibm.com), IBM Certified Solutions Expert, IBM

Hana Curtis is a member of the DB2 Continuing Engineering team at the IBM Toronto Software Laboratory focusing on product serviceability. Previously, she held positions in DB2 Development and Quality Assurance and was a database consultant working with IBM Business Partners to enable their applications to DB2. Hana is one of the authors of the book: DB2 SQL Procedural Language for Linux, UNIX, and Windows (Prentice Hall, 2003).

Summary: This tutorial discusses IBM® DB2® 10.1 support for data types, tables, views, triggers, constraints and indexes. 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 that you can use to help prepare for the DB2 10.1 Fundamentals certification exam 610.

View more content in this series

Date: 25 Oct 2012
Level: Introductory
PDF: A4 and Letter (388 KB | 29 pages)Get Adobe® Reader®

Activity: 7614 views
Comments:

Resources

Learn

See the other tutorials in this DB2 10.1 Fundamentals certification preparation series to continue your education.
Use an RSS feed to request notification for the upcoming tutorials in this series. (Find out more about RSS feeds of developerWorks content.)
Review the tutorials in the DB2 9 Fundamentals certification 730 prep series.
Visit the developerWorks Information Management zone to find more resources for DB2 developers and administrators.
Stay current with developerWorks technical events and webcasts focused on a variety of IBM products and IT industry topics.
Attend a free developerWorks Live! briefing to get up-to-speed quickly on IBM products and tools as well as IT industry trends.
Follow developerWorks on Twitter.
Watch developerWorks on-demand demos ranging from product installation and setup demos for beginners, to advanced functionality for experienced developers.

Get products and technologies

Now you can use DB2 for free. Download DB2 Express-C, a no-charge version of DB2 Express Edition for the community that offers the same core data features as DB2 Express Edition and provides a solid base to build and deploy applications.
Build your next development project with IBM trial software, available for download directly from developerWorks.
Evaluate IBM products in the way that suits you best: Download a product trial, try a product online, use a product in a cloud environment, or spend a few hours in the SOA Sandbox learning how to implement Service Oriented Architecture efficiently.

Discuss

Participate in the discussion forum.
Get involved in the My developerWorks community. Connect with other developerWorks users while exploring the developer-driven blogs, forums, groups, and wikis.