Verify Affiliation

Oracle Database 11g: Administration I (1Z0-052)

This Database 11g Administration training gives you a firm foundation in basic database administration, including how to install and maintain an Oracle database. Learn about architecture and how the database components work and interact. This Oracle Database 11g: Administration Workshop I Release 2 course explores the fundamentals of basic database administration. Expert Oracle University instructors will reinforce topics with structured hands-on practices that will prepare you for the corresponding Oracle Certified Associate exam.

Learn to:

  • Install Oracle Grid Infrastructure
  • Create and manage users
  • Install and configure an Oracle Database
  • Create and manage storage structures
  • Administer the Oracle Database
  • Understand the Oracle database architecture and how its components work and interact with one another
  • Perform backup and recovery

Oracle Database 11g: Administration II (1Z0-053)

This Database 11g Administration training teaches you to perform backup and recovery, and diagnose and repair data failures. Manage major database components like memory, performance, and resources using Oracle Database 11g. This Oracle Database 11g: Administration Workshop II Release 2 training takes the database administrator beyond the basic tasks covered in the first workshop. You’ll begin by gaining a deep understanding of the most important responsibilities a DBA has: performing backup and recovery.

Learn to:

  • Diagnose and repair data failures with Flashback technology
  • Manage space to optimize database storage so you can respond to growing space requirements
  • Monitor and manage major database components, including memory, performance, and resources
  • Secure the availability of your database through appropriate backup and recovery strategies
  • Automate DBA tasks with the Scheduler

Click on Semester for more detail.

Oracle Database 11g: Administration I (1Z0-052)
Oracle Database 11g Administration Course

Oracle Database 11g Administration Course

Topic Details
Exploring the Oracle Database Architecture
  • Oracle Database Architecture Overview
  • Oracle ASM Architecture Overview
  • Process Architecture
  • Memory structures
  • Logical and physical storage structures
  • ASM storage components
Heading
  • Installing your Oracle Software
  • Tasks of an Oracle Database Administrator
  • Tools Used to Administer an Oracle Database
  • Installation: System Requirements
  • Oracle Universal Installer (OUI)
  • Installing Oracle Grid Infrastructure
  • Installing Oracle Database Software
  • Silent Install
Creating an Oracle Database
  • Planning the Database
  • Using the DBCA to Create a Database
  • Password Management
  • Creating a Database Design Template
  • Using the DBCA to Delete a Database
Managing the Oracle Database Instance
  • Start and stop the Oracle database and components
  • Use Oracle Enterprise Manager
  • Access a database with SQLPlus
  • Modify database installation parameters
  • Describe the stages of database startup
  • Describe database shutdown options
  • View the alert log
  • Access dynamic performance views
Manage the ASM Instance
  • Set up initialization parameter files for ASM instance
  • Start up and shut down ASM instances
  • Administer ASM disk groups
Configuring the Oracle Network Environment
  • Use Enterprise Manager to create and configure the Listener
  • Enable Oracle Restart to monitor the listener
  • Use tnsping to test Oracle Net connectivity
  • Identify when to use shared servers and when to use dedicated servers
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)
Administering User Security
  • Database User Accounts
  • Predefined Administrative Accounts
  • Benefits of Roles
  • Predefined Roles
  • Implementing Profiles
Managing Data Concurrency
  • Data Concurrency
  • Enqueue Mechanism
  • Resolving Lock Conflicts
  • Deadlocks
Managing Undo Data
  • Data Manipulation
  • Transactions and Undo Data
  • Undo Data Versus Redo Data
  • Configuring Undo Retention
Implementing Oracle Database Auditing
  • Describe DBA responsibilities for security
  • Enable standard database auditing
  • Specify audit options
  • Review audit information
  • Maintain the audit trail
Database Maintenance
  • Manage optimizer statistics
  • Manage the Automatic Workload Repository (AWR)
  • Use the Automatic Database Diagnostic Monitor (ADDM)
  • Describe and use the advisory framework
  • Set alert thresholds
  • Use server-generated alerts
  • Use automated tasks
Performance Management
  • Performance Monitoring
  • Managing Memory Components
  • Enabling Automatic Memory Management (AMM)
  • Automatic Shared Memory Advisor
  • Using Memory Advisors
  • Dynamic Performance Statistics
  • Troubleshooting and Tuning Views
  • Invalid and Unusable Objects
Backup and Recovery Concepts
  • Part of Your Job
  • Statement Failure
  • User Error
  • Understanding Instance Recovery
  • Phases of Instance Recovery
  • Using the MTTR Advisor
  • Media Failure
  • Archive Log Files
Performing Database Backups
  • Backup Solutions: Overview
  • Oracle Secure Backup
  • User-Managed Backup
  • Terminology
  • Recovery Manager (RMAN)
  • Configuring Backup Settings
  • Backing Up the Control File to a Trace File
  • Monitoring the Flash Recovery Area
Performing Database Recovery
  • Opening a Database
  • Data Recovery Advisor
  • Loss of a Control File
  • Loss of a Redo Log File
  • Data Failures
  • Listing Data Failures
  • Data Recovery Advisor Views
Moving Data
  • Create and use directory objects
  • Use SQL*Loader to move data
  • Use external tables to move data
  • General architecture of Oracle Data Pump
  • Use Data Pump export and import to move data
Working with Support
  • Use the Enterprise Manager Support Workbench
  • Work with Oracle Support
  • Log service requests (SR)
  • Manage patches

Oracle Database 11g Administration Course

Core Concepts and Tools of the Oracle Database

Topic Details
The Oracle Database Architecture: Overview Introduction to the architecture of the Oracle database.
ASM Storage Concepts Explaining the concepts behind Oracle ASM storage.
Connecting to the Database and the ASM Instance Methods for connecting to both Oracle Database and ASM instances.
DBA Tools Overview Overview of the tools used for database administration tasks.
Configuring for Recoverability
  • Backup and Recovery (BR): purpose, typical tasks and terminology
  • Using the Recovery Manager (RMAN)
  • Configuring the database for BR operations
  • Configuring Archivelog mode
  • Configuring backup retention
  • Configuring and using a Flash Recovery Area (FRA)
Using the RMAN Recovery Catalog
  • Tracking and storing backup information
  • Setting up a Recovery Catalog
  • Recording backups
  • Using RMAN Stored Scripts
  • Managing the Recovery Catalog (Backup, Export, Import, Upgrade, Drop, and Virtual Private Catalog)
Configuring Backup Settings
  • Configuring and managing persistent settings for RMAN
  • Configuring Autobackup of control file
  • Backup optimization
  • Advanced Configuration Settings: Compressing Backups
  • Configuring Backup and Restore for very large files (Multisection)
Creating Backups with RMAN
  • Backup types
  • Create and Use
  • Backup Sets and Image Copies
  • Whole Database Backup
  • Fast Incremental Backup
  • Configure Backup Destinations
  • Duplexed Backup Sets
  • Archival Backups
Restore and Recovery Task
  • Restoring and recovering
  • Causes of file loss
  • Automatic Tempfile Recovery
  • Recovering from the loss of a Redo Log Group
  • Recovering from a Lost Index Tablespace
  • Re-creating a Password Authentication File
  • Complete and Incomplete Recovery
  • Other Recovery Operations
Using RMAN to Perform Recovery
  • Complete Recovery after loss of a Critical or Noncritical Data File
  • Recovering image copies and switching files
  • Restore and Recovery of a Database in NOARCHIVELOG Mode
  • Incomplete Recovery
  • Performing Recovery with a Backup Control File
  • Restoring from Autobackup: Server Parameter File and Control File
  • Restoring and Recovering the Database on a New Host
Monitoring and Tuning RMAN
  • Monitoring RMAN Jobs
  • Balance Between Speed of Backup Versus Speed of Recovery
  • RMAN Multiplexing
  • Synchronous and Asynchronous I/O
  • Explaining Performance Impact of MAXPIECESIZE, FILESPERSET, MAXOPENFILES, and BACKUP DURATION
Using Flashback Technology I
  • Overview and Setup
  • Using Flashback Technology to query data
  • Flashback Table
  • Flashback transaction query
  • Performing Flashback Transaction Backout
  • Oracle Total Recall
  • Flashback Drop and the Recycle Bin
Diagnosing the Database
  • Data Recovery Advisor (DRA)
  • Block corruption
  • Automatic Diagnostic Repository (ADR)
  • Health monitor
  • The ADR Command-Line Tool, ADRCI
Performing Flashback Database
  • Configuring Flashback Database
  • Performing Flashback Database Operations
  • Monitoring Flashback Database
Managing Memory
  • Oracle Memory Structures
  • Oracle Database Memory Parameters
  • Using Automatic Memory Management
  • Automatic Shared Memory Management
  • Using Memory Advisors
  • Using Data Dictionary Views
Managing Database Performance
  • Tuning activities
  • Using statistic preferences
  • Optimizer statistics collection
  • Monitor the performance of Sessions and Services
  • Automatic Workload Repository (AWR)
  • Describing the Benefits of Database Replay
Managing Performance by SQL Tuning
  • SQL Tuning and SQL Advisors
  • Using SQL Tuning Advisor
  • SQL Access Advisor
  • SQL Performance Analyzer Overview
Managing Resources
  • Overview and Concepts
  • Accessing and creating resource plans
  • Creating Consumer Group

Fees and Durations

Fee: Rs.24,000/- (Twenty Four Thousand only)
Breakup of Fee: Rs.12,000/- per month
Duration: Two and a half Months
Days: Three Days a Week (Alternate Days)

OraSoft Training Institute, Copyright © 1999 - 2025, All rights reserved.

Design By Visual Innovative

Open chat
Powered by Joinchat
Hello
Can we help you?