Oracle Database 11g Courses | Administration Workshop Release 2

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

Overview
Course Content
What's Included

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

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

Explore Now

Choose Mode of Training

Classroom

Online Instructor-led

Online Self-Paced

Onsite

Key Points

Duration: *

Tutor Support

Certificate

Oracle Database 11g Administration Workshop I Release 2

---- OR ----

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

Oracle Database 11g Administration Workshop I Release 2

---- 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

40 Hours (on average)

90 Days Access

40 Hours (on average)

Course Price

£3295
add-ons Price

£0
Sub-Total

£3295

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!

Video Conferencing

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

Digital Whiteboards

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

Instant Messaging

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

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

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.

Select the Course

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

Attend the Course

Attend the training with your prefered method at your convenience.

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:

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.

Best Practice Training provides specially designed training courses in 410+ locations spanning over 30+ countries globally. All our locations have state of the art facilities for the learners. Some of the Popular Locations are: