Sunday, 3 August 2014

DATABASE QUICK START

    Purpose

    In this tutorial, you learn about Oracle Database and how to perform simple operations on tables.

    Time to Complete

    Approximately 1 hour and 45 minutes:
    • 45 minutes to complete the prerequisites (Note: The time to download Oracle Database software to your local machine depends on the network. Therefore, it is not included in the time specified to complete the prerequisites.) 
    • 1 hour to complete this Oracle by Example (OBE)

    Introduction

    In general, a database is a collection of data treated as a unit. A database management system (DBMS) stores, manages and retrieves a large amount of data in a multi-user environment so that many users can access the same data concurrently.
    Oracle Database is a robust object relational database that provides efficient and effective solutions for database users such as delivering high performance, protecting users from unauthorized access, and enabling fast failure recovery.

    Hardware and Software Requirements 

    The following is a list of hardware and software needed to install Oracle Database:
    • Minimum of 1 GB of physical memory
    • Sufficient paging space
    • Appropriate service packs and patches
    • Appropriate file system format

    Prerequisites

    Before starting this tutorial, you should install Oracle Database.