Home > Infrastructuur services > OpenVMS > Oracle Rdb training
Oracle Rdb training
Preferred Oracle partner
VX Company is geselecteerd als Oracle partner voor het geven van Oracle Rdb trainingen in Europa. De volgende trainingen worden door VX Company verzorgd:
Introduction to Oracle Rdb: Technical overview and the SQL language
Course ID
INT RDB 01 Register
Please send us an e-mail.
Length
3 Days
Costs
2250 Euro
Description
After this course you will be familiar with the possibilities, advantages and functions of Oracle Rdb databases. You will be able to use interactive SQL to access and process data in the Oracle Rdb database.
Previous knowledge required
Familiarity with database management system concepts.
Previous knowledge recommended
Some experience with a computer operating software system, preferably OpenVMS.
Course topics
Relational database concepts
· Overview of relational database concepts
· Description of the files and components of an Oracle Rdb database
· Overview of the user interfaces, performance, data integrity and user management features
Introduction to interactive SQL
· Attach to an Oracle Rdb database
· Display online help and information on database objects
Retrieve and display Data
· Select and display data in random and sorted form
· Specify conditions for the data to be selected
· Apply functions to the data
· Retrieve data from more than 1 table
· Carry out calculations with stored data
Manipulate Data
· Insert, update and delete data
· Start and check a transaction
· Describe the effects of constraints and triggers on operations
Management of several users
· Reserve tables
· Channel isolated levels in transactions
· Prevent database access conflicts
Create database objects
· Define a database
· Create tables, views and indexes
Oracle Rdb Internals
Course ID
INT RDB 03 Register Please send us an e-mail.
Length
5 Days
Costs
3750 Euro
Description
After this course you will be able to analyze key components of Oracle Rdb bugcheckdumps, describe database recovery mechanisms and use RMU utilities to analysis the database structure and integrity.
Previous knowledge required
The participants are expected to be familiar with Oracle Rdb at the level of the 'Oracle Rdb for the Database Adminstrator' course. They must also have at least six months' experience of Oracle Rdb database management.
Previous knowledge recommended
‘Rdb Performance and Tuning' Course.
‘Rdb for the Database Administrator' Course.
Course topics
Oracle Rdb overview
· Images, files and processes on OpenVMS and Digital UNIX
· DSRI components
· Develop and understand the dispatch functionality
Query the Database Engine
· Compile the request
· Describe static optimization
· understand how Oracle Rdb uses query outlines
· Execute the request
· Detail dynamic optimization
· Optimize record versioning for online metadata updates
· Target page selection
Oracle Rdb Locking
· Discussion of locking concepts
· Study the way the object manager locks the key database
structures.
· Study the lock structures
· Determine the lock granularity
Study the on-disk structures and algorithms
· Study on-disk root structures
· Study and display the page and index structures
· Study snapshots and read-only transactions
· Discuss how Oracle Rdb manages the data pages and buffers
Description of environment and integrity
· Detailed examination of the way Oracle Rdb accesses the database and starts a transaction
· Discuss how Oracle Rdb executes after-image and recovery unit journaling
· The Oracle Rdb monitor responsibility
Oracle Rdb Performance and Tuning
Course ID
INT RDB 04
Register Please send us an e-mail.
Description
After this course you will be able to monitor, test and analyze database performance and tune the database for optimal performance.
Length
5 Days
Costs
3750 Euro
Previous knowledge required
The participants are expected to be familiar with Oracle Rdb at the level of the 'Introduction to Oracle Rdb' course and have experience with OpenVMS utilities, commands and editors.
Previous knowledge recommended
At least three months' experience with design or management of the Oracle Rdb database is an advantage.
Course topics
Method
· Define steps for tuning an Oracle Rdb database environment
· Set the targets and expectations
· Introduction of the use of diagnostic tools
Database retrieval strategies
· Analysis of single-table and multi-table queries and the use of
indexes
· Influencing the optimizer strategy
· Analysis of sorted and hashed indexes
Monitor locks
· Examining the locks using monitoring tools
· Resolving lock conflicts
· Identifying row, buffer and page locks
Tuning storage areas
· Define the format of the existing storage areas
· Consider strategies for placing data in storage areas
· Analysis of the storage area parameters and the impact on
performance
· Setting storage area parameters
Tuning the database
· Improving performance with after-image journaling
· Difference between global and local buffers
· Description of recovery journaling
Tuning applications
· Discussing the impact of isolated levels on concurrency
· Adjusting constraints and triggers
· Description of the methods for modifying the optimizer strategy
Oracle Rdb for the Database Manager
Course ID
INT RDB 05
Register
Please send us an e-mail.
Length
5 Days
Costs
3750 Euro
Description
After this course you will be able to carry out maintenance procedures on the Oracle Rdb database, extract data from the database, load data and start and stop the database. At the same time you will be taught to check/monitor and secure the database, and carry out backups and database recoveries. You will also learn to identify and solve performance problems.
Previous knowledge required
This course requires knowledge at the level of the 'Introduction to Oracle Rdb' course.
Previous knowledge recommended
Experience with OpenVMS utilities and commands.
Course topics
Opening and closing databases
· Starting and stopping the Oracle Rdb monitor process
· Setting limits and changing database parameters upon opening
· Viewing and using the monitor logfiles
Load/unload data
· Define load and data placement strategy
· Handling load exceptions
· Troubleshooting data load operations
Security management
· Defining the types of Access Control Lists (ACLs)
· Granting and defining privileges and database roles
· Using the security audit database
Backup and restore a database
· Describe the steps in the backup process
· Verify the database for backing up
· Handling RMU backup commands and qualifiers
· Carrying out a restore of a database
· Carrying out a recovery of a database
Reconstructing a database
· Changing metadata in SQL
· Reconstruction of storage areas and maps
· Changing database structures with the export/import utility
· Copying the database
Installation considerations
· Identify system requirements
· Describe installation requirements
· Describe post-installation operations
Oracle Rdb for the Database Designer
Course ID
INT RDB 06
Register Please send us an e-mail
Description
After this course you will be able to design, create and load an Oracle Rdb database.
Length
5 Days
Costs
3750 Euro
Previous knowledge required
The participants are expected to be familiar with SQL at the level of the Introduction to Oracle Rdb course and with database concepts.
Previous knowledge recommended
Experience with OpenVMS utilities and commands
Course topics
Overview of physical database design concepts
· Identifying objectives and elements of a physical database design
· Discussing Oracle Rdb design methods and tools
Carrying out physical design tasks
· Collecting (sample) data
· Carrying out a transaction analysis
· Drawing up a logical model
· Defining database type
· Develop a strategy for management data definitions
Defining physical database structure
· Define database type, data types, tables, columns and views
· Implement data storage formats
· Define indexes
· Create storage maps
· Normalize/denormalize data
· Consider verification and sizing
· Carry out a transaction analysis
· Size of database structures
Database parameters
· Define correct database parameters and options
· Specify the number of storage area slots
· Discuss the size and the number of buffers
· Set the correct storage area threshold parameters
Create a database
· A single-file or multi-file database
· Save database definitions
· Create database elements and objects using command files
Loading data
· Organizing data for efficient loading
· Loading data using utilities
· Describe the restrictions and performance issues
|
