db2-cert7304-a4 - Working with DB2 data

db2-cert7304-a4 - Working with DB2 data - DB2 9...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
DB2 9 Fundamentals exam 730 prep, Part 4: Working with DB2 data Skill Level: Introductory Roman Melnyk ( roman_b_melnyk@hotmail.com ) Staff Information Development IBM Toronto 24 Jul 2006 This tutorial introduces you to Structured Query Language (SQL) and helps to give you a good understanding of how DB2® 9 uses SQL to manipulate data in a relational database. This tutorial is the fourth in a series of seven tutorials that you can use to help prepare for DB2 9 Fundamentals Certification (Exam 730). Section 1. Before you start About this series Thinking about seeking certification on DB2 fundamentals (Exam 730)? If so, you've landed in the right spot. This series of seven DB2 certification preparation tutorials covers all the basics -- the topics you'll need to understand before you read the first exam question. Even if you're not planning to seek certification right away, this set of tutorials is a great place to begin learning what's new in DB2 9. About this tutorial This tutorial explains how DB2 uses SQL to manipulate data in a relational database. . The material provided herein primarily covers the objectives in Section 4 of the exam, which is entitled "Working with DB2 Data using SQL and XQuery." You can view these objectives at: http://www-03.ibm.com/certify/tests/obj730.shtml . Topics covered in this tutorial include: • An introduction to SQL Working with DB2 data © Copyright IBM Corporation 1994, 2006. All rights reserved. Page 1 of 22
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
• A description of Data Manipulation Language (DML) and examples that demonstrate how to use it to obtain specific information. • Transaction boundaries • SQL procedures and user-defined functions Objectives After completing this tutorial, you should be able to: • Understand the fundamentals of SQL, with a focus on SQL language elements • Use DML to select, insert, update, or delete data • Use COMMIT and ROLLBACK statements to manage transactions, and know what constitutes a transaction boundary • Create and call SQL procedures or invoke user-defined functions from the command line System Requirements If you haven't already done so, you can download the free trial version of IBM DB2 9 to work along with this tutorial. Installing DB2 helps you understand many of the concepts that are tested on the DB2 9 Fundamentals Certification exam. DB2 installation is not covered in this tutorial, but the process is documented in the DB2 Information Center. Conventions used in this tutorial The following text highlighting conventions are used in this tutorial: Monospaced text is used for SQL statements. UPPERCASE text identifies SQL keywords, and lowercase text identifies user-supplied values in example code.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 22

db2-cert7304-a4 - Working with DB2 data - DB2 9...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online