0) Db2-730 Test Overview

®

IBM Software Group

DB2 – 730 Certification Overview ` AJAY SHANKAR KHARE Technical Consultant DB2 – IBM Academic Initiative Webtek Labs Pvt. Ltd.

© IBM Corporation

IBM Software Group

DB2 V8.1- Family Fundamentals- Test 700 ƒ DB2 product Information (Product Overview) ƒ DB2 concepts-D.A.S. & Cataloging (Getting Started, Getting Connected) ƒ Tools, wizards (demostrations) ƒ Data Storage Management ƒ User defined datatypes ƒ Constraints ƒ Access Control (Controlling Data Access) ƒ Joins ƒ Views ƒ Concurrency

2

© 2008 IBM Corporation

IBM Software Group

CERTIFICATION EXAM ƒ IBM Certified Database Associate for DB2 9 (Test – 730) ƒ Objective type exam No. of questions : 64 Passing % required : 59 % Duration of exam : 90 minutes 3

© 2008 IBM Corporation

IBM Software Group

Why DB2 9  DB2 History & DB2 9 ( Viper)  XML Technology  XML in DB2 Viper  XQuery  Table Partitioning  Granular Security - LBAC  Data Compression  DB2 Express - C

4

© 2008 IBM Corporation

IBM Software Group

Section 1 - Planning (15%)  Knowledge of DB2 UDB products (client, server, etc.)  Knowledge of the features and functions provided by DB2 tools such as the Control Center, the Configuration Advisor, the Configuration Assistant and the Command Line Processor  Knowledge of database workloads (OLAP versus data warehousing)  Knowledge of non-relational data concepts (extenders)  Knowledge of XML data implications (non-shredding)

5

© 2008 IBM Corporation

IBM Software Group

Section 2 - Security (11%)  Knowledge of restricting data access  Knowledge of different authorities and privileges available  Knowledge of encryption options available (data and network)  Given a DCL SQL statement, ability to identify results (GRANT, REVOKE, CONNECT statements) 6

© 2008 IBM Corporation

IBM Software Group

Section 3 - Working with Databases and Database Objects (17%)  Ability to identify and connect to DB2 servers and databases  Ability to identify DB2 objects  Knowledge of basic characteristics and properties of DB2 objects  Given a DDL SQL statement, ability to identify results (ability to create DB2 objects) 7

© 2008 IBM Corporation

IBM Software Group

Section 4 - Working with DB2 Data using SQL and XQuery (23.5%)  Given a DML SQL statement, ability to identify results  Ability to use SQL to SELECT data from tables  Ability to use SQL to SORT or GROUP data  Ability to use SQL to INSERT, UPDATE, or DELETE data  Knowledge of transactions (i.e., COMMIT, ROLLBACK, and transaction boundaries)  Ability to call a procedure or invoke a user defined function  Given an XQuery statement, knowledge to identify results 8

© 2008 IBM Corporation

IBM Software Group

Section 5 - Working with DB2 Tables, Views, and Indexes (23.5%)  Ability to demonstrate proper usage of DB2 data types  Given a situation, ability to create a table  Ability to identify when referential integrity should be used  Ability to identify methods of data constraint  Ability to identify characteristics of a table, view or index  Ability to identify when triggers should be used  Knowledge of schemas  Knowledge of data type options for storing XML data 9

© 2008 IBM Corporation

IBM Software Group

Section 6 - Data Concurrency (11%)  Ability to identify factors that influence locking  Ability to list objects on which locks can be obtained  Ability to identify characteristics of DB2 locks  Given a situation, ability to identify the isolation level that should be used

10

© 2008 IBM Corporation

IBM Software Group

Important Websites For information about Tests http://www.ibm.com/certify Job Opportunities for Certified professionals http://www.ibm.com/in/university

http://www.ibm.com/university

11

© 2008 IBM Corporation

IBM Software Group

Thank You Tamil

Merci French Russian

Obrigado Brazilian Portuguese

Arabic

Dank e German

Graci as Spanish

Grazie Italian

Thai

Simplified Chinese

Traditional Chinese

Japanese

12

© 2008 IBM Corporation