Bookings and Enquiries: 0845 230 6150
Customer Service: 0845 230 6159
We're here to help! Click for a FREE CALLBACK
Training Courses from Activia
We have hundreds of courses for every business:
find out more by clicking on a course subject below,
or by visiting our Full Course Finder.
Skills for Management
Activia Training Locations
We have seventeen centres across the UK.
Find out more by clicking on a location below,
or by visiting our main Locations Page.
Our Place or Yours? Training at Your Offices
Lots of our clients prefer us to come to them because it's easier to organise, and usually much more cost effective.
All you need is a training room, boardroom or suitable spare office. If you need laptops for a software course, we can provide them.
To see how little it can cost, click on the Prices & Dates tab at the top of this page, or locate the course using the Course Finder tab.
27-28 Clements Lane, London, EC4N 7AE
46-48 East Smithfield, London, E1W 1AW
133 Houndsditch, London, EC3A 7BX
93-95 Gloucester Place, London, W1U 6JQ
1 Ballards Lane, Finchley, London, N3 1LQ
City Hall, Victoria Street, London, SW1E 6QP
1 Victoria Square, Birmingham, B1 1BD
Two King Street, Nottingham, NG1 2AS
53 Fountain Street, Manchester, M2 2AN
47 Park Square East, Leeds, LS1 2NL
84 Queen Street, Sheffield, Yorkshire, S1 2DW
12 Mosley Street, Newcastle, NE1 1DE
Prices and Dates
Want to check on how much a course will cost,
and when public classes are scheduled?
Visit our Prices and Dates page to find out.
See prices for public (open) classes, private (closed) classes, and onsite training, where we come to your offices.
View the latest special offers, and how you can get Early Bird pricing for advance bookings.
For multiple and ongoing bookings, we have Multi Day Tickets and the
Training Days Scheme.
And under our Price Promise, we'll match any like-for-like quote.
Use our schedules, along with pricing, to help you to plan ahead.
We generally schedule three months in advance, but if you need a later date, ask us and we'll get back to you.
• View by course to see dates for any course at all locations .
• View by location to see dates at any location for all courses.
All schedules have details of the discounts available, and you can view details of the course outlines by clicking the red (i) link next to each course name.
Although we have great coverage of courses and locations,
(we can come to you, too), and very competitive pricing,
there's much more to what we do and how we work.
Why Activia? See why we believe that you won't find better value.
Quality Assurance The ethos that drives us.
History Did you know we've been around since 1995?
Types of Training
In addition to public/private/in-house training, we tailor course content free of charge, arrange ILM awards, and organise courses for technical certification.
News and Blog
Keep up to date with the News Centre and find articles of interest in our Blog.
Find the relevant numbers to call, and the quick forms to fill out, depending on your needs.
Free Online Cloud Tools
Skills Appraisal Check your skill level in a couple of minutes.
Course Creator Build a course which includes just the modules you want.
Forum Ask any question on the training you"ve had.
We don't just deliver training courses. We can provide you with help on organising training programmes and managing the whole process.
According to whether you are a small, medium or large business or a private individual, you will organise your training in different ways.
Trade Mark Acknowledgements and Terms and Conditions
Oracle® DBA Training Courses From Activia
Oracle® Database 11g Release 2 DBA - Part I
A Five-Day Training Course
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.
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
• 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
• 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
• 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 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
• 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
• 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
• 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
• 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
This course covers the main topics of the Oracle exam #1Z0-052 Oracle Database 11g: Administration I.
Follow On Courses
Oracle Database 11g Release 2 DBA - Part II
Oracle® DBA Training Courses from ActiviaWe can provide training courses for Oracle DBA at any of our seventeen centres UK wide, or we can come to your offices.
We have been training since 1995 with a philosophy of high quality, flexible and cost effective provision, so you can be confident that we have the expertise, and the experience, to give all you need with certification course in Oracle DBA.
Call us now on 0845 230 6150 or request a free callback.