|
Introduction to Oracle Database
Administration
This course gives an introduction to the
administration of an ORACLE Relational Database. It takes the format of
a workshop, with a mix of lecture, working examples and practical
exercises. It is based on ORACLE but some of the underlying principles
may be applied to other databases including Informix, Microsoft SQL
Server, Access and DB2.
Select here for related courses |
Select here for a list of all courses |
OBJECTIVES OF THE COURSE
To take students proficient with SQL and
PL/SQL into practical administration of the Oracle database environment.
| COURSE CODE |
ODBA |
TUTORS |
Ken
Decr email |
| DURATION |
5 days |
VENUE |
Newark Training Centre ** |
| PRICE |
£1300 plus
VAT * |
BOOKING CONTACT |
Mick
Hosegood email |
| EXPERIENCE LEVEL |
Intermediate |
TECHNICAL CONTACT |
Mick
Hosegood email |
*see note at bottom for special savings!
for pricing for a course run especially for your organisation, please
use our worksheet **Also available on your site for groups of four to
ten.
COURSE DATES:
|
Sep
|
Oct
|
Nov
|
Dec
|
Jan
|
Feb
|
Mar
|
Apr |
May |
June |
July
|
Available
|
onsite
|
only
|
|
|
|
|
|
|
|
|
INTENSITY: About 40% of the course is
practicals, and 60% lectures.
RESOURCE: Each student will have
exclusive use of a PC or Sun workstation for the duration of the
course. Each student will be provided with a full set of training notes
relating to the course.
PREREQUISITES: This course is
only suitable for those who have attended both the Introduction to Oracle SQL*Plus Course and the Oracle
PL/SQL course
It is also recommended that the delegate
has
several months hands on experience of the use of both SQL, SQL*Plus and
PL/SQL.
FOLLOW UPS: First Alternative will be
offering further Oracle course in the future.
PRACTICALS / TAKEAWAYS: Each student
leaves the course with his own set of training notes for the material
covered.
SOFTWARE VERSIONS: This course is
based on Oracle 8 and 9.
TOPICS COVERED ON THE COURSE
System Architecture
Database Versus Instance, The Database Instance, The System Global
Area, Process Structures, The Database Files, Physical files and
Logical files. What is Client Server?, What is Net8?
Server Management
What Tools are Available? - SQL*Plus, Server Manager, Enterprise
Manager. Management Tasks, Start up and Shutdown, Database Modes -
Nomount, Mount and Open.
Space Management
What is a Tablespace?, an Extent? a Cluster? a Block? a Segment? Space
Considerations. Management Tasks. Creating a Tablespace. Changing
Status - Offline and Online. Space Allocation, Extending a Tablespace.
Removing an Object.
Utilities
What is a Utility? Management Tasks. Export and Import. Unloading Data.
Loading Data \226 SQL Loader. Appending Data.
Simple Backup and Recovery
What is Backup? Recovery? A Rollback Segment? A Redo Log? Management
Tasks. Creating a Rollback Segment. Backup Without Archiving. The Files
to Backup. Advantages and Disadvantages. Full Recovery. Types of
Failure. Backup and Recovery Manager. Backup Strategies.
Complex Backup and Recovery
Management Tasks. Backup With Archiving. The Files to Backup.
Advantages and Disadvantages. Archive Mode. Partial Recovery. Types of
Failure.
User Management
What is a User? a Privilege? a Role? a Profile? Management Tasks.
Creating a User, Granting Privileges and Roles. Removing an Object.
Killing a User Session. Syntax for Create User.
Table Management
Create Table. Constraints, Foreign Keys, Clusters. Alter Table. Create
Synonym. Finding Objects, Removing an Object.
Tuning and Performance
Management Tasks. Timing. Explain Plan. Set Autotrace on Explain.
Analyse Statement. SQL Trace.
Creating A Database
Using the Database Wizard. Database Creation Tasks. The Parameter File,
The New database. Rollback Segments, Tablespaces. Completing the
Database. Utility Scripts. Help Text, Product User profiles. The
SCOTT/TIGER Tables.
|
Home 