Course Introduction

The course helps the delegates in their initial step towards becoming an Oracle Database Administrator. The Oracle course is designed for the candidates who want to learn about installing and managing an Oracle Database.

Oracle Database 11g Administration Workshop I Release 2

The candidates get a detailed overview of the Oracle Database architecture through this course. It also provides an insight into the interaction that the components of the database make while fetching or updating data to and from the database. The course prepares the candidates for the Oracle Certified Associate certification exam.

Course Content

The Oracle Database Architecture

  • An Overview Of The Oracle Database Architecture
  • Introducing The Oracle Automatic Storage Management (ASM) Architecture
  • Process Architecture
  • Memory Structures
  • Logical and Physical Structures
  • Components of ASM

Installing Oracle

  • Oracle DBA Tasks
  • Tools For Administering An Oracle Database
  • System Requirements
  • The OUI – Oracle Universal Installer
  • Installing Oracle Grid Infrastructure
  • Install Oracle Database Software
  • Unattended Installation

Oracle Database Creation

  • Plan A Database
  • Create Database With The Database Configuration Assistant(DBCA)
  • Managing Passwords
  • Creating The Database Design Template
  • Delete A Database With DBCA

The Oracle Database Instance Management

  • Starting and Stopping The Oracle Database and Its Components
  • The Oracle Enterprise Manager
  • Using SQL Plus to Access A Database
  • Changing Installation Parameters
  • Database Startup Stages –No Mount, Mount, Open
  • Shutdown Options – Normal, Immediate, Abort
  • Viewing The Alert Log
  • Using Dynamic Performance Views

The ASM Instance

  • Setting Up Initialization Parameter File for ASM Instance
  • ASM Instance – Starting Up and Shutting Down
  • Administering ASM Disk Groups

The Oracle Network Environment and Its Configuration

  • Configuring The LISTENER through Enterprise Manager
  • Enabling Oracle Restart to Monitor the LISTENER
  • Testing Oracle Net Connectivity With tnsping
  • Using Shared and Dedicated Servers

Database Storage Structure Management

  • Storage Structures
  • How Is Table Data Stored?
  • Database Block
  • Tablespaces and Space Management
  • Default and System Tablespaces In Oracle Database
  • Actions With Tablespaces
  • Oracle Managed File(OMF) System

Administering User Security

  • User Accounts in Oracle 11g
  • Administrative Accounts in Oracle 11g
  • Roles and Their Benefits
  • Predefined Roles
  • Implementing Profiles

Data Concurrency Management

  • What Is Data Concurrency?
  • Enque Mechanism In Oracle 11g
  • Resolving Locks
  • Deadlocks

Managing Undo Data

  • Data Manipulation
  • Transactions and Undo Data
  • Undo Vs Redo Data
  • Configuring Retention for Undo

Database Auditing In Oracle 11g

  • DBA Concerns For Security
  • Enabling Standard Database Auditing
  • Specifying Audit Options
  • Review Audit Information
  • Maintaining Audit Trail

Database Maintenance

  • Managing Optimizer Statistics
  • Manage AWR (Automated Workload Repository)
  • Using The Automatic Database Diagnostic Monitor
  • The Advisory Framework – Its Use
  • Setting Thresholds
  • Use Server-Generated Alerts
  • Use Automated Tasks

Performance Management

  • Performance Monitoring
  • Manage 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

  • Statement Failure
  • User Error
  • Instance Recovery and Its Phases
  • The MTTR Advisor
  • Media Failure
  • Archive Log Files

Performing Backups In Oracle 11g

  • Backup Solutions
  • Oracle Secure Backup and User-Managed Backup
  • Terms Relating To Backup
  • Recovery Manager(RMAN)
  • Configure Backup Settings
  • Backup Control File to Trace File
  • Monitoring Flash Recovery Area

Database Recovery

  • Opening A Database
  • Data Recovery Advisor
  • Recovering From A Loss Of Control File
  • Recovering From A Loss Of Redo Log File
  • Data Failures
  • Listing Data Failures
  • Data Recovery Advisory Views

Moving Data

  • Various Ways To Move Data
  • Using Directory Objects
  • Using SQL*Loader
  • Using External Tables
  • The Oracle Data Pump
  • Data Pump Export and Import

Working With Support

  • Using Enterprise Manager Support Workbench
  • Working With Oracle Support
  • Record Service Requests
  • Manage Patches

What's Included

Tutor Support

Tutor Support

Certificate

Certificate

Prerequisites

The candidates must be familiar with the following to take up this course:

  • Delegates should be knowledgeable about Oracle SQL Fundamentals introduction
  • Oracle PL/SQL is recommended as prior information on this will be beneficial during the course

Target Audience

The course is intended for the Professionals who want to master Oracle Database technologies to administer the Oracle Database.

Delegates Will Learn How To

At the end of the course candidates will be able to do the following:

  • Monitor Performance
  • Describe The Architecture of The Oracle Database
  • Install Oracle Grid Infrastructure
  • Install And Configure Oracle Database 11g
  • Configure Oracle Net Services
  • Monitor And Manage Undo Data
  • Managing Storage Structures In An Oracle Database
  • Creating And Administering User Accounts
  • Basic Backup And Recovery
  • Manage Users And Schemas
  • Manage Data Concurrency

Training Solutions at Your Convenience

Our objective has always been to address and resolve the problems of our learners in an efficient manner and improve their learning prospects. We are accustomed in providing training courses as per our learner’s convenience. We love every opportunity to use our experience to resolve difficulties confronted by learners.

Oracle Database 11g Administration Workshop I Release 2 Training Calender

Filters

arrow

Key Points

Duration: *

Tutor Support

Certificate

Oracle Database 11g Administration Workshop I Release 2

Contact Us for Date and Price

Enquire Nowup-arrow

---- OR ----

Reach Us at +44 161 884 3134 or info@bestpracticetraining.com for more information.

Oracle Database 11g Administration Workshop I Release 2

Contact us for Date and Price

Enquire up-arrow

---- OR ----

Reach Us at +44 161 884 3134 or info@bestpracticetraining.com for more information.

Optional add-ons

6 Months Access - £219

Extend your access to match your schedule.

1 Year Access - £439

Give yourself as much time as you need to complete the course

Oracle Database 11g Administration Workshop I Release 2

hours

40 Hours (on average)

days

90 Days Access

administration

40 Hours (on average)

  • Course Price

    £3295

  • add-ons Price

    £0

  • Sub-Total

    £3295

foundation-call Enquire Now

Upon purchase you will receive a password via the email you used to purchase the course.

You will then be able to login to our online learning platform with your email and password.

You will have access to the platform for 90 days from the date of purchase.

ONSITE ENQUIRY?

Fill up the form below and we will get back to you!

name name-red
email email-red
phone-call phonecall-red
house house-red
book book-red
position position-red
house house-red
comment comment-red
conference

Video Conferencing

We provide the best web conferencing platform(s) to facilitate our learners to enhance their communication with the instructor.

whiteboard

Digital Whiteboards

Our courses include the real-time demonstration of figures, diagrams and other interactive material through digital whiteboards.

messaging

Instant Messaging

During the Virtual Classroom session, learners can raise their queries through instant messaging and follow up on their doubts.

control

Participation Controls

Through participating effectively in training, individuals can easily discuss their views, mute their surroundings and virtually "raise" their hands.

Features of Our Virtual Classroom Courses

future

How to Choose and Attend Your Ideal Course?

FIND COURSES

We provide 400+ courses covering broader aspects of personal and professional development training needed by any individual. You can choose any course as per your need or requirement. Our courses are designed to fulfil the current organisational and job marketplace requirements.

search}

Select the Course

Choose the course you want to attend to fulfil your desired goals.

details}

Attend the Course

Attend the training with your prefered method at your convenience.

book}

Get Certification

Upon finishing the course, you will get the completion certificate validating your learning.

Oracle Database 11g Administration Workshop I Release 2

£ 3295 £ 3245

Benefits of Attending Our Online Courses

We provide a variety of certification programmes or courses for individuals to master a skill set and pursue a full-time career in management, IT, or other domains through the online method to provide them with the convenience of learning. Our dedicated staff works tirelessly to assure the availability of courses with eminence quality that's not found anywhere with benefits like:

skilled

Get Tailored Programmes

affordable

Quick Delivery

flexible

Scalability and Consistency

access

90 Days Access

Learn a New Skill From Onsite Training

Adaptable Courses

We provide onsite courses modified according to our client's organisational needs.

Cost-Effective Learning

Onsite training helps you to reduce travelling and venue expenses.

Learn in Familiar Surroundings

Training at your convenient place can be ideal for learning new skills.

Team Building Opportunity

Attending onsite training with your team can help to improve your team dynamics tremendously.

name

name name-red
phone-call phonecall-red
email email-red
email email-red
comment comment-red
up-arrow
LOADING