Overview
| Course code | 1L220 | Skill level | Basic |
|---|---|---|---|
| Duration | 2.5 days | Delivery type | Web Based Training |
| Course type | Public only | ||
| Public price | USD $499.00 plus tax | ||
Note: This is a self-paced online course. This course usually requires 20 hours to complete. Once you receive your access information, you will have 60 days access to this course.
This tutorial introduces the basics of the DB2 products and tools, along with the concepts of data warehousing and OLAP. It contains tutorials designed to help you prepare for the DB2 V9 Family Fundamentals Certification (Exam 730). DB2 installation is not covered in this tutorial.
This innovative self-paced online format is available from IBM Training and gives you the opportunity to complete the course at your convenience, at any location, and at your own pace. Once you have accessed the course, instructor help is available via the course forum Monday through Friday; questions will be responded to within 24 hours. The course is available 24 hours a day
Please do not make travel arrangements for this course. After you receive confirmation that you are enrolled, you will be sent further instructions to access the course materials.
Audience
This is a basic course for who are interested in an introductory knowledge of DB2 9.5 for Linux, UNIX, and Windows.
Skills taught
Upon completion of this course, you should possess an introductory knowledge of DB2 9.5 for Linux, UNIX, and Windows.
Course outline
DB2 Planning
After completing this unit, you should be able to meet the following objectives:
- List the editions of DB2
- Define central management
- Configure a database with the Configuration Assistant
- List free tools that come with DB2
- Define data warehousing
- Identify the products that come with DB2 Warehouse
- Define OLAP and explain the types of reports that can be generated
DB2 Security
- Establish a security plan
- List the various types of authentication
- Obtain authorities
- List and explain DB2 privileges
Accessing DB2 UDB Data
- Create a DB2 database on your own
- Catalog the DB2 database for use by other users
- Examine and manipulate the objects within that database
Working with Data in DB2 Universal Database
- List the fundamentals of SQL
- Provide access control to database objects by using Data Control Language (DCL)
- Create, modify, and drop database objects by using Data Definition Language (DDL)
- Select, insert, update, and delete data by using Data Manipulation Language (DML)
- Create and call SQL procedures from the command line
- Use XML Viper and its relational capabilities
DB2 Tools
- Locate and employ the DB2 wizards, advisors, and notebooks
- Use the DB2 Command Line Processor (DB2 CLP) and the DB2 Command Window (DB2 CW)
Working with DB2 UDB Objects
- Explain the features of objects
- Create and manipulate objects using Structured Query Language (SQL)
- Use objects in applications
Data Concurrency
- Define data consistency
- Describe transactions and how they are initiated and terminated
- Isolate transactions from each other in a multi-user environment
- Provide concurrency control by using locks
- List the types of locks available
- Explain how locks are acquired
- List the factors that influence locking
Machine requirements
Please ensure that your machine and browser are capable of accessing this course by performing the browser check on this site:
My IBM
We're here to help
Easy ways to get the answers you need.
or call us at
Call 1-800-426-8322
Open M-F 9AM-7PM ET.
