Oracle 9i DBA I on-site training course

Home

Public Courses

Oracle Courses

Microsoft Courses

Java Courses

Consultancy

HomeContact UsAbout UsDownloadFAQPublic CoursesLondonEdinburghBirminghamManchesterDublinLeedsCardiffNewcastleBelfastSwanseaOracle CoursesSQLSQL for Users Part 1Query BuilderEssential SQL10G SQL9i SQLUsing SQL with SQL DeveloperSQL Developer Part 1SQL Developer Part 2PLSQLPLSQL 1PLSQL 2PLSQL 10gPLSQL 9i9i New Features8i New FeaturesDiscoverer10g Administration10g Desktop10g Plus9iAdministrationDesktop4iAdministrationDesktop3.1AdministrationUserFormsForms 10gForms 9iForms 6iForms 6i New FeaturesReportsReports 10gReports 9iReports 6iReports 6i New FeaturesGraphics 6iDBA10g DBA 110g DBA 210g New Features9iNew Features for DBAsDBA 1DBA 2Database TuningNetwork AdministrationAS Basic Administration8iNew Features for DBAsDBA 1DBA 2Database TuningNetwork AdministrationMicrosoft CoursesWordExcelAccessPowerpointFrontpageProjectJava CoursesFundamentals of JavaJava ProgrammingJava SwingConsultancyDiscoverer ConsultancyData ConsultancyOracle Consultancy

Contents

This intensive hands-on training course is broken down into sections and includes the following aspects of the 9i Database:

Discussion of 9i Database Architecture
Background processes
SGA and memory structures
Data files, tablespaces, extents, blocks and rows
Common administrative tasks

Exercises

There are practical and comprehensive exercises scheduled throughout the course to ensure delegates leave with a sound theoretical and practical knowledge.
The exercises include

Install, start up and shutdown
Security policy
Backup and recovery strategy
Physical storage of indexes and tables

Duration

Five Days

9i DBA I

This course provides the starting point for administration of the Oracle 9i Database.

Pre-Requisite Course(s)
Introduction to SQL
PLSQL (Optional)

Next Course(s)
9i DBA II
9i Database Tuning
9i Network Administration