Oracle Training: Fundamentals - 11g

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