Oracle Database 12c: Admin, Install and Upgrade Accelerated/1Z0-062

Name: Oracle Database 12c: Admin, Install and Upgrade Accelerated
Item: Oracle Database 12c: Admin, Install and Upgrade Accelerated
Rating: 5

Overview Schedule & Fees Course Benefits Student Feedback FAQ Course Modules

Oracle Database 12c: Admin, Install and Upgrade Accelerated Certification Training Course Overview

This Oracle Database 12c: Admin, Install and Upgrade Accelerated course covers 7 days worth of substance in just 5 days. It comprises of the Oracle Database 12c: Administration Workshop Ed 1 course (5 days) and the Oracle Database 12c: Install and Upgrade Workshop Ed 1 course (2 days). In this course, you will be acquainted with Oracle Database Cloud Service.

This course will show you about the Oracle Database engineering and you will find how to viably deal with an Oracle Database case. You will likewise be given key data on the best way to introduce and regulate Oracle Database 12c.

Audience

Support Engineer
Technical Administrator
Database Administrators
Database Designers

Course Objectives

Manage Oracle Database Storage structures
Gain an understand of the Oracle Database Cloud Service
Install Oracle Database 12c software
Upgrade database to Oracle Database 12c
Create an Oracle Database
Create a container database
Monitor the Database
Manage Database Performance
Implement Database Auditing
Configure the Database Instance Such That Resources Are Appropriately Allocated Among Sessions and Tasks
Schedule Jobs to Run Inside or Outside of the Database
Configure Oracle Net Services
Configure your Database For Backup and Recovery Operations
Describe Oracle Database Architecture
Manage the Oracle Database Instance

This course prepares you for Exam 1Z0-062. Test your current knowledge Qubits42

Oracle Database 12c: Admin, Install and Upgrade Accelerated (40 Hours) Download Course Contents

Live Virtual Classroom
Group Training 1700 02 - 06 Aug 09:00 AM - 05:00 PM CST (8 Hours/Day) 06 - 10 Sep 09:00 AM - 05:00 PM CST (8 Hours/Day)	1-on-1 Training (GTR) 1950 4 Hours 8 Hours Week Days Week End Start Time : At any time 12 AM 12 PM Training Schedule: GTR=Guaranteed to Run

Classroom Training (Available: London, Dubai, India, Sydney, Vancouver) Duration : On Request Fee : On Request	On Request
Special Solutions for Corporate Clients! Click here	Hire Our Trainers! Click here

Customers who bought this course also bought

• Certified Information Systems Security Professional (CISSP)

• Oracle Database 12c: Admin, Install and Upgrade Accelerated

• Oracle Database: Managing Multitenant Architecture Ed 1

• Oracle Database 19C:Administration Workshop

• Oracle Database: Backup and Recovery Workshop

• Oracle Database Cloud for DBAs on Oracle Cloud Infrastructure

• Oracle Database: Introduction to SQL

• Oracle Database: Performance Management and Tuning

• PostgreSQL Database Administration

• Red Hat System Administration I (RH124)

Course Modules

Module 1: Introduction

Course Objectives
Course Schedule
Overview of Oracle Database 12c
Overview of Oracle Cloud
Overview of the HR Schema
Oracle Database 12c Introduction

Module 2: Exploring the Oracle Database Architecture

Oracle Database Architecture: Overview
Oracle Database Instance Configurations
Connecting to the Oracle Database Instance
Oracle Database memory Structures (overview)
Process Architecture
Process Structures
Process Startup Sequence
Database Storage Architecture

Module 3: Oracle Software Installation Basics

Planning Your Installation
Configuring Oracle Linux with Oracle RDBMS Pre-Install RPM
Operating System Groups and Users
Environment Variables
Configuring the Oracle Software Owner Environment
Using Oracle Universal Installer (OUI)
Installation Option: Silent Mode

Module 4: Installing Oracle Database Softwar

System Requirements for Oracle Database
Creating Operating System Groups and Users
Types of Installations

Module 5: Creating an Oracle Database by Using DBCA

Planning the Database Storage Structure
Types of Databases (based on workload)
Choosing the Appropriate Character Set
Understanding How Character Sets are Used
Setting the NLS_LANG Initialization Parameter
Using the Database Configuration Assistant (DBCA)

Module 6: Oracle Database Management Tools

Introducing Oracle Database Management Tools
Using SQL*Plus
Using SQL Developer
Logging in to Oracle Enterprise Manager Database Express
Using the Enterprise Manager Database Express Home Page
Understanding the Enterprise Manager Cloud Control Framework
Using Enterprise Manager Cloud Control

Module 7: Managing the Database Instance

Initialization Parameter Files
Starting an Oracle Database Instance
Shutting Down an Oracle Database Instance
Viewing Log Files
Using Trace Files
Using the Dynamic Performance Views
Data Dictionary

Module 8: Configuring the Oracle Network Environment

Oracle Net Services Overview
Oracle Net Listener Overview
Establishing Oracle Network Connections
Connecting to a Server
Tools for Configuring and Managing the Oracle Network
Using the Listener Control Utility
Using Oracle Net Configuration Assistant
Using Oracle Net Manager

Module 9: Administering User Security

Database User Accounts (overview)
Predefined Administrative Accounts
Creating a User
Authentication
Unlocking a User Account and Resetting the Password
Privileges
Roles
Profiles

Module 10: Managing 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

Module 11: Managing Space

Space Management Overview
Block Space Management
Row Chaining and Migration
Free Space Management Within Segments
Types of Segments
Allocating Extents
Allocating Space
Creating Tables Without Segments

Module 12: Managing Undo Data

Undo Data Overview
Transactions and Undo Data
Storing Undo Information
Comparing Undo Data and Redo Data
Managing Undo
Configuring Undo Retention
Guaranteeing Undo Retention
Changing an Undo tablespace to a Fixed Size

Module 13: Managing Data Concurrency

Overview of Locks
Locking Mechanism
Data Concurrency
DML Locks
Enqueue Mechanism
Lock Conflicts

Module 14: Implementing Oracle Database Auditing

Separation of Responsibilities
Database Security
Monitoring for Compliance
Standard Database Auditing
Unified Audit Data Trail
Separation for Duties for Audit Administration (AUDIT_ADMIN and AUDIT_VIEWER roles)
Configuring the Audit Trail
Specifying Audit Options

Module 15: Backup and Recovery Concepts

Categories of Failures
Flashback Technology
Understanding Instance Recovery
Phases of Instance Recovery
Tuning Instance Recovery
Using the MTTR Advisor
Comparing Complete and Incomplete Recovery
Oracle Data Protection Solutions

Module 16: Backup and Recovery Configuration

Configuring for Recoverability
Configuring the Fast Recovery Area
Multiplexing the Control File
Online Redo Log File
Multiplexing the Online Redo Log File
Archived Redo Log Files
Archiver Process
Archived Redo Log File Naming and Destinations

Module 17: Performing Database Backups

Backup Solutions Overview Oracle Secure Backup (over
Oracle Secure Backup (overview)
User Managed Backup (overview)
Backup Terminology and Types of Backups
Using Recovery Manager (RMAN)
Configuring Backup Settings
Oracle-Suggested Backup
Backing Up the Control File to a Trace File

Module 18: Performing Database Recovery

Data Recovery Advisor
Loss of a Control File
Loss of a Redo Log File
Loss of a Datafile in NOARCHIVELOG Mod
Loss of a Noncritical Datafile in ARCHIVELOG Mode
Loss of a System-Critical Datafile in ARCHIVELOG Mode

Module 19: Moving Data

Moving Data: General Architecture
Oracle Data Pump
SQL*Loader
External Tables

Module 20: Performing Database Maintenance

Database Maintenance (overview)
Viewing the Alert History
Terminology
Automatic Workload Repository (AWR)
Statistic Levels
Automatic Database Diagnostic Monitor (ADDM)
Advisory Framework
Enterprise Manager and Adviso

Module 21: Managing Performance

Performance Monitoring
Tuning Activities
Performance Planning
Instance Tuning
Performance Tuning Methodology
Performance Tuning Data
Monitoring Performance
Managing Memory

Module 22: Oracle Database Cloud Service: Overview

Database as a Service Architecture, Features and Tooling
Software Editions: Included Database Options and Management Packs
Automated Database Provisioning
Managing the Compute Node Associated With a Database Deployment
Managing Network Access to Database as a Service
Enabling Access to a Compute Node Port
Scaling a Database Deployment & Patching Database as a Service
Using the Oracle Database Cloud Service Console to Manage Patches

Download Course Contents

Request More Information

Request a call back?

Course Prerequisites

Working knowledge of SQL and use of PL/SQL packages
Basic knowledge of Linux Operating System

Find how you can successfully install and manage Oracle Database case. Make a compartment database and arrangement pluggable databases to help your business needs. Advantage from figuring out how to arrange the Oracle Network Environment to perform database maintenance

Upon Completion of this Course, you will accomplish following:-

Upgrade an existing Oracle Database to Oracle Database 12c.
Create and manage an Oracle Database Instance.
Create and manage Storage Structures.
Configure the Oracle Network Environment.
Create and manage users.
Monitor the database and manage performance.
Learn basic information on backup and recovery techniques.
Gain an understand of the Oracle Database Cloud Service.

Give an edge to your career with Oracle certification training courses. Students can join the classes for Oracle Database 12c: Admin, Install and Upgrade Accelerated Training Course at Koenig Campus located at New Delhi, Bengaluru, Shimla, Goa, Dehradun, Dubai & Instructor-Led Online.

Student Feedback (Check Koenig Feedback on Trustpilot)

Q1 Say something about the Trainer? Q2 How is Koenig different from other training Companies? Q3 Will you come back to Koenig for training ?

Student Name	Country	Month	Feedback	Rating
Prabhaher Ramanujam	India	Feb-2020	A2. Koenig is best in terms of Environment, the standard they are maintaining, skillful trainers, and tailor-made courses.

FAQ's

Yes, fee excludes local taxes.

We offer below courses: Oracle Database: Managing Multitenant Architecture Ed 1 - Oracle Database: Backup and Recovery Workshop - Oracle Database 12c R2: SQL Tuning for Developers Ed 2 - Oracle Database 19C:Administration Workshop - Oracle Database 19c: New Features for Administrators Ed 1 - Oracle Database 19c: RAC Administration Workshop - Oracle Database 19c: Data Guard Administration Workshop - Oracle Database 19c: Backup and Recovery - Oracle Database 19c: Multitenant Architecture -

To fulfil the training requirement for Oracle certifications, you can take the training in any of the following formats: • Live Virtual Classroom Training • Classroom Training • Training on Demand

To move towards any Oracle certification path, there are defined and approved courses which are duly approved and are a mandatory training and certification requirement. Recommended training courses, on the other hand, are Oracle course(s) listed on the exam details page and serve as the best course recommendation to help you prepare for your certification exam.

Oracle exams are conducted at authorized Pearson VUE testing centers worldwide.

Yes, you can mark some questions and review them at the end of the examination. Even after you have clicked on the Submit button, the examination tool will prompt you to take up the marked questions before proceeding further.

There are no negative markings for incorrect answers.

A section-wise detailed score report will accompany your exam result within 30 minutes of completing the examination.

You can re-write a test after 14 days but you cannot write a test more than three times in a year. A diagnostic evaluation follows each test which can help you learn from the mistakes and help you better prepare for the subsequent examinations.