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

Duration: 
5 days
Codes: 
11G,D74966GC20,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
Devon
Exeter5 7499 £7499 2019-07-08
Middlesbrough
Teesside5 7499 £7499 2019-07-08
Edinburgh
Edinburgh5 7199 £7199 2019-07-08
Oxfordshire
Oxford5 7499 £7499 2019-07-08
Dorset
Poole5 7499 £7499 2019-07-08
County Durham
Darlington5 7698 £7698 2019-07-08
Dorset
Fleet5 7698 £7698 2019-07-08
Worcestershire
Worcester5 7698 £7698 2019-07-08
Warwickshire
Warwick5 7499 £7499 2019-07-08
Yorkshire
Harrogate5 7698 £7698 2019-07-08
Dundee
Dundee5 7698 £7698 2019-07-08
Sussex
Brighton5 6699 £6699 2019-07-08
Middlesbrough
Teeside5 7698 £7698 2019-07-08
Devon
Plymouth5 7499 £7499 2019-07-08
Nottinghamshire
Nottingham5 7368 £7368 2019-07-08
Northern Ireland
Belfast5 7199 £7199 2019-07-08
Cumbria
Carlisle5 7499 £7499 2019-07-08
Leicestershire
Leicester5 7499 £7499 2019-07-08
West Sussex
Chichester5 7698 £7698 2019-07-08
Norfolk
Norwich5 7199 £7199 2019-07-08
Derbyshire
Buxton5 7499 £7499 2019-07-08
Norfolk
Norwich5 7368 £7368 2019-07-08
Dorset
Bournemouth5 7698 £7698 2019-07-08
Derbyshire
Buxton5 7698 £7698 2019-07-08
Merseyside
Liverpool5 7199 £7199 2019-07-08
Northamptonshire
Corby5 7499 £7499 2019-07-08
Devon
Exeter5 7698 £7698 2019-07-08
Hertfordshire
Watford5 7698 £7698 2019-07-08
London
London5 6799 £6799 2019-07-08
Essex
Chelmsford5 7698 £7698 2019-07-08
Northern Ireland
Belfast5 7368 £7368 2019-07-08
Kent
Canterbury5 7499 £7499 2019-07-08
Cambridgeshire
Peterborough5 7698 £7698 2019-07-08
Cumbria
Carlisle5 7698 £7698 2019-07-08
London
Heathrow5 7698 £7698 2019-07-08
Edinburgh
Edinburgh5 7368 £7368 2019-07-08
Manchester
Manchester5 6799 £6799 2019-07-08
Lancashire
Chorley5 7499 £7499 2019-07-08
Clwyd
Wrexham5 7499 £7499 2019-07-08
Staffordshire
Stoke on Trent5 7499 £7499 2019-07-08
Dublin
Dublin5 7368 £7368 2019-07-08
Glamorgan
Cardiff5 7199 £7199 2019-07-08
Surrey
Guildford5 7698 £7698 2019-07-08
Glasgow
Glasgow5 7368 £7368 2019-07-08
Midlands
Northampton5 7499 £7499 2019-07-08
Oxfordshire
Oxford5 7698 £7698 2019-07-08
Devon
Plymouth5 7698 £7698 2019-07-08
Essex
Chelmsford5 7499 £7499 2019-07-08
Manchester
Bolton5 7499 £7499 2019-07-08
Suffolk
Ipswich5 7499 £7499 2019-07-08
London
Bromley5 7499 £7499 2019-07-08
Fife
Dunfermline5 7698 £7698 2019-07-08
Hampshire
Portsmouth5 7698 £7698 2019-07-08
Midlands
Northampton5 7698 £7698 2019-07-08
Kent
Canterbury5 7698 £7698 2019-07-08
Gloucestershire
Cirencester5 7698 £7698 2019-07-08
Clwyd
Wrexham5 7698 £7698 2019-07-08
Derbyshire
Burton upon Trent5 7499 £7499 2019-07-08
Warwickshire
Warwick5 7698 £7698 2019-07-08
Bristol
Bristol5 7368 £7368 2019-07-08
Hertfordshire
Watford5 7499 £7499 2019-07-08
Manchester
Bolton5 7698 £7698 2019-07-08
Northamptonshire
Corby5 7698 £7698 2019-07-08
Middlesbrough
TBC5 7698 £7698 2019-07-08
Yorkshire
Wakefield5 7698 £7698 2019-07-08
Midlands
Birmingham5 6928 £6928 2019-07-08
Nottinghamshire
Nottingham5 7199 £7199 2019-07-08
Aberdeenshire
Aberdeen5 7199 £7199 2019-07-08
Leicestershire
Hinckley5 7698 £7698 2019-07-08
Berkshire
Reading5 7199 £7199 2019-07-08
Staffordshire
Stoke on Trent5 7698 £7698 2019-07-08
Bedfordshire
Luton5 7698 £7698 2019-07-08
Kent
Maidstone5 7368 £7368 2019-07-08
Berkshire
Reading5 6699 £6699 2019-07-08
Cambridgeshire
Cambridge5 7368 £7368 2019-07-08
Onsite
Onsite5 3500 3500 2019-07-19