|
Standard |
Posted: 09/10/07
|
R State Standard £ Institutionally Developed College: n/a |
CIS 2170 - DB2 Fundamentals and SQL
Course
Description
This course will provide both database
administrators and application developers with the broad foundation skills and
knowledge needed to be successful with IBM DB2 Universal Database (UDB) in a UNIX, Windows, or OS/2 environment. This
course will teach students the basic concepts of DB2 UDB, creating and
accessing database objects, basic Structured Query Language (SQL), and managing
databases. The course includes extensive hands on labs, labs where students can
code and test a wide variety of SQL statements. Prepares student to take IBM
Certification Test 730. Topics include:
identify DB2 UDB product editions, their installation and verification,
user interfaces, and security features, create and access DB2 database objects,
ensure data validation and integrity, and create views and indexes, master
basic Structure Query Language (SQL), and manage database operations.
|
Competency Areas |
Hours |
|
|
Identify
DB2 UDB product editions, their installation and verification, user
interfaces, and security features |
Class |
4 |
|
Create
and access DB2 database objects, ensure data validation and integrity, and
create views and indexes |
D. Lab |
6 |
|
Master
basic Structure Query Language (SQL) |
P. Lab/O.B.I. |
0 |
|
Manage
database operations |
Credit |
7 |
|
Prerequisite: |
CIS 214 |
|
Corequisite: |
|
Course Guide |
|
Competency |
After completing this section,
the student will be able to: |
Hours |
||
|
Class |
D.Lab
|
P.Lab/ O.B.I. |
||
|
|
|
|
|
|
|
UNDERSTAND IBM DATABASE OPERATING
ENVIRONMENT |
5 |
5
|
||
|
|
Understand
IBM database operating environments |
|
|
|
|
|
Be able
to install and identify operating system versions |
|
|
|
|
|
|
|
|
|
|
|
Understand
security capabilities in IBM DB2 |
|
|
|
|
|
|
|
|
|
|
CREATE AND VALIDATE DATABASE
OBJECTS |
15 |
20
|
|
|
|
|
Create
and Access DB2 database objects |
|
|
|
|
|
Execute
operations to validate and ensure data integrity |
|
|
|
|
|
Create
data object views and data object indexes |
|
|
|
|
|
|
|
|
|
|
MASTER BASIC STRUCTURE QUERY
LANGUAGE (SQL) |
15
|
25 |
|
|
|
|
Use SQL
SELECT statements to retrieve database data |
|
|
|
|
|
Use SQL
SELECT statements to sort and filter database data |
|
|
|
|
|
Use SQL
SELECT statements with IN, AND, NOT, and like operators |
|
|
|
|
|
Use SQL
table creation commands |
|
|
|
|
|
USE SQL
table JOIN commands |
|
|
|
|
|
Create
Data Views |
|
|
|
|
|
Develop
Constraint statements |
|
|
|
|
|
Use DML
statements |
|
|
|
|
|
|
|
|
|
|
MANAGE DATABASE OPERATIONS |
5 |
10
|
|
|
|
|
Identify
and connect to DB2 servers and databases |
|
|
|
|
|
Identify
factors that influence locking |
|
|
|
|
|
Identify
characteristics of DB2 locks |
|
|
|
|
|
Identify
data isolation levels that should be used |
|
|
|
|
|
Be able
to create and use triggers |
|
|
|
|
Suggested Resources |
IBM DB2 tutorial resources and DB2
and SQL Redbooks http://www-03.ibm.com/certify/tests/edu730.shtml
Chong, R., Siu, C., Qi,
S., and Snow, D. (Jan 2005). Understanding DB2 – Learning Visually with
Examples. IBM Press; Har/CDr edition. ISBN: 0131859161
Baklarz, G. and Wong, B.
(Feb 2003). DB2 UDB v8.1 for Linux, UNIX, and Windows Database Administration
Certification Guide. IBM Press, 5th
edition. ISBN: 0-13-046361-2
Visser, S. and Wong, B. (Aug 2003). Sams Teach Yourself DB2
Universal Database in 21 Days. Sams, 2nd
edition. ISBN: 0672325829
Sanders, R. (Sept 2003).
DB2 Universal Database V8.1 Certification Exam 700 Study Guide
IBM Press; Study Guide edition. ISBN 0-13-142465-3
Sanyal, S., Martineau, D.,
Gashyna, K., and Kyprianou, M. (April 2003). DB2 UDB V8.1 Application
Development Certification Guide. Prentice Hall, 2nd edition. ISBN:
0-13-046391-4
Sloan, S. (May 2004) The
Official Introduction to DB2® for z/OS®:
Covers DB2 ® Universal Database for z/OS® Version 8, 2nd
edition. IBM Press Series - - Information Management. IBM Press; 2 edition. ISBN:
0-13-147750-1