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
Skills Gained
Describe Oracle Database Architecture
Install and configure Oracle Database 11g
Configure Oracle Net services
Manage the database storage structures
Create and administer user accounts
Perform basic backup and recovery of a database
Manage users and schemas
Manage data and concurrency
Monitor and administer undo data
Backup and recover a database
Monitor performance
Use the database diagnostic monitor
Who Can Benefit
Database Administrators
Database Designers
Developer
Support Engineer
Technical Administrator
Prerequisites
Working knowledge of SQL
Oracle Database 11g: Introduction to SQL
Suggested Next Courses
Oracle Database 11g: Administration Workshop II
Code:
11g-DBA1
Length:
5 days
Type:
Instructor-Led
Certified By:
Oracle
Tuition:
$3,000
This course is taught by Certified Oracle instructors. There is a difference. Learn More
This course is in the following categories. Click the categories to find similar courses and topics of interest.
There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links below. We can also contact you when the course is scheduled in your area.
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
When you take a certified course with ExitCertified, you are learning from
the creators of the products you use. Our commitment to your IT
community, along with our authorization to deliver certified courses,
ensures you receive a premium training experience.
