冠通|棋牌

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

    Send us your message.

    X

    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

    Classroom Icon

    Classroom

    Virtual Icon

    Live Virtual

    Online Icon

    Online

    Onsite Icon

    Onsite

    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

    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 Attend your course from the office or home
    Trainers Icon Interactive support from experienced trainers
    Simple Icon Simple to setup and easy to use on any device
    Mon 9th Mar 2020
    Places available
    £2995
    Mon 27th Apr 2020
    Places available
    £2995
    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
    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
    Aberdeen
    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
    Mon 18th May 2020
    Places available
    £2995
    Mon 22nd Jun 2020
    Places available
    £2995
    Dublin
    Mon 6th Jul 2020
    Places available
    €4195
    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
    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
    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
    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
    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
    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
    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
    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
    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
    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

    Key points about this course


    Duration: 5 Days*

    Support: 24/7


    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
  • 竞猜平台

    幸运彩票官网注册首页

    星力电玩城手机捕鱼

    同乐城tlc88官方网站

    点击进入优游

    即送彩金的娱乐平台

    www.336688www.vwin

    竞猜平台

    天津体育彩票网官网