DB2 Concepts and Facilities
Course Title: DB2 Concepts and Facilities
Course#: DB01T
Duration: 2 days
Overview:
Students who complete this course will learn the terminology associated with relational data bases, and be introduced to the facilities of DB2 that are most important to application developers. They will be exposed to basic SQL statements and the DB2 application development environment. They will also develop skills in normalizing tables.
Topics:
Exercises:
There are three standard machine exercises, one pencil and paper exercise, and one optional machine exercise.
Audience:
Application developers who need to develop or maintain applications in a DB2 environment, or who need a general understanding of DB2 capabilities and use.
Prerequisites:
The student entering this course should have experience in designing and coding application programs in COBOL or PL/I, in the application environment (CICS, IMS/DB/DC, TSO, or batch) in which DB2 will be used.
Course#: DB01T
Duration: 2 days
Overview:
Students who complete this course will learn the terminology associated with relational data bases, and be introduced to the facilities of DB2 that are most important to application developers. They will be exposed to basic SQL statements and the DB2 application development environment. They will also develop skills in normalizing tables.
Topics:
- DB2 features
- Relational data base concepts
- DB2 objects
- The DB2 catalog
- Relational operations: SELECT, PROJECT, and JOIN
- DB2 data types
- Referential integrity and normalization
- SQL data manipulation introduction: SELECT, UPDATE, DELETE,
- SQL data definition introduction: CREATE, DROP, ALTER commands
- SQL data control introduction: GRANT, REVOKE
- DB2 application development: pre-compile, compile, bind, link, execute
- DCLGEN
- Host variables
- COMMIT
Exercises:
There are three standard machine exercises, one pencil and paper exercise, and one optional machine exercise.
Audience:
Application developers who need to develop or maintain applications in a DB2 environment, or who need a general understanding of DB2 capabilities and use.
Prerequisites:
The student entering this course should have experience in designing and coding application programs in COBOL or PL/I, in the application environment (CICS, IMS/DB/DC, TSO, or batch) in which DB2 will be used.
Clients
