Course Introduction

Administration Workshop Ed 2 is a five-day course.This course provides the learning of Oracle database architecture to the delegates. Through this Oracle qualification, the candidates will gain the required knowledge and skills about Oracle database instances, configuring of Oracle network environment, along with performing database maintenance.

Oracle Database 12c: Administration Workshop Ed 2

  • Creating database instances and storage structures.
  • Managing instances and storage structures.
  • Configuring network environment
  • Monitoring database
  • Using workbench

Course Content

An overview of Oracle Database 12c

    • An introduction to Oracle Database 12c
    • An overview of Oracle Cloud and HR Schema

Discovering the Oracle Database Architecture

    • An introduction to architecture
    • Configuring and connecting instances
    • Process Architecture, Structures and Startup Sequence

Managing the Database Instance

    • An Introduction to Oracle Database Management Tools
    • What is Enterprise Manager Management Framework?
    • Signing in to Oracle Enterprise Manager Database Express
    • Using the Enterprise Manager Database Express Home Page
    • Using Enterprise Manager Cloud Control
    • Using SQL*Plus and SQL Developer
    • Initialization Parameter Files

Configuring the Oracle Network Environment

    • An overview of Oracle Net Services and Net Listener
    • Launching Oracle Network Connections
    • Tools for arranging and managing the Oracle Network
    • Using the Listener Control Utility
    • Using Oracle Net Manager and Enterprise Manager Cloud Control

Management of Database Storage Structures

    • Understanding Storage of Data
    • Database Block Contents
    • Exploring the Storage Structure
    • Creating a New Tablespace
    • Overview of Tablespaces Created by Default
    • Managing Tablespaces
    • Viewing Tablespace Information
    • Using Oracle Managed Files

Administering User Security

    • Users of database accounts
    • Predefined Administrative Accounts
    • Create user and profiles
    • Authenticate
    • Unlock user account and Reset Password
    • Roles and privileges

Managing Data Concurrency

    • Locks overview
    • Locking and Enqueue Mechanism
    • DML Locks
    • Concurrency of data
    • Lock Conflicts

Managing Undo Data

    • Undo Data Overview
    • Transactions and Store Undo Information
    • Compare undo Data and Redo Data
    • Manage undo
    • Configure and Guarantee Undo Retention
    • Change an Undo Tablespace to a Fixed Size

Implementing Oracle Database Auditing

    • Responsibilities segregation
    • Security of database
    • Monitor for Compliance
    • Standard Database Auditing
    • Unified Audit Data Trail
    • Separation of Duties for Audit Administration (AUDIT_ADMIN and AUDIT_VIEWER roles)
    • Audit trail configuration
    • Specifying Audit Options

Executing Database Maintenance

    • An overview of Database Maintenance
    • Observing the Alert History
    • Introducing Automatic Workload Repository (AWR) and Statistic Levels
    • An introduction to Automatic Database Diagnostic Monitor (ADDM)

Managing Performance

    • Monitoring Performance
    • Tuning Activities
    • Performance Preparation
    • Tuning of Instances
    • Performance Tuning Method
    • Performance Tuning Data
    • Monitoring Presentation
    • Handling Memory

Managing Performance: SQL Tuning

    • An overview of SQL Tuning and Oracle Optimizer
    • Recognizing SQL Plan Directives and Adaptive Execution Plans
    • SQL Advisors
    • Automatic SQL Tuning Results
    • Implementing Automatic Tuning References

Handling Resources by Using Database Resource Manager

    • An overview of Database Resource Manager
    • Fundamentals of Database Resource Manager
    • Describing Maintenance Resource Manager Plan
    • Understanding Resource Manager Workflow

Automating Tasks by Using Oracle Scheduler

    • Streamlining Management Tasks
    • Understanding a Simple Job
    • Understanding Core Components and Basic Work Flow
    • Persistent Lightweight Jobs
    • Using a Time-Based or Event-Based Schedule
    • Creating a Time-Based Job and Event-Based Schedule
    • An overview of Space Management and Block Space Management
    • Introducing Free Space Management within Segments
    • The various kinds of Segments
    • Assigning Extents
    • Allocating Space
    • Creating Tables without Segments

Backup and Recovery Concepts

    • Groupings of Failures and Flashback Technology
    • What is Instance Recovery and its phases?
    • Tuning Instance Recovery
    • Using the MTTR Advisor

Data Movement

    • An overview of architecture
    • Understanding Oracle Data Pump and SQL*Loader
    • Working with Oracle Support
    • Using the Support Workbench and Enterprise Manager
    • Working with Oracle Support and integration
    • Examining an Issue
    • Logging Service Requests and Managing Patches

The Oracle Support

    • Making use of the Oracle Support Workbench
    • Using the Oracle EM
    • Using the Oracle Support
    • Exploring Issues
    • Recording Service Requests
    • Handling Patches
    • Applying Patches
  • An Overview of the Oracle Database Cloud Service
    • Database as a Service Architecture – It’s Features and Tools
    • Software Editions: Included Database Options and Management Packs
    • Providing Automated Databases
    • Handling the Compute Nodes Accompanying a Database Deployment
    • Compute Node Port - Enabling Access
    • Scaling a Database Deployment & Patching Database as a Service
    • Managing Patches with the Oracle Database Cloud Service Console

What's Included

Tutor Support

Tutor Support

Certificate

Certificate

Prerequisites

  • Working knowledge of SQL and use of SQL packages is a must
  • Candidates are recommended to have basic fundamental information of Linux operating system.

Target Audience

The course is primarily intended for the following professionals:

  • Support Engineers
  • Data Warehouse Managers
  • Database Managers
  • Technical Supervisors
  • Database Designers

Delegates Will Learn How To

After the course completion, candidates will have ability to:

    • Observe the Database Performance
    • Implement Database Auditing
    • Configure the Database Instances
    • Schedule data Jobs using the database run
    • >Arrange Oracle Net Services
    • Configure Database For Backup and Recovery
    • Define Oracle Database Design
    • Manage Oracle Database Storage structures
    • Create and Manage User Accounts

Training Solutions at Your Convenience

Our objective has always been to address and resolve the problems of our learners in an efficient manner and improve their learning prospects. We are accustomed in providing training courses as per our learner’s convenience. We love every opportunity to use our experience to resolve difficulties confronted by learners.

Oracle Database 12c: Administration Workshop Ed 2 Training Calender

Filters

arrow

Key Points

Duration: *

Tutor Support

Certificate

Oracle Database 12c: Administration Workshop Ed 2

Contact Us for Date and Price

Enquire Nowup-arrow

---- OR ----

Reach Us at +44 161 884 3134 or info@bestpracticetraining.com for more information.

course-virtual

Online Instructor-led(Virtual)

Best Selling Course

Mon

03

Jun

2024

£2995

Duration:

course-virtual

Online Instructor-led(Virtual)

Best Selling Course

Mon

02

Sep

2024

£2995

Duration:

course-virtual

Online Instructor-led(Virtual)

Best Selling Course

Mon

02

Dec

2024

£2995

Duration:

Optional add-ons

6 Months Access - £219

Extend your access to match your schedule.

1 Year Access - £439

Give yourself as much time as you need to complete the course

Oracle Database 12c: Administration Workshop Ed 2

hours

40 Hours (on average)

days

90 Days Access

administration

40 Hours (on average)

  • Course Price

    £3295

  • add-ons Price

    £0

  • Sub-Total

    £3295

foundation-call Enquire Now

Upon purchase you will receive a password via the email you used to purchase the course.

You will then be able to login to our online learning platform with your email and password.

You will have access to the platform for 90 days from the date of purchase.

ONSITE ENQUIRY?

Fill up the form below and we will get back to you!

name name-red
email email-red
phone-call phonecall-red
house house-red
book book-red
position position-red
house house-red
comment comment-red
conference

Video Conferencing

We provide the best web conferencing platform(s) to facilitate our learners to enhance their communication with the instructor.

whiteboard

Digital Whiteboards

Our courses include the real-time demonstration of figures, diagrams and other interactive material through digital whiteboards.

messaging

Instant Messaging

During the Virtual Classroom session, learners can raise their queries through instant messaging and follow up on their doubts.

control

Participation Controls

Through participating effectively in training, individuals can easily discuss their views, mute their surroundings and virtually "raise" their hands.

Features of Our Virtual Classroom Courses

future

How to Choose and Attend Your Ideal Course?

FIND COURSES

We provide 400+ courses covering broader aspects of personal and professional development training needed by any individual. You can choose any course as per your need or requirement. Our courses are designed to fulfil the current organisational and job marketplace requirements.

search}

Select the Course

Choose the course you want to attend to fulfil your desired goals.

details}

Attend the Course

Attend the training with your prefered method at your convenience.

book}

Get Certification

Upon finishing the course, you will get the completion certificate validating your learning.

Oracle Database 12c: Administration Workshop Ed 2

£ 3295 £ 3245

Benefits of Attending Our Online Courses

We provide a variety of certification programmes or courses for individuals to master a skill set and pursue a full-time career in management, IT, or other domains through the online method to provide them with the convenience of learning. Our dedicated staff works tirelessly to assure the availability of courses with eminence quality that's not found anywhere with benefits like:

skilled

Get Tailored Programmes

affordable

Quick Delivery

flexible

Scalability and Consistency

access

90 Days Access

Learn a New Skill From Onsite Training

Adaptable Courses

We provide onsite courses modified according to our client's organisational needs.

Cost-Effective Learning

Onsite training helps you to reduce travelling and venue expenses.

Learn in Familiar Surroundings

Training at your convenient place can be ideal for learning new skills.

Team Building Opportunity

Attending onsite training with your team can help to improve your team dynamics tremendously.

name

name name-red
phone-call phonecall-red
email email-red
email email-red
comment comment-red
up-arrow
LOADING