Oracle Database 11g: Introduction


Course length: 1.0 day(s)

Course Description

Course Objective: You will identify and use all the basic features of Oracle Database 11g.

Target Student: This course is designed for any database professional whose company is considering transition to Oracle or is about to move to Oracle databases.

Prerequisites: To ensure your success, we recommend that you be familiar with relational database concepts and the fundamentals of databases or take this Element K course or have equivalent experience: Relational Database Design.

Familiarity with the Windows environment, Microsoft Office applications, or similar Office productivity applications is also desired.

Hardware Requirements

To use Oracle 11g Release 1 (Standard Edition), the following hardware is required:

  • Intel® Pentium® of 800 MHz or higher processor.
  • 2 GB of RAM or more.
  • 6 GB of available hard-disk space or more.
  • CD-ROM or DVD drive.
  • Super VGA or higher resolution monitor.
  • Mouse or a compatible pointing device.
  • A projection system to display the instructor’s computer screen.

Software Requirements

Each computer requires the following software:

  • Oracle 11g Release 1 (Standard Edition) server software.
  • Oracle 11g Release 1 (Standard Edition) client software.
  • Microsoft® Office™ Professional 2007 or higher.
  • JDK 6.0 (64 bit) or later.
  • SQL Developer.

Course Objectives

Upon successful completion of this course, students will be able to:

  • identify the fundamental concepts of databases and the Oracle 11g RDBMS.
  • identify the various components in the Oracle 11g architecture.
  • use SQL commands in the Oracle 11g interface and execute simple queries to manage data.
  • create other database objects such as indexes, sequences, views, and synonyms.
  • work with PL/SQL commands to manipulate data.
  • administer a database to improve its performance.

Course Content

Lesson 1: Fundamentals of Oracle Database 11g

Topic 1A: Overview of Basic Database Concepts
Topic 1B: Explore Oracle Database 11g

Lesson 2: Overview of the Oracle Architecture

Topic 2A: Examine Memory Structures
Topic 2B: Examine Logical Storage Structures
Topic 2C: Examine Physical Storage Structures
Topic 2D: Examine Backup and Recovery Processes

Lesson 3: Using SQL Commands to Work with Tables

Topic 3A: Use Data Definition Language (DDL) Commands
Topic 3B: Use Data Manipulation Language (DML) Commands
Topic 3C: Use Transaction Control Language (TCL) Commands

Lesson 4: Creating Other Database Objects

Topic 4A: Create Indexes
Topic 4B: Apply Sequences
Topic 4C: Use Views
Topic 4D: Use Synonyms

Lesson 5: Using PL/SQL Commands to Manipulate Data

Topic 5A: Use PL/SQL Blocks
Topic 5B: Work with Packages
Topic 5C: Create Triggers
Topic 5D: Use Object Relational Databases

Lesson 6: Administering a Database

Topic 6A: Create a Database
Topic 6B: Manage Database Memory
Topic 6C: Manage Database Processes
Topic 6D: Work with Tablespaces
Topic 6E: Managing Users and Permissions


邮箱地址不会被公开。 必填项已用*标注