Oracle Database Courses | Administration Workshop ed 2

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

Overview
Course Content
What's Included

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

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

Explore Now

Choose Mode of Training

Classroom

Online Instructor-led

Online Self-Paced

Onsite

Key Points

Duration: *

Tutor Support

Certificate

Oracle Database 12c: Administration Workshop Ed 2

---- OR ----

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

Oracle Database 12c: Administration Workshop Ed 2

Book Now

Online Instructor-led(Virtual)

Best Selling Course

Mon

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

40 Hours (on average)

90 Days Access

40 Hours (on average)

Course Price

£3295
add-ons Price

£0
Sub-Total

£3295

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!

Video Conferencing

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

Digital Whiteboards

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

Instant Messaging

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

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

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.

Select the Course

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

Attend the Course

Attend the training with your prefered method at your convenience.

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:

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.

Best Practice Training provides specially designed training courses in 410+ locations spanning over 30+ countries globally. All our locations have state of the art facilities for the learners. Some of the Popular Locations are: