Register for Waitlist
,
This class if full now. You can register on the wait list to be notified when a seat becomes available.
Oracle Database 11g: Administration Workshop I Release 2 Training
Live Online & Classroom Enterprise Certification Training
Powered By
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.
Powered By
Looking for a private batch ?
REQUEST A CALLBACKNeed help finding the right training?
-
Certified Trainer
-
Authorized Courseware
-
Completion Certificate from ATP
-
Enterprise Reporting
-
Lifetime Access
-
CloudLabs
-
24x7 Support
-
Real-time code analysis and feedback
What is 11g: Administration Workshop I Release 2 Certification Training about?
What are the objectives of 11g: Administration Workshop I Release 2 Certification Training ?
Who is 11g: Administration Workshop I Release 2 Certification Training for?
What are the prerequisites for 11g: Administration Workshop I Release 2 Certification Training?
Available Training Modes
Live Online Training
40 HoursClassroom Training
5 DaysCourse Outline Expand All
Expand All
- ASM storage components
- Logical and physical storage structures
- Oracle Database Architecture Overview
- Oracle ASM Architecture Overview
- Process Architecture
- Memory structrues
- Oracle Universal Installer (OUI)
- Installation: System Requirements
- Tools Used to Administer an Oracle Database
- Installing Oracle Grid Infrastructure
- Installing Oracle Database Software
- Tasks of an Oracle Database Administrator
- Silent Install
- Planning the Database
- Password Management
- Using the DBCA to Create a Database
- Creating a Database Design Template
- Using the DBCA to Delete a Database
- Modify database installation parameters
- Describe database shutdown options
- Use Oracle Enterprise Manager
- Describe the stages of database startup
- Start and stop the Oracle database and components
- Access a database with SQLPlus
- View the alert log
- Access dynamic performance views
- Set up initialization parameter files for ASM instance
- Administer ASM disk groups
- Start up and shut down ASM instances
- Use Enterprise Manager to create and configure the Listener
- Identify when to use shared servers and when to use dedicated servers
- Enable Oracle Restart to monitor the listener
- Use tnsping to test Oracle Net connectivity
- Oracle Managed Files (OMF)
- Storage Structures
- Tablespaces in the Preconfigured Database
- Space Management in Tablespaces
- Actions with Tablespaces
- How Table Data Is Stored
- Anatomy of a Database Block
- Benefits of Roles
- Predefined Administrative Accounts
- Implementing Profiles
- Predefined Roles
- Database User Accounts
- Resolving Lock Conflicts
- Data Concurrency
- Deadlocks
- Enqueue Mechanism
- Undo Data Versus Redo Data
- Data Manipulation
- Transactions and Undo Data
- Configuring Undo Retention
- Enable standard database auditing
- Describe DBA responsibilities for security
- Review audit information
- Maintain the audit trail
- Specify audit options
- Use server-generated alerts
- Use automated tasks
- Manage the Automatic Workload Repository (AWR)
- Set alert thresholds
- Use the Automatic Database Diagnostic Monitor (ADDM)
- Describe and use the advisory framework
- Manage optimizer statistics
- Performance Monitoring
- Dynamic Performance Statistics
- Enabling Automatic Memory Management (AMM)
- Automatic Shared Memory Advisor
- Using Memory Advisors
- Troubleshooting and Tuning Views
- Invalid and Unusable Objects
- Managing Memory Components
- Understanding Instance Recovery
- Statement Failure
- Phases of Instance Recovery
- Archive Log Files
- Media Failure
- Part of Your Job
- User Error
- Using the MTTR Advisor
- Backup Solutions: Overview
- Monitoring the Flash Recovery Area
- Recovery Manager (RMAN)
- Terminology
- Configuring Backup Settings
- Backing Up the Control File to a Trace File
- User-Managed Backup
- Oracle Secure Backup
- Opening a Database
- Data Recovery Advisor Views
- Data Recovery Advisor
- Loss of a Control File
- Data Failures
- Loss of a Redo Log File
- Listing Data Failures
- Use SQL*Loader to move data
- Use external tables to move data
- Describe ways to move data
- Create and use directory objects
- Use Data Pump export and import to move data
- General architecture of Oracle Data Pump
- Use the Enterprise Manager Support Workbench
- Manage patches
- Work with Oracle Support
- Log service requests (SR)
Who is the instructor for this training?
The Trainer is Oracle certified Instructor with extensive domain experience, including years of experience training & mentoring professionals in the industry.
11g: Administration Workshop I Release 2 Certification Training - Certification & Exam
- SpringPeople is the Authorized Training Partner of Oracle.
- The training fees is exclusive of exam cost.
- For any queries; feel free to reach us at oracle@springpeople.com
Reviews
Previous
Next
My outlook on training changed completely after attending SpringPeople BPC training. The content, the trainer and infrastructure at SpringPeople were top notch and perfectly in tune with the industry requirements. Regardless to say, training is now something that I look forward to to. Kudos to everyone at SpringPeople!
Shweta Priya
Sony
I attended the 3-day AngularJs training at SpringPeople. The trainer was an industry veteran with vast experience in the subject. Notably, the hands-on training, and the Q&A session stood out. Overall, I found SpringPeople a great place to learn with excellent facilities and great trainers. Would recommend SpringPeople to my colleagues and friends.
Swati Singh
GE
I attended the training on API Design for Mulesoft. The sessions were well planned and value-laden. I benefited immensely from the hands-on experience enabled through virtual labs. I would like to specifically commend the efficiency of the support team who were always available to resolve my concerns.
Nikhil Kohli
Stryker
I attended the jQuery training batch, conducted by Mr. Vijay, an SME who did a thorough coverage of all the essentials. He took us through concepts such as jQuery animations, event handlers, plugins, and jQuery-UI by small programs, very easily. The sessions were useful and well structured. By the end of the training, I was well equipped to develop a SPA on Product Management System. Overall, the learning experience at SpringPeople was great!
Heena Rajan
Mindtree
