The Knowledge Academy Logo
The Knowledge Academy Logo
01344 203999 - Available 24/7

Remember: All of our classroom courses are available as live instructor-led training which you can attend from home.

Remember: All of our classroom courses are available as live instructor-led training which you can attend from home.

Send us your message.

X

Send us your message.

X

Our sales and enquiry team will get back to you as soon as possible

Please enter Name Please enter valid Email Please enter valid Phone number Please enter course

The information you provide shall be processed by The Knowledge Academy – a professional training company. Your data shall be used by a member of staff to contact you regarding your enquiry.

Please click here for privacy policy.

We cannot process your enquiry without contacting you, please tick to confirm you consent to us contacting you about your enquiry

Send us your message.

X

Our sales and enquiry team will get back to you as soon as possible

Please enter Name Please enter valid Email Please enter valid Phone number

The information you provide shall be processed by The Knowledge Academy – a professional training company. Your data shall be used by a member of staff to contact you regarding your enquiry.

Please click here for privacy policy.

We cannot process your enquiry without contacting you, please tick to confirm you consent to us contacting you about your enquiry

Oracle Database 12c: Administration - United Kingdom

Key points about this course


Duration: 5 Days*

Support: 24/7

Dates & Prices Enquire
  • Learn to administer an Oracle Database.
  • Understand how to monitor the performance of the database.
  • Manage and Maintain database security.

Available delivery methods for this course

Virtual Icon

Online Instructor-Led

Online Icon

Online Self-Paced

Onsite Icon

Onsite

Classroom Icon

Classroom

Limited Budget?

We understand that people may have limited budgets.

  • To help and support our clients we will provide limited number of 250 daily discount codes.
  • Hurry first come, first served!
  • If you miss out, enquire to get yourself on the waiting list for the next day!

animated-arrow-image-0310 Enquire for daily discount code 250 Remaining (Live Counter)

Why Home Virtual is great

With an incredibly easy to use interface, our chosen platform has been designed to make learning online simple and enjoyable. It’s amazing video & audio quality means you won’t miss a thing.

icon

Works on all devices

Attend on whichever device works best for you.
icon

Recording & transcripts

Revisit what you’ve learnt at any time.
icon

See your trainer’s screen

Your instructor can share their screen at any time to demonstrate what they’re teaching.
icon

Share documents

You can share documents with the trainer and your trainer can share with you.
icon

Virtual whiteboard

Trainers can draw on and share their whiteboard with the class at any time.
static

Key points about this course


Duration: 5 Days*

Support: 24/7

View dates & prices

Find out more

Please enter Name
Please enter valid Email
Please enter valid phone
The information you provide shall be processed by The Knowledge Academy – a professional training company. Your data shall be used by a member of staff to contact you regarding your enquiry. View privacy policy

We cannot process your enquiry without contacting you, please tick to confirm you consent to us contacting you about your enquiry

Or call us now
01344 203999

Oracle Database 12c: Administration Dates & Prices

Select your preferred delivery method

Choose a Region

Choose a Location

Choose a Month

Office Icon All Online Instructor-Led courses are delivered in real-time
Trainers Icon Easy 1 click access
Simple Icon Works on all devices
Mon 27th Apr 2020
Places available
£2995
Birmingham
Mon 11th May 2020
Places available
£3695
Bristol
Mon 11th May 2020
Places available
£4195
London
Mon 11th May 2020
Places available
£3695
Cambridge
Mon 11th May 2020
Places available
£4195
Brighton
Mon 11th May 2020
Places available
£4195
Norwich
Mon 11th May 2020
Places available
£4195
Milton Keynes
Mon 11th May 2020
Places available
£4195
Liverpool
Mon 11th May 2020
Places available
£4195
Nottingham
Mon 11th May 2020
Places available
£4195
Manchester
Mon 11th May 2020
Places available
£3695
Newcastle
Mon 11th May 2020
Places available
£4195
Maidstone
Mon 11th May 2020
Places available
£4195
Edinburgh
Mon 11th May 2020
Places available
£4195
Reading
Mon 11th May 2020
Places available
£4195
Glasgow
Mon 11th May 2020
Places available
£4195
Southampton
Mon 11th May 2020
Places available
£4195
Cardiff
Mon 11th May 2020
Places available
£4195
Leeds
Mon 11th May 2020
Places available
£4195
Belfast
Mon 11th May 2020
Places available
£4195
Sheffield
Mon 11th May 2020
Places available
£4195
Dublin
Mon 11th May 2020
Places available
€4195
Aberdeen
Mon 11th May 2020
Places available
£4195
Mon 18th May 2020
Places available
£2995
Mon 22nd Jun 2020
Places available
£2995
Aberdeen
Mon 6th Jul 2020
Places available
£4195
Maidstone
Mon 6th Jul 2020
Places available
£4195
Edinburgh
Mon 6th Jul 2020
Places available
£4195
Reading
Mon 6th Jul 2020
Places available
£4195
Glasgow
Mon 6th Jul 2020
Places available
£4195
Southampton
Mon 6th Jul 2020
Places available
£4195
Cardiff
Mon 6th Jul 2020
Places available
£4195
Leeds
Mon 6th Jul 2020
Places available
£4195
Belfast
Mon 6th Jul 2020
Places available
£4195
Sheffield
Mon 6th Jul 2020
Places available
£4195
Dublin
Mon 6th Jul 2020
Places available
€4195
Newcastle
Mon 6th Jul 2020
Places available
£4195
Birmingham
Mon 6th Jul 2020
Places available
£3695
Bristol
Mon 6th Jul 2020
Places available
£4195
London
Mon 6th Jul 2020
Places available
£3695
Cambridge
Mon 6th Jul 2020
Places available
£4195
Brighton
Mon 6th Jul 2020
Places available
£4195
Norwich
Mon 6th Jul 2020
Places available
£4195
Milton Keynes
Mon 6th Jul 2020
Places available
£4195
Liverpool
Mon 6th Jul 2020
Places available
£4195
Nottingham
Mon 6th Jul 2020
Places available
£4195
Manchester
Mon 6th Jul 2020
Places available
£3695
Mon 27th Jul 2020
Places available
£2995
Mon 24th Aug 2020
Places available
£2995
Dublin
Mon 7th Sep 2020
Places available
€4195
Aberdeen
Mon 7th Sep 2020
Places available
£4195
Maidstone
Mon 7th Sep 2020
Places available
£4195
Edinburgh
Mon 7th Sep 2020
Places available
£4195
Reading
Mon 7th Sep 2020
Places available
£4195
Glasgow
Mon 7th Sep 2020
Places available
£4195
Southampton
Mon 7th Sep 2020
Places available
£4195
Cardiff
Mon 7th Sep 2020
Places available
£4195
Leeds
Mon 7th Sep 2020
Places available
£4195
Belfast
Mon 7th Sep 2020
Places available
£4195
Sheffield
Mon 7th Sep 2020
Places available
£4195
Manchester
Mon 7th Sep 2020
Places available
£3695
Newcastle
Mon 7th Sep 2020
Places available
£4195
Birmingham
Mon 7th Sep 2020
Places available
£3695
Bristol
Mon 7th Sep 2020
Places available
£4195
London
Mon 7th Sep 2020
Places available
£3695
Cambridge
Mon 7th Sep 2020
Places available
£4195
Brighton
Mon 7th Sep 2020
Places available
£4195
Norwich
Mon 7th Sep 2020
Places available
£4195
Milton Keynes
Mon 7th Sep 2020
Places available
£4195
Liverpool
Mon 7th Sep 2020
Places available
£4195
Nottingham
Mon 7th Sep 2020
Places available
£4195
Mon 28th Sep 2020
Places available
£2995
Mon 26th Oct 2020
Places available
£2995
Milton Keynes
Mon 2nd Nov 2020
Places available
£4195
Aberdeen
Mon 2nd Nov 2020
Places available
£4195
Maidstone
Mon 2nd Nov 2020
Places available
£4195
Edinburgh
Mon 2nd Nov 2020
Places available
£4195
Reading
Mon 2nd Nov 2020
Places available
£4195
Glasgow
Mon 2nd Nov 2020
Places available
£4195
Southampton
Mon 2nd Nov 2020
Places available
£4195
Cardiff
Mon 2nd Nov 2020
Places available
£4195
Leeds
Mon 2nd Nov 2020
Places available
£4195
Belfast
Mon 2nd Nov 2020
Places available
£4195
Sheffield
Mon 2nd Nov 2020
Places available
£4195
Manchester
Mon 2nd Nov 2020
Places available
£3695
Newcastle
Mon 2nd Nov 2020
Places available
£4195
Birmingham
Mon 2nd Nov 2020
Places available
£3695
Bristol
Mon 2nd Nov 2020
Places available
£4195
London
Mon 2nd Nov 2020
Places available
£3695
Cambridge
Mon 2nd Nov 2020
Places available
£4195
Brighton
Mon 2nd Nov 2020
Places available
£4195
Norwich
Mon 2nd Nov 2020
Places available
£4195
Liverpool
Mon 2nd Nov 2020
Places available
£4195
Nottingham
Mon 2nd Nov 2020
Places available
£4195
Dublin
Mon 2nd Nov 2020
Places available
€4195
Mon 30th Nov 2020
Places available
£2995
Mon 14th Dec 2020
Places available
£2995

Complete the steps below to receive a quote or more information

How will you be funding your training?

Self funding

Company funding

Not sure

Limited Budget?

We understand that people may have limited budgets.

  • To help and support our clients we will provide limited number of 250 daily discount codes.
  • Hurry, they’re are first come, first served!
  • If you miss out, enquire to get yourself on the waiting list for the next day!

  Enquire for daily discount code 250  Remaining (Live Counter)

Key points about this course


Duration: 5 Days*

Support: 24/7


Course Information

Oracle Database 12c: Administration Course Overview

This Oracle Database 12c Administration course is designed to give the Oracle database administrator practical experience in administering, monitoring, tuning and troubleshooting an Oracle 12c 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, allocate resources with the Resource Manager and Schedule jobs.​

Oracle Database 12c: Administration Course Outline

The following subjects will be taught during this course:

Course Introduction

  • Administration and Course Materials
  • Course Structure and Agenda
  • Delegate and Trainer Introductions

Introduction to Oracle Database 12c

  • Overview of the Oracle Database 12c
  • Overview of the Oracle Cloud
  • Relational database concepts
  • Database administration tasks

Oracle Database 12c Architecture

  • Overview of the Oracle database architecture
  • The Oracle database instance
  • Oracle Database memory structures
  • Process architecture and structures
  • Server and client processes
  • The Oracle database storage architecture
  • Connect to the Oracle database instance

Administer a Database Instance

  • Administrative tools available to a DBA
  • Use SQL*Plus in Oracle to manage a database instance
  • Use SQL Developer to manage a database instance
  • Administer the database using Enterprise Manager (EM)
  • Overview of the Enterprise Manager framework
  • Access Enterprise Manager Database Express
  • The Enterprise Manager Database Express Home Page
  • Enterprise Manager Cloud Control
  • Initialization parameter files

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
  • Using the Net Configuration Assistant
  • Configure client connections with Net Manager
  • View listener configuration
  • Start and stop the Oracle listener
  • Use TNSPING to test Oracle Net connectivity
  • Connect to the database
  • Configure Net Services with Enterprise Manager

Storage Structures

  • Overview of data storage
  • The database block
  • Overview of tablespaces and datafiles
  • Use Enterprise Manager to view the storage structure of the database
  • Create and alter tablespace commands
  • Temporary tablespaces
  • Create and manage data files
  • Use OMF
  • Drop tablespaces and datafiles

Manage Users

  • Predefined database administration accounts
  • User accounts
  • Create a user account
  • User authentication
  • Change a user's password
  • Manage a user account
  • Drop a user account
  • Monitor user information
  • Terminate user sessions

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

Manage Privileges

  • Database access
  • Oracle-supplied roles
  • System and object level privileges
  • The grant and revoke commands
  • Create, modify and drop roles
  • Use predefined roles

Database Auditing

  • Overview of database security
  • Overview of database auditing
  • Security compliance
  • Standard auditing
  • Unified audit trail
  • Separation of audit responsibilities with the AUDIT_ADMIN and AUDIT_VIEWER roles
  • Configure the audit trail
  • Specify audit options

Data Concurrency and Lock Conflicts

  • Levels of locking in Oracle
  • Methods used to acquire locks
  • Data concurrency
  • Possible causes of contention
  • DML locks
  • Prevent locking problems
  • Detect lock contention
  • Resolve conflicts

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
  • Alter an undo tablespace to a fixed size

Proactive Database Maintenance

  • Database Maintenance
  • View the alert log
  • The Automatic Workload Repository
  • Statistic levels
  • The Automatic Database Diagnostic Monitoring
  • Monitor an Oracle database
  • Use the Advisors
  • Set up notification rules

Performance Management

  • Tuning information sources
  • Performance monitoring
  • Tuning activities
  • Performance planning
  • Instance tuning
  • Performance tuning methodology
  • Performance tuning data
  • Monitoring performance
  • Managing memory

SQL Tuning

  • SQL tuning
  • The Oracle Optimizer
  • SQL Plan directives
  • Adaptive execution plans
  • SQL Advisors
  • Automatic SQL Tuning results
  • Implement automatic tuning recommendations
  • SQL Tuning Advisor

Moving Data

  • Create directory objects
  • Data Pump architecture, data dictionary views, interactive mode and API's.
  • Use Data Pump to export data and import data
  • Overview of SQL Loader
  • Command line parameters
  • Record filtering
  • Control file keywords
  • Datafiles
  • SQL Loader data paths
  • External Tables

Automate Tasks with the Scheduler

  • Introduction to the Scheduler
  • Access Rights
  • Scheduler components and workflow
  • Create a Job and Job Classes
  • Create an event-based schedule

Managing Resources with Resource Manager

  • Overview of the Database Resource Manager
  • Use the Resource Manager and create resource plans
  • The default maintenance resource manager plan
  • Create Resource Plan Directives
  • Allocate resources for Resource Plans

Manage Space

  • Overview of space management
  • Block space management within segments
  • Segment types
  • Allocate extents and space
  • Row chaining and migration
  • Create tables without segments

Backup and Recovery Configuration

  • Oracle backup solutions and suggested backup strategy
  • Overview of database backup, restore and recover
  • Flashback technology
  • Types of failure
  • Tune instance recovery
  • The MTTR Advisor
  • Media failure
  • Configure a database for recoverability

Oracle Support

  • The Enterprise Manager Support Workbench
  • Register for security updates
  • Work with Oracle Support
  • My Oracle Support integration
  • Log Service Requests
  • Manage and Apply patches

Prerequisites

There is no prerequisite, although knowledge of PL/SQL would be highly beneficial.

Who should attend this Oracle Training Course?

This Oracle Database 12c Administration course has been specifically designed for anyone who needs to administer, monitor and support an Oracle 12c database.

Please arrive at the venue for 08:45am
There is no pre-requisite.
There is no exam.
The Knowledge Academy provides you with materials, an experienced instructor and refreshments.
All of our instructors have over ten years of experience.
No, there are no hidden costs.
The price for Oracle Database 12c: Administration certification in the United Kingdom starts from £1295
The Knowledge Academy is the Leading global training provider in the world for Oracle Database 12c: Administration.
Please see our Oracle Training courses available in the United Kingdom

What's included in this Oracle Training Course?

  • Delegate pack consisting of course notes and exercises
  • Manual
  • Experienced Instructor
  • Refreshments

Why choose TKA logo


Gold Tag

Best price in the industry

You won't find better value in the marketplace. If you do find a lower price, we will beat it.

Delivery Icon

Various delivery methods

Flexible delivery methods are available depending on your learning style.

Resource Icon

Resources

Resources are included for a comprehensive learning experience.

Thames Water Logo

"Really good course and well organised. Trainer was great with a sense of humour - his experience allowed a free flowing course, structured to help you gain as much information & relevant experience whilst helping prepare you for the exam"

Joshua Davies, Thames Water

Google Logo
Samsung Logo
Shell Logo

"...the trainer for this course was excellent. I would definitely recommend (and already have) this course to others."

Diane Gray, Shell

hsbc-logo
mercedes-logo