SCI - DBMS Database Administration Course for Oracle CODASYL DBMS

	DBMS ADMINISTRATION COURSE

DATABASE
ADMINISTRATION

TRAINING -> DBMS COURSES -> DBMS ADMINISTRATION COURSE

Next Scheduled Class:                                                                       Duration: 5 days
November 2 - 6, 2009                                                                          Cost: $5,000 US Dollars

OVERVIEW
In this course, participants will gain a thorough conceptual understanding of the Oracle CODASYL database architecture. They will learn how to create, set, maintain and troubleshoot an Oracle CODASYL database. As well as efficiently load data, control and audit database access. Participants will also learn how to handle small crisis’s that can arise in the database environment and create database security measures within the database. This course will address frequently asked questions that will prepare participants to troubleshoot “real world” issues and allow students to ask individual questions about their particular database environments.

AT COURSE COMPLETION
Students will be able to:

Describe the role of the DBA within an organization
Understand components of Oracle CODASYL DBMS and their interaction
Design an efficient database model
Create an Oracle CODASYL DBMS database
Monitor the day-to-day operations of Oracle CODASYL DBMS databases
Identify the "dos" and "don’ts" of Oracle CODASYL DBMS administration
Identify key measures of database performance
Have ability to backup and restore databases from DBO backup files and after image journals.
Handle "small" crisis that may arise in an Oracle CODASYL DBMS environment
Establish appropriate levels of database security for your environment

PREREQUISITES
Students attending this course should have completed VMS Utilities and Commands, or be experienced with the commands and utilities available in VMS.

TARGET AUDIENCE
This course is intended for persons responsible for creating, administering, or overseeing an Oracle CODASYL DBMS database, specifically, Database Administrators, Programmers, Database Managers, System Administrators, Network Administrators and Technical Support Professionals.

COURSE OUTLINE

DBA job functions and responsibilities
Comparison: Oracle CODASYL DBMS, Oracle Rdb, RMS
Oracle CODASYL DBMS components (.DDL, .CDD, .ROO, .DBS, .SNP, .AIJ, .RUJ, .DMP, DBMMON)
Schema, subschema & storage schema Data Definition Language (DDL)
Creating a database
Interactive DBQ
Concurrent Access/Recovery
Database maintenance and recovery
Database design and performance
Oracle CODASYL DBMS database backup, journaling and recovery
DBO utilities and commands
Efficient database design and implementation techniques
Database security

Register Today!

REQUEST		INFORMATION