Oracle Database Oracle Database 11g Administration Workshop II DBA Release 2.x

Duration: 
5 days
Codes: 
D74966GC20,11G,DBA,II
Versions: 
2.X

Overview

This course takes the database administrator beyond the basic tasks covered in the first workshop. You'll begin by gaining a much deeper understanding of possibly the most important job of a DBA: backup and recovery.Learn To:Automate DBA tasks with the Scheduler.Diagnose and repair data failures with Flashback technology.Manage space to optimize database storage and to be able to respond to growing space requirements.Monitor and manage major database components, including as memory, performance and resources.Secure the availability of your database by appropriate backup and recovery strategies.Backup RecoveryExpert instructors will also help you explore the concepts and architecture that support backup and recovery. You'll become familiar with the steps of how to carry it out in various ways and situations. Gain the skills to define and test your own backup and recovery scenarios. Learn Performance Evaluation Tuning TasksThis course will also teach DBAs how to manage memory effectively. Learn how to perform some performance evaluation and tuning tasks, including using some of the advisors.You'll also learn about the different types of flashback technologies, scheduling jobs inside and outside of the database and controlling system resource usage.

Audience

  • Database Administrators
  • Support Engineer
  • Technical Administrator
  • Technical Consultant

Skills Gained

  • Back and recover a database (and its parts) with RMAN (command-line and Enterprise Manager)
  • Use flashback technology to view past states of data and to revert either objects or the entire database back to a past state
  • Use an appropriate and flexible memory configuration for your database
  • Identify burdensome database sessions and poorly performing SQL
  • Configure the Oracle Database for optimal recovery
  • Configure the database instance such that resources are appropriately allocated among sessions and tasks
  • Schedule jobs to run inside or outside of the database
  • Use compression to optimize database storage and duplicate a database

Prerequisites

  • Oracle Database 11g Database Administration
  • Working knowledge of SQL and how to use PL/SQL packages

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

Upcoming Dates

  • GREEN This class is Guaranteed To Run.
  • SPVC - Self-Paced Virtual Class.
  • Click a Date to Enroll.
Course Location Days Cost Date
Kent
Chatham5 7698 £7698 2018-12-10
Cheshire
Chester5 7499 £7499 2018-12-10
Staffordshire
Stoke on Trent5 7698 £7698 2018-12-10
Worcestershire
Worcester5 7698 £7698 2018-12-10
Glamorgan
Cardiff5 7199 £7199 2018-12-10
Dorset
Bournemouth5 7698 £7698 2018-12-10
Bristol
Bristol5 7368 £7368 2018-12-10
Merseyside
Liverpool5 7368 £7368 2018-12-10
Surrey
Guildford5 7499 £7499 2018-12-10
Northamptonshire
Corby5 7499 £7499 2018-12-10
Leicestershire
Leicester5 7499 £7499 2018-12-10
Inverness
Inverness5 7499 £7499 2018-12-10
Buckinghamshire
Milton Keynes5 7199 £7199 2018-12-10
Manchester
Bolton5 7698 £7698 2018-12-10
Sunderland
Sunderland5 7698 £7698 2018-12-10
Buckingshire
High Wycombe5 7698 £7698 2018-12-10
Bedfordshire
Luton5 7698 £7698 2018-12-10
Gloucestershire
Cirencester5 7499 £7499 2018-12-10
Yorkshire
Leeds5 7368 £7368 2018-12-10
Berkshire
Reading5 6699 £6699 2018-12-10
Bristol
Bristol5 7199 £7199 2018-12-10
Midlands
Birmingham5 6799 £6799 2018-12-10
Midlands
Wolverhampton5 7698 £7698 2018-12-10
Kent
Canterbury5 7499 £7499 2018-12-10
Cheshire
Warrington5 7698 £7698 2018-12-10
Bedfordshire
Bedford5 7698 £7698 2018-12-10
Midlands
Solihull5 7698 £7698 2018-12-10
Warwickshire
Warwick5 7499 £7499 2018-12-10
Cambridgeshire
Peterborough5 7698 £7698 2018-12-10
Middlesbrough
Teeside5 7698 £7698 2018-12-10
Cheshire
Crewe5 7499 £7499 2018-12-10
Wiltshire
Swindon5 7698 £7698 2018-12-10
Kent
Canterbury5 7698 £7698 2018-12-10
Edinburgh
Edinburgh5 7199 £7199 2018-12-10
Kent
Maidstone5 7368 £7368 2018-12-10
Manchester
Bolton5 7499 £7499 2018-12-10
Sussex
Brighton5 7199 £7199 2018-12-10
Somerset
Bath5 7698 £7698 2018-12-10
Oxfordshire
Oxford5 7499 £7499 2018-12-10
Lincolnshire
Lincoln5 7698 £7698 2018-12-10
Midlands
Derby5 7698 £7698 2018-12-10
Buckingshire
High Wycombe5 7499 £7499 2018-12-10
Surrey
Guildford5 7698 £7698 2018-12-10
London
Bromley5 7499 £7499 2018-12-10
Nottinghamshire
Nottingham5 7199 £7199 2018-12-10
Yorkshire
Doncaster5 7698 £7698 2018-12-10
Aberdeenshire
Aberdeen5 7199 £7199 2018-12-10
Hampshire
Portsmouth5 7698 £7698 2018-12-10
Dorset
Fleet5 7698 £7698 2018-12-10
Manchester
Manchester5 6799 £6799 2018-12-10
Lancashire
Chorley5 7698 £7698 2018-12-10
Cheshire
Crewe5 7698 £7698 2018-12-10
Yorkshire
Sheffield5 7368 £7368 2018-12-10
Cambridgeshire
Cambridge5 7199 £7199 2018-12-10
Derbyshire
Burton upon Trent5 7499 £7499 2018-12-10
Cumbria
Carlisle5 7698 £7698 2018-12-10
Hampshire
Southampton5 6699 £6699 2018-12-10
Derbyshire
Burton upon Trent5 7698 £7698 2018-12-10
Buckinghamshire
Milton Keynes5 7368 £7368 2018-12-10
Yorkshire
Leeds5 7199 £7199 2018-12-10
Leicestershire
Hinckley5 7499 £7499 2018-12-10
Dublin
Dublin5 7368 £7368 2018-12-10
Berkshire
Reading5 7199 £7199 2018-12-10
Inverness
Inverness5 7698 £7698 2018-12-10
Kent
Tonbridge5 7698 £7698 2018-12-10
Cheshire
Chester5 7698 £7698 2018-12-10
Cambridgeshire
Cambridge5 7368 £7368 2018-12-10
Norfolk
Norwich5 7199 £7199 2018-12-10
Wiltshire
Swindon5 7499 £7499 2018-12-10
Midlands
Wolverhampton5 7499 £7499 2018-12-10
Aberdeenshire
Aberdeen5 7368 £7368 2018-12-10
Devon
Plymouth5 7698 £7698 2018-12-10
Dorset
Poole5 7698 £7698 2018-12-10
Suffolk
Ipswich5 7499 £7499 2018-12-10
Devon
Exeter5 7698 £7698 2018-12-10
Onsite
Onsite5 2550 £2550 2019-01-15
Onsite
Onsite5 2500 £2500 2019-01-15