Jump to main content
Jump to main navigation
Jump to section navigation
Course Description
This course prepares a student to take and pass the DB2 UDB V7.1 Family Fundamentals certification test 512. The course trains the student on an in-depth knowledge of basic SQL, DML, DDL, and an understanding of database objects (tables, views, etc.). A basic understanding of the concepts and features of DCL, database creation, data types, stored procedures, programming, components and packaging (SDK, EEE, etc.), protocols supported, installation of products, GUI tools, CLP, basic isolation levels, and import/export is also covered. During the course the student will build and run a DBS UDB database using data made available in unload format. The database and data are simple, but will illustrate the basic create and load tasks.
Class Length
5 days
Objectives
Who will benefit from this course
Application developers, database and systems administrators, technical support personnel.
Prerequisites
Privacy policy
Site terms & conditions
Site map
Contact Portal Partnership
© Copyright Portal Partnership 2009
Introduction to IBM DB2 Universal Database 8.1
This course prepares a student to take and pass the DB2 UDB V7.1 Family Fundamentals certification test 512. The course trains the student on an in-depth knowledge of basic SQL, DML, DDL, and an understanding of database objects (tables, views, etc.). A basic understanding of the concepts and features of DCL, database creation, data types, stored procedures, programming, components and packaging (SDK, EEE, etc.), protocols supported, installation of products, GUI tools, CLP, basic isolation levels, and import/export is also covered. During the course the student will build and run a DBS UDB database using data made available in unload format. The database and data are simple, but will illustrate the basic create and load tasks.
Class Length
5 days
Objectives
- Plan and implement an installation
- Implement instances and their security
- Create and Access DB2 databases
- Use SQL statements
- Describe various database objects
- Explain database concurrency.
Who will benefit from this course
Application developers, database and systems administrators, technical support personnel.
Prerequisites
- UNIX/Linux systems knowledge
- Microsoft Windows knowledge
How can we help you?
For more information about training with Portal Partnership and to ascertain how we can help you maximise your investment in IT:
Telephone us on 01344 386000
Email us at
training.admin@portalpartnership.com
Privacy policy
Site terms & conditions
Site map
Contact Portal Partnership© Copyright Portal Partnership 2009