Oracle Dba Training Courses Home Courses Prices Dates Tools About Us About You News / Blog Contact

Oracle® Dba Training Courses

Oracle® Database 11g Release 2 DBA - Part I

A Five-Day Training Course

Your training is easier with Activia because we have:

Recognised national quality accreditations
Training businesses since 1995
Friendly, capable, flexible service
Dedicated training advisors
Unique tools and backup
Fiercely competitive prices !

Oracle Dba Training Courses from Activia

We'd like to discuss how we can give you the best service you will find.

Want to know more ?

Call us on 0845 230 6150

or click below to
Request a Callback

Course Content

Course Aims

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.

Who Should Attend

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

Course Outline

Introduction to Oracle Database 11G

• Relational database concepts • Database administration tasks • DBA responsibilities

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

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

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

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 Dedicated Server architecture • Overview of Shared Server architecture • Identify when to use Shared Servers and when to use Dedicated Servers

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 and EM • Startup a database and instance using SQL and EM • View alert log and trace files • View or modify initialization parameters with EM

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

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

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

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

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

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

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

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

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

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

Overview of Managing 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 • Administer ASM Files

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

Proactive Database Maintenance

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

Performance Management

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

Backup and Recovery Considerations

• 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

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

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

Enhance The Capabilities of The Database

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

Certification

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.

Follow On Courses

Oracle Database 11g Release 2 DBA - Part II

More Information

	Scheduled dates for
	Prices for
	Printer-friendly course content for Oracle® Database 11g Release 2 DBA - Part I

Related Courses

We also run the following related courses which may be of interest to you.
Click for full details of content, prices and dates:

Quality Assured Training

Click for more about our quality assured training.

Quick Course Finder

With truly hundreds of training courses to choose from, we have a Quick Course Finder that will help you to find the subject area and course you need.

Just click on any heading (in black) or section
(in blue) to go straight to where you need to be.

Click to use our Quick Course Finder

Contact Us

Activia Training
Head Office:
Regus House, 268 Bath Road
Slough, SL1 4DX

Sales: 0845 230 6150
Service: 0845 230 6159
Accounts: 0845 230 6157

[ Close ]

Why Activia for Oracle® Dba Training Courses ?

Oracle® Dba Training Courses in London, Birmingham, Manchester, Leeds, Newcastle, Bristol and the South East

Activia should be your first choice for training courses for Oracle DBA in the UK. We provide you with a full range of classes for Oracle® Database 11g Dba Training.
If you are looking for certification course in Oracle DBA, you will find that Activia offers a level of service that is unrivalled in the market, with quality, flexible 1 day Oracle® Dba Training Courses at fiercely competitive prices.

Oracle® Database 11g Dba Training

If your requirement is training in Oracle Database 11G DBA, we can provide you with training courses from introduction to advanced level at highly competitive prices. You will find that for classes for Oracle Database 11G DBA, Activia will provide more tailored, flexible and focused solutions, and this enables you to get the most from your budget using the minimum of resources.

Courses in London, the Midlands, Manchester, Leeds, Newcastle, Bristol, Berkshire, Buckinghamshire, Surrey and UK wide

We provide Oracle® Database 11g Dba Training courses all over the UK, with modern, fully equipped training centres in the following locations:

Oracle® Dba Training Courses in the City of London

Serving the City in Bank and Aldgate, and Canary Wharf from our London Bridge (SE1) centre.

Oracle® Dba Training Courses across London

Across West and South West London, in Hammersmith, Baker Street and London Victoria.

Oracle® Database 11g Dba Training in the centre of Bristol

Serving South West England, covering Bristol, Avon and Bath and Radstock in Somerset as well as Clevedon and Chepstow.

Oracle® Dba Training Courses in Birmingham City Centre

Serving Warwickshire and the Midlands, covering Birmingham, Walsall and Dudley as well as Wolverhampton, Solihull and Tamworth.

Oracle® Database 11g Dba Training in Leeds

Serving Yorkshire and the North of England, covering Leeds, Bradford and Harrogate as well as Halifax, Wakefield and Castleford.

Oracle® Dba Training Courses in Manchester

Serving Lancashire and the North West, covering Manchester, Salford, Stockport and Oldham as well as Bolton, Rochdale, Wigan, Warrington and Macclesfield.

Oracle® Dba Training Courses in Reading

Serving Berkshire and the Thames Valley, covering Reading, Theale and Newbury as well as Henley and South Oxfordshire.

Oracle® Dba Training Courses in Bracknell

Serving Berkshire and the Thames Valley, covering Bracknell, Wokingham and Ascot as well as Crowthrone, Camberley and Woking.

Oracle® Database 11g Dba Training in Slough

Serving Berkshire and the Thames Valley, covering Slough, Windsor and Maidenhead as well as High Wycombe, Uxbridge and Watford.

Oracle® Database 11g Dba Training in Milton Keynes

Serving Buckinghamshire, covering Milton Keynes, Aylesbury and Buckingham, as well as Luton, Bedford, Stevenage, St Albans and Welwyn Garden City.

Oracle® Dba Training Courses in Newcastle Upon Tyne

Serving Tyneside, also Sunderland and Gateshead, as well as North Shields and South Shields, and Whitley Bay.
Our experienced, high quality trainers will deliver your training to the highest standards and with the maximum effect.

In House Oracle® Dba Training Courses across the UK

For in house delivery of Oracle® Database 11g Dba Training, we have an established national UK network of trainers, as well as fifteen centres in London, Birmingham, Manchester, Leeds, Newcastle, Bristol, Slough, Reading, Bracknell and Milton Keynes. So you can be sure that your training courses for Oracle DBA will be delivered in a quality assured and cost effective manner. For in-house training in Oracle Database 11G DBA, you need look no further than Activia.

Click for more about Oracle DBA certification training course UK from Activia