Admin, Install, upgrade and Accelerated DBA Syllabus Training in Chennai

Admin, Install, Upgrade and Accelerated Training in Chennai ISQL Global

This Oracle Database 12c: Admin, Install and Upgrade Accelerated course covers 7 days worth of content in only 5 days at No.1 Top Oracle Authorised Training and Placement Center ISQL Global (SQL Star). It consists of the Oracle Database 12c: Administration Workshop Ed 1 course (5 days) and the Oracle Database 12c: Install and Upgrade Workshop Ed 1 course. In this course, you will be introduced to Oracle Database Cloud Service.

This ISQL Global course will will teach you about the Oracle Database architecture and you will discover how to effectively manage an Oracle Database instance. You will also be provided key information on how to install and administer Oracle Database 12c.

Learn To:

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.

Benefits To You

Discover how you can effectively install and manage an Oracle Database instance. Create a container database and provision pluggable databases to support your business needs. Benefit from learning how to configure the Oracle Network Environment to perform database maintenance.

Suggested Prerequisite

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

Audience

Technical Administrator
Technical Administrator
Database Administrators
Database Administrators
Database Designers
Database Designers
Support Engineer

Course Objective

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

Course Topics

Introduction

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

Exploring the Oracle Database Architecture

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

Oracle Software Installation Basics

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

Installing Oracle Database Software

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

Creating an Oracle Database by Using DBCA

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

Oracle Database Management Tools

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

Managing the Database Instance

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

Configuring the Oracle Network Environment

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

Administering User Security

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

Managing Database Storage Structures

Exploring the Storage Structure
Creating a New Tablespace
Viewing Tablespace Information
Using Oracle Manage d Files
Overview of Table spaces Created by Default
Database Block contents
Managing Table spaces
Understanding Storage of Data

Managing Space

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

Managing Undo Data

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

Managing Data Concurrency

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

Implementing Oracle Database Auditing

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

Backup and Recovery Concepts

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

Backup and Recovery Configuration

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

Performing Database Backups

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

Performing Database Recovery

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

Moving Data

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

Performing Database Maintenance

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

Managing Performance

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

Oracle Database Cloud Service: Overview

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

Attention! - PEARSON VUE® Authorized Test Center. Write Any Exam at Any Time (24 Hours/365 Days) in lowest price. (Free Exam Materials for Oracle Exams)

Admin, Install, Upgrade and Accelerated Training in Chennai ISQL Global

Course Topics

Attention! - PEARSON VUE^® Authorized Test Center. Write Any Exam at Any Time (24 Hours/365 Days) in lowest price. (Free Exam Materials for Oracle Exams)