Oracle 10g/11g Database Administration I Part 1

Course Description

 

In this Oracle database administration course, Part 1 of a two part online training series, you will explore how an Oracle Database applies 'grid computing' to multiple computers to provide fast, efficient, secure data storage and manipulation that easily scales to thousands of clients. In this Oracle training, students learn how to install, administer and maintain an Oracle 10g or 11g database in an effective and efficient manner. Topics such as the interaction among Oracle components, an understanding of Oracle's architecture and user management are covered. Students learn to install, administer and maintain an Oracle 10g or 11g database in an effective and efficient manner. Performance monitoring, database security and backup and recovery techniques are covered. This course will assist those preparing to take the Oracle Certified Associate (OCA) certification examination.

 

Once you have completed Oracle 10g/11g Database Administration I Part 1 the next course is this series is Oracle 10g/11g Database Administration I Part 2. The Oracle 10g/11g Database Administration I Part 2 course will continue to build your knowledge in shared server, database performance monitoring, database maintenance, how to use the undo management feature, how to deal with locking conflicts and finishing up with backups and database recovery. Click here to learn more about Oracle 10g/11g Database Administration I Part 2.

 

In This Course You Will Learn How To:

  • Explain Oracle's architectural components
  • Demonstrate how to use Oracle's universal installer and configuration assistants
  • Identify the different interfaces to an Oracle database
  • Describe the different database control and storage structures
  • Explain how to use schema and user management tools
  • Contrast the different techniques for importing data to an Oracle database and exporting data from an Oracle database
  • Describe PL/SQL declarations, code and exceptions
  • Discuss Oracle's password security and database auditing features
  • Configure Oracle's default user account features
  • Configure and tune Oracle's Listener and Net Services features
  • Learn how to establish, tune and monitor Oracle's Shared Server configuration
  • Explain how to manually and automatically monitor the performance of an Oracle database
  • Describe how to use Oracle's advisors to help tune and monitor database performance
  • Show how to tune and administer Oracle's database undo management
  • Discover how Oracle detects and resolves locking conflicts
  • Learn the roles of control files, data files and redo log files in database backup and recovery
  • Describe the implications of running your database in NOARCHIVELOG mode and ARCHIVELOG mode on database backup and recovery
  • Discuss the different types of database backups
  • Differentiate the differences between user-managed and server-managed backups
  • Contrast the differences between database restoration and database recovery
  • Illustrate the importance of database incarnations in database recovery

 

Prerequisites

 

You need to have equivalent Oracle 9i database experience or have taken the following courses:

  • Oracle 10g/11g: Introduction to SQL
  • Oracle 10g/11g: Advanced SQL
  • Oracle 11g PL/SQL Programming Part 1
  • Oracle 11g PL/SQL Programming Part 2

 

 

 

Outline

 

Module 00: Oracle 10g/11g Database Administration I Part 1 Online Training - Course Introduction

 

 

 

Module 01: Architectural Components Part 1

 

  • Physical Structure

 

  • Memory Structure

 

  • Process Structure

 

  • Logical Structure

 

 

 

Module 02: Architectural Components Part 2

 

  • Stages of a SQL Statement

 

  • Defining the Database, Instance and Server

 

 

 

Module 03: Administration and Installation Tools for Oracle Server Part 1

 

  • Administration Tools

 

  • The Oracle Universal Installer

 

 

 

Module 04: Administration and Installation Tools for Oracle Server Part 2

 

  • SQL*Plus

 

  • Configuration Assistants

 

 

 

Module 05: Database Architecture and Creation Part 1

 

  • Optimal Flexible Architecture

 

  • Syntax

 

  • Demo: Create User and Drop User

 

  • Demo: Create Table and Drop Table

 

 

 

Module 06: Database Architecture and Creation Part 2

 

  • Automatic Storage Management

 

  • Oracle Architectures

 

 

 

Module 07: Database Interfaces

 

  • SQL Interface

 

  • Java Interface

 

  • C++ Interface

 

  • PL/SQL Interface

 

 

 

Module 08: Database Control Part 1

 

  • Controlling the Agents

 

  • Exercise: Multithreaded agents

 

  • Controlling the Database

 

  • Startup

 

 

 

Module 09: Database Control Part 2

 

  • Shutdown mechanisms

 

  • Exercise: Database Startup and Shutdown

 

  • Controlling the listener

 

  • Exercise: Controlling the Listener

 

 

 

Module 10: Storage Structures

 

  • Tablespace Creation

 

  • Exercise: Tablespace Creation

 

  • Exercises: Tablespace Object Space Utilization

 

  • Tablespace Management

 

  • Exercise: Restoring Objects from the Recycle Bin

 

  • Tablespace Information

 

  • Exercise: Tablespace Information

 

 

 

Module 11: User Management Part 1

 

  • Managing Users

 

  • Exercises: New User

 

  • Managing Roles

 

  • Exercise: Locking / Unlocking Accounts

 

  • Exercise: Working with Profiles

 

  • Managing Privileges

 

  • Demo: Find the Database Statistics

 

  • Demo: Validate System Objects

 

  • Exercise: Common System Privileges

 

 

 

Module 12: User Management Part 2

 

  • Common Object Privileges

 

  • Exercises: Object Privileges

 

  • Taking Away Privileges

 

  • Exercises: Taking Away Privileges

 

  • Creating and Managing Roles

 

  • Exercise: Creating and Managing Roles

 

 

 

Module 13: Schema Object Management

 

  • Managing Tables

 

  • Exercise: Modifying Tables

 

  • Managing Constraints

 

  • Exercise: Working with Constraints

 

 

 

Module 14: Schema Object Management Part 2

 

  • Managing Indexes

 

  • Exercise: Constraint-Related Indexes

 

  • Managing Views

 

 

 

Module 15: Data Management using SQL*Loader Part 1

 

  • Using SQL*Loader to Import Information

 

  • Control Files

 

  • Quiz

 

 

 

Module 16: Data Management using SQL*Loader Part 2

 

  • Managing Data Loads

 

  • Tuning Data Loads

 

  • Direct Data Loading

 

  • Demo: Enable ARCHIVELOAD Mode

 

  • Exercise: Using SQL*Loader to Load a Table

 

 

 

Module 17: Data Management Using the Data Pump

 

  • Data Pump Export

 

  • Exercises: Performing a Data Pump Export

 

  • Data Pump Import

 

  • Exercise: Performing a Data Pump Import

 

  • Demo: Using the Data Pump

 

 

 

Module 18: PL/SQL Overview

 

  • PL/SQL Declarations

 

  • Quiz

 

  • PL/SQL Code

 

 

 

Module 19: PL/SQL Exceptions

 

  • Creating Exceptions

 

  • Handling Exceptions

 

  • Built-In Exceptions

 

  • Exercises: Exception Handling

 

 

 

Module 20: Database Security Management Part 1

 

  • Authentication

 

  • System Schema

 

  • System Privilege

 

 

 

Module 21: Database Security Management Part 2

 

  • Password Security –Profiles

 

  • Password Storage and Verification

 

  • Exercise: Utilizing Local Password Storage

 

  • Exercises: Protecting the SYS Password

 

 

 

Module 22: Database Security Management Part 3

 

  • Database Auditing

 

  • Auditing Tables and Records

 

  • Exercise: Database Auditing

 

 

 

Module 23: Oracle Net Services Part 1

 

  • Oracle Net Services Overview and Concepts

 

  • Oracle Listener Creation and Configuration

 

  • Exercises: Listener Security

 

 

 

Module 24: Oracle Net Services Part 2

 

  • Oracle Net Manager

 

  • Exercise: Starting Oracle Net Manager

 

  • Using TNSPING