Oracle Database 11g Introduction
Course number: CGIOD11GI40
Course Description:
A good Oracle database administrator must gain and maintain a mastery of his or her environment, its physical structures, and its maintenance routines. An administrator must understand the data being stored well enough to tune and improve performance, to anticipate and prevent data failure, and to recover lost data should a failure occur. In this course, you will develop an advanced understanding of complex Oracle database concepts, maintenance and recovery routines, and database management. You have an Oracle installation and need to broaden your knowledge of advanced Oracle administrative functionality so that you can maintain the healthiest possible database.
Course Objective:
You will identify and use all the basic features of Oracle Database 11g.
Performance-Based 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.
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.
Course Outline
- Topic 1A: Overview of Basic Database Concepts
- Topic 1B: Explore Oracle Database 11g
- Topic 2A: Examine Memory
- Topic 2B: Examine Logical Storage Structures
- Topic 2C: Examine Physical Storage Structures
- Topic 2D: Examine Backup and Recovery Processes
- Topic 3A: Use Data Definition Language (DDL) Commands
- Topic 3B: Use Data Manipulation Language (DML) Commands
- Topic 3C: Use Transaction Control Language (TCL) Commands
- Topic 4A: Create Indexes
- Topic 4B: Apply Sequences
- Topic 4C: Use Views
- Topic 4D: Use Synonyms
- Topic 5A: Use PL/SQL Blocks
- Topic 5B: Work with Packages
- Topic 5C: Create Triggers
- Topic 5D: Use Object Relational Databases
- 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
Live Online