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.
In this series
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 1:
This tutorial introduces the basics of the DB2 products and tools, along with the concepts of data warehousing and OLAP.
- DB2 9 Fundamentals exam 730 prep, Part 2:
This tutorial introduces you to DB2 security. Learn about DB2 authentication, authorization, and privileges.
- DB2 9 Fundamentals exam 730 prep, Part 3: Accessing
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 4: Working
with DB2 data
This tutorial introduces you to Structured Query Language (SQL), and gives you the basics of how DB2 9 uses SQL to manipulate data in a relational database.
- 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
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.
- DB2 9 Fundamentals exam 730 prep, Part 7: Introducing
DB2 9 features significant new support for storing, managing, and querying XML data. Learn how to query data stored in XML columns using XQuery.
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.