Small logo image
Hamburger menu icon
    call:   0333 6000 111

Oracle® DBA Training Courses from Activia


Home Breadcrumb separator Quick Course Finder Breadcrumb separator Oracle Breadcrumb separator Oracle Database 11g Release 2 DBA - Part I

Oracle Dba Training Courses
Quality, flexible training in Oracle Database 11G DBA

Hamburger navigation


This is a five-day training course structured into 24 modules


This intensive, hands-on 5 day 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.


The Oracle Database 11g Release 2 DBA - Part I course is intended for anyone who needs to administer, monitor and support an Oracle 11g database. The course is also suitable for personnel who need to administer, monitor and support an Oracle Database 11g Release 1 or Release 2 database.
Delegates who wish to attend this course should have an understanding of relational database concepts and good operating system knowledge. They should have attended the Oracle SQL course or have a good working knowledge of Oracle SQL. Knowledge of PL/SQL would be beneficial.
Pre-Requisite Course is:
Oracle SQL

MODULE 1:  Introduction to Oracle Database 11G
Topics covered:
  • Relational database concepts
  • Database administration tasks
  • DBA responsibilities
MODULE 2:  Oracle Database 11G Architecture
Topics covered:
  • Oracle database architecture
  • The Oracle instance
  • Memory structures
  • Background processes
  • Server and client processes
  • The Oracle database
  • Overview of Oracle ASM architecture
MODULE 3:  Installation and Configuration of An Oracle Database
Topics covered:
  • 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
MODULE 4:  Administer a Database Instance
Topics covered:
  • 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
MODULE 5:  Configure The Oracle Network Environment
Topics covered:
  • 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 Dedicated Server architecture
  • Overview of Shared Server architecture
  • Identify when to use Shared Servers and when to use Dedicated Servers
MODULE 6:  Manage An Oracle Instance
Topics covered:
  • Access an Oracle database
  • Database authentication methods
  • Password file
  • The Startup Process
  • The Shutdown Process
  • Initialization parameters
  • Shutdown a database and instance using SQL and EM
  • Startup a database and instance using SQL and EM
  • View alert log and trace files
  • View or modify initialization parameters with EM
MODULE 7:  Tablespace and Datafile Management
Topics covered:
  • 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
MODULE 8:  Manage Redo Logs
Topics covered:
  • 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
MODULE 9:  Manage Control Files
Topics covered:
  • 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
MODULE 10:  Manage Schema Objects
Topics covered:
  • 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
MODULE 11:  Manage Users
Topics covered:
  • 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
MODULE 12:  Manage Profiles and Resources
Topics covered:
  • Overview of user profiles
  • Profile resource parameters
  • Create profile command
  • Manage passwords with profiles
  • Control resource usage with profiles
  • Maintain profiles
  • Drop profiles
MODULE 13:  Managing Privileges
Topics covered:
  • 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
MODULE 14:  Database Auditing
Topics covered:
  • 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
MODULE 15:  Undo Management
Topics covered:
  • 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
MODULE 16:  Moving Data
Topics covered:
  • 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
MODULE 17:  Overview of Managing An Asm Instance
Topics covered:
  • 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
  • Administer ASM Files
MODULE 18:  Data Concurrency and Lock Conflicts
Topics covered:
  • 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
MODULE 19:  Proactive Database Maintenance
Topics covered:
  • Self Monitoring Architecture
  • Automatic Workload Repository
  • Automatic Database Diagnostic Monitoring
  • Monitor an Oracle database
  • Use the Advisors
  • Set up notification rules
MODULE 20:  Performance Management
Topics covered:
  • Tuning information sources
  • Identify unusable objects
  • Optimizer Statistics collection
  • Automated statistics collection
  • Performance metrics
  • Use the advisors
  • React to performance issues
MODULE 21:  Backup and Recovery Considerations
Topics covered:
  • Oracle 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
MODULE 22:  Database Backups
Topics covered:
  • 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
MODULE 23:  Database Recovery
Topics covered:
  • 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
MODULE 24:  Enhance The Capabilities of The Database
Topics covered:
  • Enterprise Manager Support Workbench
  • Register for security updates
  • Work with Oracle support
  • Log Service Requests
  • Manage patches


Scheduled Public Classes

The simplest and most cost-effective option for 1, 2 or 3 delegates.

Oracle Database 11g Release 2 DBA - Part I
Prices for scheduled classes at our centres
1st delegate
2nd delegate
3rd+ delegates
£1,899 each
NOTE: Lower prices for additional delegates are subject to booking at the same time, and cannot be cancelled.
Dates and Venues for our Public Classes

View scheduled dates for the course you want in the table below.
Then click on 'Book now' against the class you want to book.

Oracle Database 11g Rel. 2 DBA - Part I
Nov 30, 2015
London Barbican
Book now
General Information

All training courses use the latest content, qualified and experienced trainers, and provide delegates with the best learning experience. Training is interactive and classroom-based, and the ability to ask questions reinforces knowledge acquisition during the class.

Class Sizes

Maximum class sizes vary, but there is always adequate time for delegates to ask questions of the instructor.

How to book
Course, dates and delegate numbers
Decide on the course you want, the date(s) you can attend, and the number of delegates involved
Call us
if at any time you want help or advice, or you want to book on the telephone, just call us on 0333 6000 111 to speak to one of our friendly training advisors

Note: With non-credit card bookings you must sign and return a Booking Form before we can confirm your training.

Also note: If you are a private individual you must pay by credit card at the time of booking.

The confirmation process
Course places allocated
Your place is allocated, along with workbooks (and lunches if it's at our centre)
Booking confirmation
You receive an official confirmation, with joining instructions (and directions if it's at our centre)
Training invoice
You receive a VAT invoice

Note: Please allow 1 - 2 working days for your confirmation and invoice.

What happens on the day

If you are coming to our centre, dress code is smart casual.   The timetable is as follows:













Note: break times can vary according to the needs of the training, and course duration for smaller class sizes are usually shorter because fewer delegates have fewer questions !

What you get

With your training course from Activia, you get a free workbook, so you can review and revise afterwards to reinforce your knowledge.


Call us on:
0333 6000 111


We can enhance your skills with Oracle® DBA Training Courses from Activia at any of our twelve training centres UK wide, or we can come to your offices: if you have groups of three or more staff who need training, this is a very convenient, flexible and cost effective option.

We have been training business all over the UK since 1995 and have continually developed our philosophy of high quality, flexible and results-driven provision of training courses for Oracle DBA.   This means you can be confident that we have the expertise, and the experience, to give you a great return on your investment in certification course in Oracle DBA.

Why not contact us today to see what we can do for you?

White logo

Stay In Touch!

Google logo
LinkedIn logo
Twitter logo
FaceBook logo

Contact Details

Activia Training

Locations icon Address: Head Office, Regus House,
268 Bath Road
Slough, Berkshire SL1 4DX

Phone icon Sales:           0333 6000 111

Phone icon Service:       0333 6000 555

Phone icon Accounts:    0333 6000 777

Nationwide coverage
Click to view all locations

Back to top button
About Us
    Useful Information
Free Tools
    Speedy Quote
    Course Creator
    Skills Appraisal
    Blended Solutions with free e-learning
    Log in to your Dashboard
Contact Us
    Callback Request
    More Information
    Schedule your own class
    Free eDirectory
Microsoft Access
Microsoft Excel
Microsoft Office
Microsoft Outlook
Microsoft Powerpoint
Microsoft Project
Microsoft Publisher
Microsoft Visio
Microsoft Word
Crystal Reports
Management Skills
Managing People
Supervision & Teams
HR and Coaching
Accounts and Finance
Project Management Essentials
HR and Recruitment
Training & Coaching
Selling Skills
Presentation Skills
Sales Management
Negotiation Skills
Business Writing Skills
Minute Taking Made Easy
Professional Telephone Skills
Time Management
Communication Skills
Customer Service
Receptionist Skills