 | Level: Intermediate Sunil Sabat (sunil_sabat@yahoo.com), Technical Alliance Manager, IBM
15 Feb 2007 Learn about the fundamental concepts of data manipulation in DB2® databases. This is Part 2 in a series of nine tutorials that you can use to help prepare for the DB2 9 Application Development Certification exam (Exam 733).
In this tutorial
- The
material in this tutorial primarily covers the objectives in Section 2 of the exam,
entitled "Data manipulation."
Objectives - Learn how to change data (insert, update, delete)
- Learn about query a database across multiple tables or views
- Learn to use materialized query tables (MQTs)
- Learn to use DB2 SQL functions and stored procedures
- Learn to use common table expressions
- Determine when to use cursors in a SQL program
- Identify types of cursors (read only, updatabale, scrollable)
- Identify the scopes of cursors
- Learn to manipulate cursors
- Learn how to manipulate large objects (LOBs) (such as Character Large Objects [CLOBs] and Binary Large Object [BLOBs])
- Manage a unit of work (for instance, a transaction)
Prerequisites
To take the DB2 9 Family Application Development exam, you must have already passed
the DB2 9 Family Fundamentals exam (Exam 730). You can use the "DB2 Family Fundamentals tutorial series" to prepare for that exam. It is a very popular series that has helped many people understand the fundamentals of the DB2 family of products.
System requirements
You do not need a copy of DB2 9 to complete this tutorial. However, if you wish, you can download a free copy of DB2 Express-C 9 from the DB2 Express-C downloads page.
Duration
Less than two hours
Formats html, pdf
| | | |
