Concentrika poppy

About us

 

About the course

The course is intended for those who need to understand database technology and in particular, that engineered by Oracle Corp. On the course you will learn the features of a RDBMS and Oracle's management interfaces, both the GUI and the command line options. The course seeks to show delegates where everything is and how the components fit together, rather than imparting low level ability to manipulate the database. The course also serves as a high level introduction to SQL*PLUS and the SQL database interface language. Anyone wishing to progress towards full training in Oracle SQL or Oracle Database Administration will find this training a useful launch-pad.

Prerequisites

Delegates should have a general familiarity with IT and feel confident inputting commands into a computer, navigating GUI menus and accessing files on the filing system. Some of the overviews are fairly technical and an understanding of how IT fits together in general would be helpful.

The rest, we teach you on the course.

Duration

2 days

1. Database technology overview

4. Oracle architecture

  • Instances and databases
  • Components of a database
  • Components of an instance

7. An introduction to the SQL*PLUS client

  • Working within SQL*PLUS
  • A review of the features of SQL
  • The data dictionary
  • Workshop - building a small system

2. Designing systems

  • Logical data modelling
  • Steps leading from design to implementation
  • Data design workshop

5. Net 8

  • The Net8 connectivity vision
  • TCP/IP architecture and net8
  • Oracle applications based on Net8
  • Programmable clients

8. Oracle objects

  • A introductory review of objects
  • Tables, views and indexes
  • Other schema objects
  • System objects

3. Introducing Oracle

  • The Oracle 8I family
  • Application development features
  • Connectivity features
  • Distributed processing
  • Data movement
  • Performance features
  • Management features

6. Oracle and the internet

  • 3 tier architecture
  • Web enabling features

9. Oracle security mechanisms

  • Types of Oracle login
  • Users and passwords
  • Permissions and privilege
  • Database roles

10. The audit subsystem

 

 

 
Courses
schedule
Contact us