HomeSearchSite MapContact Us RemoteDBA Services for CODASYL DBMS and RdbPreserving Mission Critical IT Applications Through Virtualization

Remote Management of OpenVMS SystemsExtreme Performance Consulting


DBMS ADMINISTRATION COURSE
DATABASE
ADMINISTRATION

TRAINING -> DBMS COURSES -> DBMS ADMINISTRATION COURSE

Next Scheduled Class:                                                                       Duration:  5 days         
Call for Scheduling        
                                                                    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

 

Copyright © 2016 Software Concepts International
All Rights Reserved