TRAINING
-> DBMS COURSES -> DBMS PROGRAMMING
COURSE
Next Scheduled Class:
Duration:
5 days
Call for Scheduling Cost: $5,000 US Dollars
OVERVIEW
This
course teaches students how to develop efficient programs to access Oracle
CODASYL DBMS®. Participants will learn how to efficiently
access and update a database using the DBQ facility and from high-level
languages. This lecture/lab course includes Data Manipulation Language (DML)
syntax, READY modes, locking and the use of currency indicators.
AT COURSE COMPLETION
Students will be able to: |
- Describe
components of Oracle CODASYL DBMS and their
interaction
- Write an Oracle CODASYL DBMS DML (Data Manipulation
Language) application program in the high level language of their choice
- Perform ad-hoc access of a database using the DBQ facility
- Design efficient database access methods
- Use database currency indicators efficiently
- Use exception-handling routines to improve program
reliability and boost programmer productivity
- Use
COPY-LIBS for improving programmer productivity and
ensuring efficient database access
|
PREREQUISITES
Students attending this
course should be familiar with general VMS utilities & commands and
should have a good working knowledge of a programming language (preferably
COBOL) in the VMS environment.
TARGET AUDIENCE
This course is intended for persons responsible for
programming an Oracle CODASYL DBMS Database, specifically, Database
Designers/Developers, Database Administrators and Application Programmers.
| COURSE OUTLINE |
- Overview of Oracle CODASYL DBMS environment
- DBMS Components
- Role of Common Data Dictionary (CDD)
- Database Concepts
- Oracle CODASYL DBMS database definition
- Understanding Bachman Diagrams
- Database Query Facility (DBQ)
- Currency Indicators
- DML programming
- Exception Handling
- Callable DBQ
- Callable DBCS routines
|
Register Today!
|
DBMS PROGRAMMING COURSE