Oracle Database 11g: Administration Workshop I Release 2 (OD-11gAWR2)
About Individual Course:
About this course:
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.
- 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.
Benefits to You
Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling smooth and rapid consolidation within your Datacenter.
Create an Operational Database
You will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner. This includes performance monitoring, database security, user management and backup/recovery techniques.
This Oracle Database 11g: Administration Workshop I Release 2 course fulfills the training requirement for an Oracle Certification Path. Only instructor-led online (LVC, LWC), in-class (ILT) or Training On Demand courses fulfill the requirement. Please note that Self-Study Courses and Knowledge Center courses do not fulfill the training requirement.
The average salary of an Oracle Developer Annual is $106,225 per year.
- Install Oracle Grid Infrastructure
- Install and configure Oracle Database 11g
- Configure Oracle Net services
- Monitor and administer undo data
- Manage the database storage structures
- Create and administer user accounts
- Perform basic backup and recovery of a database
- Manage data concurrency
- Monitor performance
- Describe Oracle Database Architecture
- Database Administrators
- Java Developers
- Support Engineer
- Technical Consultant
- Technical Administrator
- Taken Oracle Introduction to SQL course or equivalent experience
- Taken Oracle PL/SQL course or equivalent experience
Virtual Instructed-Led Outline
Exploring the Oracle Database Architecture
- ASM storage components
- Logical and physical storage structures
- Oracle Database Architecture Overview
- Oracle ASM Architecture Overview
- Process Architecture
- Memory structrues
Installing your Oracle Software
- 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
Creating an Oracle Database
- Planning the Database
- Password Management
- Using the DBCA to Create a Database
- Creating a Database Design Template
- Using the DBCA to Delete a Database
Managing the Oracle Database Instance
- 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
Manage the ASM Instance
- Set up initialization parameter files for ASM instance
- Administer ASM disk groups
- Start up and shut down ASM instances
Configuring the Oracle Network Environment
- 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
Managing Database Storage Structures
- 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
Administering User Security
- Benefits of Roles
- Predefined Administrative Accounts
- Implementing Profiles
- Predefined Roles
- Database User Accounts
Managing Data Concurrency
- Resolving Lock Conflicts
- Data Concurrency
- Enqueue Mechanism
Managing Undo Data
- Undo Data Versus Redo Data
- Data Manipulation
- Transactions and Undo Data
- Configuring Undo Retention
Implementing Oracle Database Auditing
- 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
Backup and Recovery Concepts
- Understanding Instance Recovery
- Statement Failure
- Phases of Instance Recovery
- Archive Log Files
- Media Failure
- Part of Your Job
- User Error
- Using the MTTR Advisor
Performing Database Backups
- Backup Solutions: Overview
- Monitoring the Flash Recovery Area
- Recovery Manager (RMAN)
- Configuring Backup Settings
- Backing Up the Control File to a Trace File
- User-Managed Backup
- Oracle Secure Backup
Performing Database Recovery
- 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
Working with Support
- Use the Enterprise Manager Support Workbench
- Manage patches
- Work with Oracle Support
- Log service requests (SR)
|Learning Style||Virtual Classroom|
|Course Duration||5 Days|
Frequently Asked Questions About Virtual Instructor-Led Courses
I can't connect to my class, what are my options?
The link to the class is available upon logging in to your dashboard. If you are unable to see it, please contact our support team at 1-855-800-8240 and they will be happy to provide you the direct link via email or the dial in number.
I can't make it to attend to class. Can I reschedule?
Yes, you can reschedule your class. Please contact your Sales representative and they will arrange this for you. If you forgot his/her name, feel free to contact our support team at firstname.lastname@example.org or 1-855-800-8240.
Will I get my certificate upon completion?
Yes. Upon completion of the course, it will be available on your course as a Trophy Icon for you to download. If you do not see this, you will need to contact email@example.com with the following details so they can email you the certificate: Class Name, Class Date, Account Rep, and Your Email.
I cannot connect to my lab. Help!
Your Lab is accessible on the bottom part of your course. You will see a button that says "LAB". Just click it to launch the lab. Please note that some classes don’t need/require a LAB. You can verify with our support team by calling them at 1-855-800-8240 or by email at firstname.lastname@example.org. You can also check with your Instructor or the Associate Instructor if your class includes one.
What is my access code for Skillpipe?
A. Not all of the classes have or require Skillpipe. If your class includes one, please check your email as you should have received one from email@example.com. In case you do not find it in your inbox, please check the Spam / Junk folder. For any further assistance, you can call the support at 1-855-800-8240 or contact them via email at firstname.lastname@example.org.
I don't have audio. I can't hear the instructor.
Make sure you are using a compatible headset for your laptop or computer. If you don’t have a headset, you can use the built-in speaker of your laptop. Otherwise, you can use the dial in option by calling the dial in number provided in the class joining email. You may also contact support team for the dial in numbers associated for your training at 1-855-800-8240 or contact them via email at email@example.com.
How can I reach student support?
Support can be reach via phone at 1855-800-8240; via email at firstname.lastname@example.org or via chat support through the chat button on our website. Please note that support office hours will be from 8am-5pm CST Monday to Friday. Any concerns after office hours will be attended the following business day.
Get A Team Quote or Got Questions?
- Personalize learning based on competencies, goals & tools
- Expert Mentoring
- Hands on Labs & Assignments
- AI Curated Digital Book Content
- Adaptive Learning Paths
- Analytics & Benchmarking
- High certification Pass Rates – Over 200,000 people certified and more than 95% of our learners pass their certification on the first attempt