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 3: Working with databases and database objects

Gerald Kupris (gkupris@us.ibm.com), Solution Migration Specialist, IBM

Gerald A. Kupris is a DB2 migration specialist working in the IBM Information Management Technology Ecosystems team, of which he has been a member since 2010. He has worked with numerous partners and customers, providing DB2 knowledge transfer, implementation guidance, and assistance converting from competitive databases to DB2.

Summary: This tutorial shows you the basic steps and requirements to create and connect to a database in DB2® 10.1. This tutorial also introduces you to the objects that make up a DB2 database, as well as how to create and manipulate them. This tutorial is third of a series of six "DB2 10.1 fundamentals certification exam 610 prep" tutorials that will help prepare you for the DB2 10.1 fundamentals certification exam 610.

View more content in this series

Date: 18 Oct 2012
Level: Intermediate
PDF: A4 and Letter (1082 KB | 21 pages)Get Adobe® Reader®

Activity: 9082 views
Comments:

Resources

Learn

See the other tutorials in this "DB2 10.1 fundamentals certification exam 610 prep" 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.)
The DB2 10.1 Information Center contains in-depth information on all aspects and features on the DB2 10.1 family of products. The pages contain the CREATE commands for the database objects in this tutorial follow. If you have not reviewed commands in this format before, be sure to review How to read the syntax diagrams in DB2 Information Center:
Get an overview of Test 000-610: DB2 10.1 Fundamentals, especially the objectives, and find more resources to prepare for the exam.
Find more information about other IBM Certification Tests, including Test 000-611: DB2 10.1 DBA for Linux, UNIX, and Windows.
Learn more in-depth DB2 information with the DB2 basics series, especially if you want more information about Tablespaces and bufferpools.
Some excellent information can be found in the DB2 9 Fundamentals certification 730 prep series, especially Part 3: Accessing DB2 data, which relates to topics covered in this tutorial, although some information has been deprecated in DB2 10.1, such as the Control Center.
Learn more about IBM Data Studio on developerWorks with the IBM Data Studio 3.1.1 Information Roadmap.
Learn more about Information Management at the developerWorks Information Management zone. Find technical documentation, how-to articles, education, downloads, product information, and more.
Stay current with developerWorks technical events and webcasts.
Follow developerWorks on Twitter.

Get products and technologies

Get the latest edition of IBM DB2 Express-C free of charge.
Download a trial version of IBM DB2 for Linux, UNIX, and Windows.
Get IBM Data Studio for free and start creating and managing databases right away.
Build your next development project with IBM trial software, available for download directly from developerWorks.
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.