An Overview of Oracle (2 day)

Course Overview

The course will allow the delegate to understand the terms, structure and requirements of an Oracle database, the implications of systems design and the functionality available within the database. This course covers many topics which are essential for effective design, implementation and administration of an Oracle database.

Audience

Those who require a knowledge of the structure, operation, design and theory behind Oracle database technology. Those who will be managing, developing, supporting, implementing or administering an Oracle database, or database applications.

Prerequisites

Delegates should have a good basic understanding of information technology. No prior knowledge of Oracle is required.

Course Outline

THE RELATIONAL DATABASE

• What is a Database?
• Logical and Physical Design
• The Relational Database
• Primary Keys and Foreign Keys
• Relationships
• Design Normalisation

THE ORACLE RDBMS

• The RDBMS
• SQL - Structured Query Language
• Defining the Data
• Transactions and Redo Logs
• Oracle Database Architecture
• Network Connectivity
• Users and Security

SQL COMMAND TOOLS

• The Command Line
• SQL*Plus
• • SQL Worksheet
  • SQL*Plus Worksheet
• WHERE - Specifying Rows
• Expressions, Operators and Functions
• Joins - Querying Multiple Tables

DATABASES AND TABLES

• Overview of Database Creation
• Tablespaces and the OFA
• Creating Schema Objects
• Datatypes
• Creating Tables and Constraints