Introduction to Oracle

Oracle Training Click here to contact us

Course Overview

Introduction to Oracle provides students with an intro to relational database concepts and Oracle Technology. The course follows an introduction to the components of a database management system with an in-depth discussion of what comprises a relational database management system (RDBMS). Data anomalies and the normalization of data are discussed to provide the student with necessary background before jumping into Oracle Technology. A brief look at the main languages that Oracle Technology employs -- SQL, PL/SQL, XML and Java -- is followed by a discussion of the typical software development life cycle (SDLC). The session ends with an examination of the Oracle Database architecture and overview of some of the more common Oracle Database concepts.

Course Goals

  • Obtain a working knowledge of the various pieces of a relational database.
  • Be able to identify and describe some of the key pieces of Oracle Technology.
  • To enable the student to make informed decisions about architecture and development.

Prerequisites

  • None

Who Should Attend?

  • Beginning users and non-technical individuals looking to gain exposure to Oracle Technology
  • C-level individuals who are responsible for strategic planning at a technical or non-technical level

Course Materials

  • Introduction to Oracle Course Notes
  • Introduction to Oracle Reference Book

Duration

  • One day

Tuition

  • $465

Course Outline

  • Relational database overview
  • Oracle time line and history
  • Tables
  • Data anomalies
  • Data normalization
  • SQL and SQL*Plus
  • PL/SQL
  • Java
  • XML
  • The software development life cycle
  • Components
  • Roles
  • Oracle Technology overview
  • Implementation architectures
  • Oracle Database physical architecture
  • Oracle Database objects
  • Oracle ata dictionary
  • Architecture, development and application decision making