Over a Decade of Serious Learning
for Ambitious Minds.
* 9.3 of 10 (over 13 k student survey results - 2015)
1-877-760-0078
Request a quote

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