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
Virtual
Virtual5 6495 £6495 2019-01-28
London
London5 2805 £2805 2019-02-04
London
London5 2805 £2805 2019-02-04
London
London5 2805 £2805 2019-02-04
Virtual
Virtual5 6495 £6495 2019-02-25
Midlands
Wolverhampton5 7698 £7698 2019-03-11
Midlands
Birmingham5 6928 £6928 2019-03-11
Essex
Colchester5 7698 £7698 2019-03-11
Kent
Chatham5 7698 £7698 2019-03-11
Essex
Chelmsford5 7499 £7499 2019-03-11
Bristol
Bristol5 7199 £7199 2019-03-11
Worcestershire
Worcester5 7698 £7698 2019-03-11
Somerset
Bath5 7499 £7499 2019-03-11
Bedfordshire
Bedford5 7698 £7698 2019-03-11
Buckinghamshire
Milton Keynes5 7368 £7368 2019-03-11
Yorkshire
Wakefield5 7698 £7698 2019-03-11
Devon
Plymouth5 7499 £7499 2019-03-11
Glamorgan
Cardiff5 7368 £7368 2019-03-11
Oxfordshire
Oxford5 7698 £7698 2019-03-11
Sussex
Brighton5 7199 £7199 2019-03-11
Kent
Maidstone5 7199 £7199 2019-03-11
Gloucester
Gloucester5 7698 £7698 2019-03-11
Yorkshire
Leeds5 7199 £7199 2019-03-11
Inverness
Inverness5 7499 £7499 2019-03-11
Bristol
Bristol5 7368 £7368 2019-03-11
Norfolk
Norwich5 7368 £7368 2019-03-11
London
Bromley5 7499 £7499 2019-03-11
London
Gatwick5 7698 £7698 2019-03-11
Hampshire
Southampton5 7199 £7199 2019-03-11
Suffolk
Ipswich5 7499 £7499 2019-03-11
Warwickshire
Warwick5 7698 £7698 2019-03-11
Leicestershire
Hinckley5 7499 £7499 2019-03-11
Cambridgeshire
Cambridge5 7368 £7368 2019-03-11
Dorset
Bournemouth5 7499 £7499 2019-03-11
Derbyshire
Burton upon Trent5 7698 £7698 2019-03-11
Berkshire
Bracknell5 7698 £7698 2019-03-11
Midlands
Coventry5 7698 £7698 2019-03-11
West Sussex
Chichester5 7698 £7698 2019-03-11
Middlesbrough
Teesside5 7499 £7499 2019-03-11
Wiltshire
Swindon5 7499 £7499 2019-03-11
Yorkshire
Doncaster5 7698 £7698 2019-03-11
Nottinghamshire
Nottingham5 7199 £7199 2019-03-11
Manchester
Manchester5 2500 £2500 2019-03-11
Cumbria
Carlisle5 7698 £7698 2019-03-11
Aberdeenshire
Aberdeen5 7199 £7199 2019-03-11
Berkshire
Slough5 7698 £7698 2019-03-11
Surrey
Guildford5 7698 £7698 2019-03-11
London
London5 7698 £7698 2019-03-11
Dorset
Poole5 7698 £7698 2019-03-11
Cumbria
Carlisle5 7499 £7499 2019-03-11
Warwickshire
Warwick5 7499 £7499 2019-03-11
Midlands
Derby5 7698 £7698 2019-03-11
Hampshire
Southampton5 6699 £6699 2019-03-11
Dundee
Dundee5 7698 £7698 2019-03-11
Northern Ireland
Belfast5 7368 £7368 2019-03-11
Kent
Canterbury5 7499 £7499 2019-03-11
Derbyshire
Burton upon Trent5 7499 £7499 2019-03-11
Fife
Dunfermline5 7698 £7698 2019-03-11
Leicestershire
Leicester5 7698 £7698 2019-03-11
Cambridgeshire
Cambridge5 7199 £7199 2019-03-11
Dublin
Dublin5 7199 £7199 2019-03-11
Clwyd
Wrexham5 7499 £7499 2019-03-11
London
Heathrow5 7698 £7698 2019-03-11
Dorset
Fleet5 7698 £7698 2019-03-11
Wiltshire
Swansea5 7698 £7698 2019-03-11
Yorkshire
Sheffield5 7199 £7199 2019-03-11
Buckinghamshire
Milton Keynes5 7199 £7199 2019-03-11
Midlands
Wolverhampton5 7499 £7499 2019-03-11
Dorset
Poole5 7499 £7499 2019-03-11
Midlands
Northampton5 7698 £7698 2019-03-11
Gloucestershire
Cirencester5 7698 £7698 2019-03-11
West Sussex
Chichester5 7499 £7499 2019-03-11
Staffordshire
Stoke on Trent5 7698 £7698 2019-03-11
Hampshire
Portsmouth5 7698 £7698 2019-03-11
Cheshire
Chester5 7499 £7499 2019-03-11
Onsite
Onsite5 2500 £2500 2019-03-18
Onsite
Onsite5 2550 £2550 2019-03-18