All classes are taught LIVE by seasoned instructors. * 9.6 of 10 (over 22 k student survey results - 2023)

Find A Class in Your City:

Oracle Training: Fundamentals - 11g

Email this page | Print this page

Oracle Training:  Fundamentals - 11g

* This course is only offered privately at your office (group or 1on1) -- click here for online quote request or call us at 877-760-0078.


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.

Oracle Training: 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.

Oracle Training: 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