The Fundamentals tutorial series provides an introduction to SQL (Structured Query Language) and covers how DB2® 9 is packaged and installed, how to create databases and database objects, and the basics of database security and transaction isolation. These tutorials provide a solid base for each section of the exam. However, you should not rely on these tutorials as your only preparation for the exam.
After a quick registration, you can begin a tutorial. Each tutorial should take about an hour to complete. You can take the tutorials online, or download a PDF or zip file.
DB2 9 Fundamentals exam 730 prep, Part 3: Accessing DB2 data
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, learn about the tools available to create, access, and manipulate DB2 objects.
DB2 9 Fundamentals exam 730 prep, Part 5: Working with DB2 objects
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.
DB2 9 Fundamentals exam 730 prep, Part 6: Data concurrency
This tutorial introduces you to the concept of data consistency and to the various mechanisms that are used by DB2 9 to maintain database consistency in both single and multi-user environments.
Once you have the fundamentals mastered, you may be interested in learning more about DB2 database administration tasks. If so, check out the DB2 DBA exam 731 prep tutorials.
