Oracle Database 11g: Administration I Professional Training Solutions Ltd

Price: EUR 2,195

Location: Westland Square Pearse St Dublin 2 Ireland
Duration: 5 Days

Course details

The overall objective of this course is to allow the student to gain the skills necessary for day-today administration of an Oracle database. This course is the starting point for Oracle database administrators and also sets the foundation for advanced administrator training and certification. Major tasks to be considered within this course are:

Software installation and the creation of new databases.
An in-depth exploration of the database architecture, including memory, process and data structures, and the management of those structures.
Management of database files.
Specialized facilities intended to maximize performance of enterprise-scale transactional applications, such as the shared SQL and PL/SQL cache, the result cache, the database buffer cache, and other similar components.
Management of security policies and procedures, including administration of user accounts, roles, privileges and profiles.
Utilization of advanced self-tuning and self-management capabilities, including the use of Oracle-Managed Files, database Advisors and other components of the Management Framework.
Performance monitoring, problem troubleshooting, and resolving lock and conflict issues.
Using the Oracle Enterprise Manager and SQL interfaces for administration tasks.
Control over database support services, including the Database Control, Oracle Net and others.
A primer on backup and recovery structures and strategies.
Operating system-specific considerations for various platforms, especially Linux and MS Windows Server.

Prerequisites:

Many students taking this course have familiarity with system administration and administration of other non-Oracle databases, and this is helpful though not mandatory. Specific course prerequisites for this course are:

ORACLE DATABASE 11G: SQL FUNDAMENTALS – COMPLETE LIBRARY
ORACLE DATABASE 11G: PROGRAM WITH PL/SQL – COMPLETE LIBRARY

Enterprise Edition Installation:

Identify System Requirements
The Optimal Flexible Architecture (Ofa)
Oracle_Base
Oracle_Home
Configure The Installation Environment
Enterprise Edition Installation
Dbca

The Administrator Interface :

Enterprise Manager Tour
Using Em Sql Worksheet
Duties Of A Database Administrator
Exploring The Oracle Database Architecture: General

The Oracle Enterprise Architecture:

Exploring The Oracle Database Architecture: Instance Memory :

What Is An Oracle Database Instance?
More About The System Global Area (Sga)
About The Pga
Managing Memory

Exploring The Oracle Database Architecture: Instance Processes:

Instance Background Processes
Sql Execution Processes

Creating An Oracle Database:

Create A New Database
Configure An Existing Database
Drop A Database
Manage Dbca Templates
Manually Create A Database

Managing The Database Instance :

Configuring A Linux Environment
Starting & Stopping Database Control
Starting & Stopping The Database Listener
Starting & Stopping The Database Instance
More About The Database Files

Manage Database Storage Structures: Tablespaces:

About Tablespaces
Tablespace Management
Drop Tablespace
Alter Tablespace

Manage Database Storage Structures: Advanced Tablespaces:

More About Temporary Tablespaces
About Temporary Tablespace Groups
More About Permanent Tablespaces
More About Bigfile Tablespaces
More About The Sysaux Tablespace

Manage Database Storage Structures:

Data Files & Temp Files
Managing Data Files
Managing Temp Files
Enable Oracle-Managed Files (Omf)

Managing Undo Data:

About Undo Space Management
Configure Automatic Undo Management
Undo_Management
Undo_Tablespace
Undo_Retention
Guarantee Undo Retention
Monitor Undo Space
Use The Undo Advisor

Network Environment: Oracle Shared Servers:

Shared Servers Architecture
Configure Shared Servers
Monitor Shared Servers
V$Shared_Server
V$Shared_Server_Monitor
V$Session
V$Circuit
V$Dispatcher & V$Dispatcher_Config
V$Queue

Security: Implementing Database Security :

Database System Privileges
Database Object Privileges
Administrator Auditing Of Database Activity
Enhanced Default Security Settings

Security: Administering User Security :

Create & Manage Database Accounts
Grant & Revoke Database Privileges
Resource Limits Via Profiles
Alter Profile
Drop Profile
Password Management Via Profiles
About Role-Based Security
With Admin Option
Alter User...Default Role
Set Role
Enhanced Default Security Settings

Moving Data: Sql Loader:

Loader Concepts
Control File Options
Load Methods
Using The Em Interface

Moving Data: Export & Import:

Manage Directory Objects
About The Data Pump Architecture
Data Pump Export
Data Pump Import
Data Pump Data Dictionary Views
Using The Em Interface

Database Maintenance & Performance Management:

The Management & Advisory Framework
Manage The Automatic Workload Repository
Automatic Database Diagnostic Monitor
Use Metrics & Alert Thresholds
Automatic Maintenance Tasks

Managing Concurrency & Locks:

About Latches & Locks
Manage & Monitor Latches
Manage & Monitor Locks
V$Lock
V$Locked_Object
V$Session
V$Session_Wait
Dba_Blockers & Dba_Waiters
Dba_Dml_Locks & Dba_Ddl_Locks
Dml_Locks

Backup & Recovery Concepts & Configuration :

About Database Backup & Recovery Structures
Managing Redo Data

Updated on 08 November, 2015

Course Location

Show map Location Westland Square Pearse St Dublin 2 Ireland

About Professional Training Solutions Ltd

Professional Training is a group of experienced specialists providing specific training and consultancy solutions, within Management Skills, I.T. systems, Human Restheirce Development, Credit Management, Sales, Finance and Engineering.

they believe in using a combination of tailored, flexible approaches and real-life business knowledge to develop and provide techniques and solutions for immediate implementation.

their recent projects include supporting major initiatives for clients in utilities, telecoms, manufacturing and software, covering:

restructuring for competitiveness

productivity improvements through updating work processes to match new technology

managing outstheircing

strategic financial planning and engineering

their methodology is to:

Work closely with clients to understand and help them prioritise their needs

Design and deliver the best mix of training activities and consultancy to establish the competencies required

Provide ongoing coaching to sustain the improved practices and processes

they create relevant, targeted, enjoyable, and interactive, training sessions which are designed to improve the retention of information by participants and create a clear link from the training to the workplace. This creates a planned, visible improvement in key business indicators such as productivity, motivation, loyalty, employee retention, and ultimately, profit.

their collaborative approach builds long-term relationships with clients. Together, they can deal effectively with the inevitable challenges all businesses face.

See all Professional Training Solutions Ltd courses

View more Virtual classroom training for Oracle online courses See all Oracle Courses

See all current Administration and Secretarial jobs in Ireland

Are you from Professional Training Solutions Ltd ? Claim your course!

Courses you can instantly connect with... Do an online course on Oracle starting now.