Course length: 1.0 day(s)
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.
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.
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.
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.
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