Feedback

Feedback to trainingforit.co.uk

Site comment

Site ratings


Email (optional)

Content

Design

Ease of use

Overall

Oracle Database 11g Release 2 DBA - Part I

Summary

Length:

5 days

Price:

1,595 GBP excl. VAT

Training Provider:

StayAhead TrainingStayAhead Training

Location:

London

Training Method:

Open / Scheduled

Startdate:
London:	20/09/2010, 01/11/2010, 20/12/2010 31/01/2011, 14/03/2011, 09/05/2011, 13/06/2011 More dates

Request Information

Provider homepage

Contact

Save

Description of Oracle Database 11g Release 2 DBA - Part I

Oracle Database 11g Release 2 DBA - Part I Course Overview

The Oracle Database 11g Release 2 DBA - Part I course is designed to give the Oracle database administrator practical experience in setting up, administering and troubleshooting an Oracle 11g Release 1 or Release 2 database. Database administrators will gain an understanding of the architecture and processes of the Oracle database server. They will be able to ensure the integrity and availability of a company's data within the Oracle environment. They will be able to monitor the performance of the database and perform basic backup and recovery of the database.

Skills Gained

The delegate will practise:

Installing and Configuring Oracle
Creating and Managing an Oracle Database
Administering an Oracle Database
Configuring the Oracle Network Environment
Creating and Managing Database Storage Structures
Managing Redo Log Files and Control Files
Managing Schema Objects
Managing Users, Profiles, Privileges and Roles
Managing Undo Data and Temporary Segments
Monitoring and Resolving Lock Conflicts
Maintaining Database Security
Monitoring the Performance of the Database
Loading and Unloading Data
Backing Up and Recovering the Database

Who will the Course Benefit?

Anyone who needs to administer, monitor and support an Oracle 11g database.

The Oracle Database 11g Release 2 DBA - Part I course is suitable for personnel who needs to administer, monitor and support an Oracle Database 11g Release 1 or Release 2 database. This Oracle Database 11g Release 2 DBA - Part I course is suitable for users of both Release 1 and Release 2.

Course Objectives

This Oracle Database 11g Release 2 DBA - Part I course is designed to give database administrators the knowledge and skills needed to maintain successful and efficient day-to-day operations of an Oracle 11g database. The Oracle Database 11g administrator will gain practical experience in setting up, administering and troubleshooting an Oracle 11g database.

Examinations

This course covers the main topics of the Oracle exam #1Z0-052 Oracle Database 11g: Administration I.

Exams are not included as part of the course.

Before taking any exam, ensure you have the recommended experience. The Oracle website lists all exam requirements and these are updated regularly.

Requirements

Delegates should have an understanding of relational database concepts and basic operating system knowledge. They should have attended the "Oracle SQL" course or have a good working knowledge of Oracle SQL*Plus. Knowledge of PL/SQL would be beneficial.

Pre-Requisite Courses

Oracle SQL

Follow-On Courses

Oracle Database 11g Release 2 DBA - Part II

Oracle Database 11g Release 2 DBA - Part I Training Course

Course Contents - DAY 1

Course Introduction

Administration and Course Materials
Course Structure and Agenda
Delegate and Trainer Introductions

Session 1: INTRODUCTION TO ORACLE DATABASE 11g

Relational database concepts
Database administration tasks
DBA responsibilities

Session 2: ORACLE DATABASE 11g ARCHITECTURE

Oracle database architecture
The Oracle instance
Memory structures
Background processes
Server and client processes
The Oracle database
Overview of Oracle ASM architecture

Session 3: INSTALLATION AND CONFIGURATION OF AN ORACLE DATABASE

System Hardware Requirements
Optimal Flexible Architecture
Authentication methods for a database
Oracle environment variables
Install Oracle software using the Oracle Universal Installer (OUI)
Silent Install
Use the database Configuration Assistant (DBCA)
Create a database with DBCA
Manage a database with DBCA
Delete a database with DBCA
Manage Templates using DBCA
Upgrade a database using Database Upgrade Assistant (DBUA)

Session 4: ADMINISTER A DATABASE INSTANCE

Administrative tools available to a DBA
Using SQL*Plus in Oracle to manage a database
Administer the database using Enterprise Manager (EM)
Start and stop the EM Database Console
Access EM
EM navigation
Grant EM administrative privileges to a user
Overview of Oracle Restart

Session 5: CONFIGURE THE ORACLE NETWORK ENVIRONMENT

Overview of network configuration
Oracle Net Listener configuration and management
Oracle Net Naming methods
Tools for configuring and managing the Oracle network
Use Enterprise Manager to create and configure the Listener
Configure client connections with Net Manager
View listener configuration
Start and stop the Oracle listener
Enable Oracle Restart to monitor the listener
Use TNSPING to test Oracle Net connectivity
Connect to the database
Configure Net Services with Enterprise Manager
Overview of Shared Server architecture
Identify when to use Shared Servers and when to use Dedicated Servers

Oracle Database 11g Release 2 DBA - Part I Training Course

Course Contents - DAY 2

Session 6: MANAGE AN ORACLE INSTANCE

Access an Oracle database
Database authentication methods
Password file
The Startup Process
The Shutdown Process
Initialization parameters
Shutdown a database and instance using SQL
Startup a database and instance using SQL
View alert log and trace files
View or modify initialization parameters with EM

Session 7: TABLESPACE AND DATAFILE MANAGEMENT

Overview of tablespaces and datafiles
Use EM to view the storage structure of the database
Create and alter tablespace commands
Locally managed tablespaces
Dictionary managed tablespaces
Bigfile tablespaces
Temporary tablespaces
Multiple temporary tablespaces
Create tablespaces
Manage tablespaces
Use standard and non-standard block sizes
Create and manage tablespaces using OMF
Drop tablespace command

Session 8: MANAGE REDO LOGS

Redo log overview
Plan redo logs
Redo log data dictionary tables
Log switches and checkpoints
Log file maintenance
Add and drop log file members and groups
Clear a log file
Move or rename an online redo log file
Multiplex redo log files
Use EM to manage redo logs
Manage online redo log files with OMF
List redo log information

Session 9: MANAGE CONTROL FILES

The usage of the control file
The contents of a control file
Manage control files
Replace a lost or damaged control file
Mirror a control file
Standby control file
Manage control files with OMF
List control file information

Oracle Database 11g Release 2 DBA - Part I Training Course

Course Contents - DAY 3

Session 10: MANAGE SCHEMA OBJECTS

Create a new table
View the attributes and contents of a table
Understand data integrity
Define constraints
Alter tables
Create indexes
View index attributes
Create views
Create and use sequences

Session 11: MANAGE USERS

Database administration accounts
User accounts
Create a user account
Operating system authentication
Change a user's password
Manage a user account
Drop a user account
Monitor user information
Terminate user sessions
Product user profiles

Session 12: MANAGE PROFILES AND RESOURCES

Overview of user profiles
Profile resource parameters
Create profile command
Manage passwords with profiles
Control resource usage with profiles
Maintain profiles
Drop profiles

Session 13: MANAGING PRIVILEGES

Database access
Oracle supplied roles
System level privileges
Object level privileges
The grant and revoke commands
Create roles
Modify and drop roles
Control the availability of roles
Use predefined roles
Synonyms
Listing valid grants

Session 14: DATABASE AUDITING

Overview of database auditing
Auditing SYS statements
Auditing end user sessions
Statement auditing
Privilege auditing
Auditing modifications made to database objects
Audit table relocation
Auditing from Enterprise Manager

Oracle Database 11g Release 2 DBA - Part I Training Course

Course Contents - DAY 4

Session 15: UNDO MANAGEMENT

Undo data overview
Monitor and administer undo
Configure undo retention
Switch undo tablespaces
Specify the retention period
Guarantee undo retention
Retention period for flashback queries
View undo space information
Use the undo advisor
Size the undo tablespace
Manage undo with EM

Session 16: MOVING DATA

Create directory objects
Data Pump Export and Import
- Data Pump architecture
- Data Pump data dictionary views
- Data Pump interactive mode
- Data Pump API
- Use Data Pump to export data
- Use Data Pump to import data

SQL Loader
- Overview of SQL Loader
- Command line parameters
- Record filtering
- Control file keywords
- Datafiles
- SQL Loader data paths

Session 17: MANAGE AN ASM INSTANCE

Overview of Automatic Storage Management
ASM Storage Components
Set up initialization files for an ASM instance
Startup and Shutdown ASM Instances
Administer ASM disk groups

Session 18: DATA CONCURRENCY AND LOCK CONFLICTS

Levels of locking in Oracle
Methods used to acquire locks
Possible causes of contention
Deadlocks
Prevent locking problems
Detect lock contention
Resolve conflicts in an emergency

Oracle Database 11g Release 2 DBA - Part I Training Course

Course Contents - DAY 5

Session 19: PROACTIVE DATABASE MAINTENANCE

Self Monitoring Architecture
Automatic Workload Repository
Automatic Database Diagnostic Monitoring
Monitor an Oracle database
Use the Advisors
Set up notification rules

Session 20: PERFORMANCE MANAGEMENT

Tuning information sources
Identify unusable objects
Optimizer Statistics collection
Automated statistics collection
Performance metrics
Use the advisors
React to performance issues

Session 21: BACKUP AND RECOVERY CONSIDERATIONS

Backup solutions
Overview of Oracle Secure Backup
Oracle Suggested Backup Strategy
Database backup, restore and recover
Types of failure
Tune instance recovery
Checkpoints, redo log files and archive log files
Alter the ARCHIVELOG mode of a database
Configure a database for recoverability

Session 22: DATABASE BACKUPS

Types of RMAN backup
Backup sets and image copies
Perform backups using EM
Automate database backups
Configure backup settings
Catalog settings
Monitor the flash recovery area
Manage backups

Session 23: DATABASE RECOVERY

Restore and recovery operations
Recover an entire database from backup
Recover from the loss of a system critical data file
Recover from the loss of a control file
Recover from the loss of a redo log file
Data Recovery Advisor
Data Recovery Advisor Views

Session 24: WORK WITH ORACLE SUPPORT

Enterprise Manager Support Workbench
Register for security updates
Work with Oracle support
Log Service Requests
Manage patches

Request Information

Continuing studies

Follow on course: Oracle Database 11g Release 2 DBA - Part II

Expenses

£1,595.00

Description of StayAhead Training

SQL, Oracle, UNIX and Linux experts

StayAhead Training are recognised as one of the top 50 IT Training organisations in the UK and the first choice provider of UNIX, Linux, MySQL and Oracle training courses for many of the UK's most prominent organisations.

StayAhead Training was established in 1992 and now have training centres in London, Birmingham, Manchester, Leeds, Edinburgh and Bristol. Because of this, StayAhead are able to offer a large range of scheduled, tailored and onsite training. Independent of where you are based, StayAhead can help you and your firm's IT requirements be reality.

StayAhead IT Training works with some of the largest names in the IT training industry to provide courses on behalf of Parity Training, Global Knowledge, New Horizons and many more.

Specialist IT training

StayAhead Training have a formidable reputation for quality and expertise within the UNIX, Oracle, Linux and MySQL arena and enjoy an enviable position in the UK by being amongst the top IT Technical training organisations.

The UNIX curriculum not only covers standard UNIX but includes a range of Solaris, AIX, HP-UX, Linux, SUSE, LPI & Red Hat Linux training. The Oracle curriculum also has depth with courses available for DBAs, Developers and Designers. If certification is important to you then again we do not disappoint taking delegates to the level required to take the examinations in Solaris, Red Hat, SUSE, LPI, MySQL, Oracle Forms Developer and Oracle DBA. With the Oracle e-business suite growing in popularity a range of Oracle Financials courses are also available.

StayAhead's training flexibility comes from developing their own courses that include high quality course material, written not only to support the learning process, but can also act as a helpful reference guide on the delegates return to work.

In-house IT training

In addition to the public schedule of courses provided, StayAhead offer all courses in-house at a client's site, or at a StayAhead location. All courses can be tailored to meet our clients' specific needs. For courses at the client's site StayAhead can provide all the necessary hardware and software.

StayAhead's focus on IT training

StayAhead understands the best approach for such technical IT training is always to be enthusiastic, business-like, informal yet professional. Whether delegates attend a StayAhead Training scheduled course or an on-site course, each event is approached in a professional manner.

StayAhead's style of delivery is designed to foster the development of learning. Instructor led tutorials are followed by practical exercises. The style is experiential allowing delegates to take ownership and solve problems for themselves. Research shows that the pace of learning is greatly accelerated when delegates are shown HOW to solve their problems rather than just why they should.

specialist it training

Show all courses with StayAhead Training

Request information - obligation free

When filling out this form on trainingforit.co.uk, your contact information will be sent to the school you are interested in. The school will then contact you and provide you with further information through email, telephone or regular mail.

To order information from StayAhead Training, please fill out the following information:

* = Required field

Email Address*
First Name*
Last Name*
Company
Position
Town/City*
Telephone*
Start date
Message

Contact information for StayAhead Training

StayAhead Training

6 Long Lane, Barbican
EC1A 9HF London

Phone no: 020 7600 6116

www.stayahead.com

E-Mail

Contact StayAhead Training

Keywords

Oracle Database 11g Release 2 DBA - Part I Training course, Oracle Database 11g Release 2 DBA - Part I Training, Oracle Database 11g Release 2 DBA - Part I course, StayAhead Oracle Database 11g Release 2 DBA - Part I training course, Oracle Training

Back

Back | Source

Source

More Information

Top of page

Request Information

To order information from Oracle Database 11g Release 2 DBA - Part I, please fill out the following information:

What happens now?

Your right to request 'Time to Train'

Looking for training, or a course to improve your skills?

The new law 'Time to Train', gives employees the legal right to request time off work for training, and to take courses.

Good news for everybody! Learn more.

If you require help finding the right course for you - we can assist you - contact us.

Forum & discussions

article

RE: RE: Adobe training courses Hi Martin, thanks for your post! Increasingly a lot of people are interested in courses that have renowned accreditations. You might be interested in the following courses: » IT courses with Ap...

Read thread

Read thread

Tell a friend

Tell a friend about the education Oracle Database 11g Release 2 DBA - Part I at StayAhead Training.

To:
From: