• Introduction
  • Course Details
  • Target Audience
  • Register
  • FAQ
  • Trainer
24x7 Online
Oracle Database 11g: Administration Workshop I
eLearning Courseware, Practice Exam, and Live Mentoring
Oracle Database 11g: Administration Workshop I
  • To understand how an Oracle Database functions, it is important to gain a basic understanding of its major components. This course identifies the major architectural components of the Oracle Database 11g Release 2, explains memory structures, describes background processes, and explores the logical and physical storage structures. In addition, this course describes the role of a database administrator (DBA) and the tasks and tools required for this role. This course also covers how to plan for the Oracle Grid Infrastructure and Oracle Database 11g software installations, as well as how to do the installation using the Oracle Universal Installer. Passing this exam will earn the learner Oracle Certified Associated (OCA). TechFetch and Skillsoft TechFetch Academy partnered with Skillsoft to bring finest quality training content, known for in-depth treatment of concepts. This course is modular, designed with finest navigation controls, allowing you the flexibility to pace your learning. Courseware includes instructor-led demonstrations and visual presentations that allow students to develop their skills based on real world scenarios explained by the instructor. You will encounter several feedback loops to help you assess where you are strong and where you need additional review. Practice exam & Test engine This course comes with Test-Prep module, which comes with practice test bank and test engine. This will allow you to pick one topic and then get questions just on that subject.
    Unlimited access to LIVE experts. No extra cost. You can reach mentors via Chat or by E-mail. Live Chat is available on all working days 8AM-7PM CT. More value at less cost. This course gives you all of the benefits of a live class at just a fraction of the cost.
Course Details
1. Database Architecture and Installation
  • Identify key characteristics of Oracle Database 11g's grid computing technology
  • Identify the main architectural components of Oracle Database 11g
  • Identify the components of Oracle Database 11g's memory structures
  • Recognize how the Oracle Database 11g process architecture works
  • Recognize how information is stored and structured within Oracle Database 11g's storage architecture
  • Identify tasks and tools required to administer Oracle Database 11g
  • Plan the Oracle Database 11g installation
  • Install the Oracle Grid Infrastructure
  • Install the Oracle Database 11g software
  • Install Oracle Grid Infrastructure
  • Install Oracle Database 11g software
2. Database Creation and Instance Management
  • Plan a database
  • Choose the character set for the database
  • Configure a database using the DBCA
  • Access a database instance using various Oracle tools
  • Recognize the scope and capabilities of database initialization parameters
  • Modify database initialization parameters
  • Configure database startup and shutdown options
  • Assess database performance and metadata information
  • Use Oracle Restart to manage components
  • Create a new database
  • Stop and start the database
3. The ASM Instance and Network Connectivity
  • Recognize the primary processes of the ASM instance
  • Manage the ASM instance
  • Identify the features of ASM disks
  • Manage ASM disk groups
  • Configure and manage Oracle Net Services and the Oracle Net Listener using Enterprise Manager
  • Configure database connections
  • Manage the ASM instance and network connectivity
4. Storage Structures and User Security
  • Recognize how table data is stored
  • Create a new tablespace
  • Manage the storage of information in a database
  • Create and authenticate database user accounts
  • Grant and manage privileges
  • Create and manage roles
  • Implement user profiles and user security
  • Create a new tablespace
  • Create and configure profiles
  • Create a role
5. Managing Concurrency, Undo, and Auditing
  • Manage locks and data concurrency
  • Manage undo data operations to allow users to roll back transactions
  • Recognize how auditing is used to secure a database
  • Enable and review audit information and maintain the audit trail
  • Resolve lock conflicts
  • Undo data in a database
  • Configure database auditing
6. Managing Database Maintenance and Performance
  • Manage Oracle optimizer statistics
  • Manage Automatic Workload Repository statistics
  • Use the Automatic Database Diagnostic Monitor and advisors
  • view and configure automated maintenance tasks
  • Manage alerts
  • Monitor and analyze the performance of the database
  • Maintain the database by viewing information and implementing a given recommendation
  • Manage database performance
7. Backup and Recovery
  • Identify the types of failure that can occur in a database
  • Configure a database for instance recovery
  • Prevent media failure
  • Configure ARCHIVELOG mode
  • Identify strategies for backing up a database
  • Use RMAN to configure, schedule, manage, and view backup operations
  • Perform data recovery
  • Prepare a database for recovery
  • Perform a database backup
  • Perform recovery on a database
8. Moving Data and Oracle Support
  • Identify the features of Oracle Data Pump
  • Move data between Oracle Databases using Oracle Data Pump
  • Use SQL*Loader to move data from external files into an Oracle Database
  • Use external tables to access data in external sources
  • Use Enterprise Manager Support Workbench to investigate, report, and resolve issues
  • Work with My Oracle Support
  • Manage patches
  • Move data using the Data Pump
  • Load data using SQL*Loader
  • Use Support Workbench
Target Audience
  • Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.
Course Fee
90 days 180 days
$179 $269
Register for course Register for course
Frequently Asked Questions (FAQ)
1. How long do I have access to the course materials?

You have unlimited access to the materials, for the duration of your purchase period, viz 3 months, 6 months, 12 months etc. If no purchase period is mentioned, you will have 12-months access.

2. What is the refund policy on the course?

Our standard policy is that purchases are considered final, and no refunds are possible.

3. Do I have to download any software to view material?

No. If you have an internet connection, you should be able to access courses from Windows and Mac OS devices, with the following environments:

  • Windows 7 or above, with Internet Explorer v8.0 JRE 1.6.0_17 (or above)
  • Mac 10.6 with Safari 4.0.3 and JRE 1.6.0_17 (or above)
4. Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, you should be able to access courses from Windows and Mac OS devices, with the following environments:

  • Windows 7 or above, with Internet Explorer v8.0 JRE 1.6.0_17 (or above)
  • Mac 10.6 with Safari 4.0.3 and JRE 1.6.0_17 (or above)

We are currently working to bring some courses that can be downloaded on your local devices as well. Please stay tuned.

5. Do I have to be registered user of TechFetch.com to subscribe to TechFetch Academy?

No. You are welcome to be member of TechFetch Academy even if you are not a registered user TechFetch.com. We recommend that you post your resume on TechFetch.com though. It is free. Who knows what pleasant surprises await you there!

6. Will I get a certificate after completing this course?

Not now. However, very soon, you will have the option to export learning credits to TechFetch.com job board, which will be displayed as a configurable badge.

7. How do I pay for the courses?

You can purchase courses, securely, using any of the major credit cards (Visa / Mastercard / Discover).

8. Do you offer testing for certification exams?

No. we offer certification-prep only. You will need to register with one of the authorized testing centers for actual exams.

9. How long will a course take to complete?

It varies from student to student, and from course to course. However, on average, it is prudent to budget around 50-hours per single exam.

10. Who do I contact for any clarifications?

Our helpdesk team is available on all working days from 8AM – 6PM New York Time (Eastern Standard Time).

Helpdesk Phone : +1-703–544-2058; Helpdesk Email: Academy@techfetch.com

Trainer
  • Skillsoft is a pioneer in the field of learning with a long history of innovation. Skillsoft provides cloud-based learning solutions for our customers worldwide, who range from global enterprises, government and education customers to mid-sized and small businesses.
    Skillsoft’s courses, books and videos have been developed by industry-leading learning experts to ensure that they build talent and develop a more knowledgeable, productive and valuable workforce. Skillsoft’s customer support teams draw on a wealth of in-house experience and a comprehensive learning e-library to develop both packaged and custom learning programs tailored to customers' needs.
    Over 5,000 corporate clients and more than 13,000,000 learners worldwide benefit from Skillsoft’s high-value training content and hands-on support to assist them, in maximizing their ongoing learning success.
  • Awards & recognition Skillsoft consistently earns recognition from our industry's best-known publications and analyst firms. Some recent honors: 2013
    • TrainingIndustry.com Top 20 Training Outsourcing Companies & Top 20 Leadership Training Companies.
    • Best of Elearning! Awards – Finalist.
    2012
    • Workforce Management's Training Providers Hot List.
    • TrainingIndustry.com Top 20 Content Development Companies, Top 20 Learning Portal Companies, Top 20 Leadership Training Companies, Top 20 IT Training Companies & Top 20 Workforce Development Providers.
    • Chief Learning Officer Learning in Practice Awards: Gold Winner for Excellence in Social Learning.
    • Military Training Technology's Top Simulation and Training Companies.
    • Best of Elearning! Best Leadership Develop and Best IT Content.
    • Brandon Hall Excellence in Technology Silver Award for Best Advance in Learning Management Technology.
    • Gold Steve Winner, Sales Department of the Year (Public Services & Education).
    • LearnX Asia Pacific First Place Winner, Best eLearning Design: Interactive Scenario.
    2011
    • LearnX Asia Pacific Platinum Winner, Best Training Provider.
    • TrainingIndustry.com Top 20 IT Training Companies.
    • Elearning! Magazine Best Social Learning Tool & Best IT Content.
    • Military Training Technology magazine's Top Training & Simulation Companies.
    • Brandon Hall Excellence in Technology Silver Award for Best Advance in Learning Management Technology.
    2010
    • Elearning! Magazine Excellence Awards for Best Learning Management System, Best Leadership Development Program, & Best Soft Skills Content; Best Compliance Content, Best IT Content.
    • TrainingIndustry.com Top 20 IT Training Companies & Top 20 Learning Portal Companies.
    • Brandon Hall Research Bronze Medal in Best Advance in Social Learning Technology.
    • LearnX Asia Pacific Platinum Winner, Best Training Provider.
    • AIIA iAwards Victoria State Award Winner, Elearning.
    • Military Training Technology magazine's Top Training & Simulation Companies.
    2009
    • LearnX Asia Pacific Gold Winner, Best Training Provider.
    • Brandon Hall Research Gold Medal for Best Advance in Technology for Virtual-Classroom Training or Conferencing.
    • TrainingIndustry.com Top 20 IT Training Companies.
    • Elearning! and Government Elearning! Magazine's Best IT Content and Best Soft Skills Training.