Oracle Database 11g: Administration Workshop I

This course is designed to give students a firm foundation in basic administration of Oracle Database 11g. In this class, students learn how to install and maintain Oracle Database 11g. Students gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Students learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. The lesson topics are reinforced with structured hands-on practices.

Learn To:

	Manage users
	Manage storage structures
	Backup and Recovery
	Install and configure an Oracle database

course content details

	Exploring the Oracle Database Architecture

	Oracle Database Architecture Overview
	Interacting with an Oracle Database
	Process Architecture
	Database Storage Architecture
	Logical and Physical Database Structures
	Tablespaces and Data Files
	SYSTEM and SYSAUX Tablespaces
	Segments, Extents, and Blocks

	Preparing the Database Environment

	Tasks of an Oracle Database Administrator
	Tools Used to Administer an Oracle Database
	Installation: System Requirements
	Optimal Flexible Architecture (OFA)
	Setting Environment Variables
	Oracle Universal Installer (OUI)
	Database Configuration Options
	Advanced Installation Options

	Creating an Oracle Database

	Planning the Database
	Configuring the Listener
	Using the DBCA to Create a Database
	Password Management
	Creating a Database Design Template
	Using the DBCA to Delete a Database
	Using DBCA For Additional Tasks

	Managing the Oracle Instance

	Management Framework
	Oracle Enterprise Manager
	Initialization Parameter
	Database Startup and Shutdown
	Shutdown Modes
	Viewing the Alert History
	Using Trace Files
	Data Dictionary: Overview

	Configuring the Oracle Network Environment

	Oracle Net Services & Listener
	Establishing Net Connections
	Tools for Configuring and Managing the Oracle Network
	Net Services Administration Pages
	Naming Methods
	Directory Naming
	SGA and PGA
	When Not to Use a Shared Server

	Managing Database Storage Structures

	Storage Structures
	How Table Data Is Stored
	Anatomy of a Database Block
	Space Management in Tablespaces
	Tablespaces in the Preconfigured Database
	Actions with Tablespaces
	Oracle Managed Files (OMF)
	ASM: Concepts

	Administering User Security

	Database User Accounts
	Predefined Accounts: SYS and SYSTEM
	Administrator Authentication
	Benefits of Roles
	Predefined Roles
	Implementing Password Security Features
	Assigning Quota to Users

	Managing Schema Objects

	What Is a Schema?
	Accessing Schema Objects
	Specifying Data Types in Tables
	Creating and Modifying Tables
	Understanding Data Integrity
	Indexes & Views
	Sequences
	Temporary Tables

	Managing Data and Concurrency

	Manipulating Data Through SQL
	PL/SQL
	Administering PL/SQL Objects
	Functions, Procedures, Packages & Triggers
	Data Concurrency
	Enqueue Mechanism
	Resolving Lock Conflicts Using SQL
	Deadlocks

	Managing Undo Data

	Data Manipulation
	Transactions and Undo Data
	Undo Data Versus Redo Data
	Configuring Undo Retention
	Guaranteeing Undo Retention
	Using the Undo Advisor
	Viewing System Activity

	Implementing Oracle Database Security

	Industry Security Requirements
	Principle of Least Privilege
	Monitoring for Compliance
	Value-Based Auditing
	Fine-Grained Auditing
	DBA Auditing
	Security Updates
	Applying Security Patches