SQLSTAR Global Logo

Location

Contact Us

Certification

Placements

Corporate

Courses

About Us

    Oracle Database 12c Admin, Install and Upgrade Accelerated 1.0 Training & Placements in Chennai "ISQL Global"

    Oracle Database 12c: Admin, Install and Upgrade Accelerated

    (Course materials and Course Completion Certificates are directly delivered from Oracle University to those required for Foreign Opportunity)

    (Government of India Approved Education Center)

    This Oracle Database 12c: Admin, Install and Upgrade Accelerated course will provide you with key information to install and administer Oracle Database 12c. This is an accelerated course, covering 7 days worth of content in only 5 days. In this course, you will be introduced to Oracle Database Cloud Service.
    This Oracle Database 12c: Admin, Install and Upgrade Accelerated course covers 7 days worth of content in only 5 days. 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 (2 days). In this course, you will be introduced to Oracle Database Cloud Service.
    This 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:
    • Upgradean existing Oracle Database to Oracle Database 12c.
    • Create and manage an Oracle Database Instance.
    • Create and manage Storage Structures.
    • Configurethe Oracle Network Environment.
    • Create and manage Users.
    • Monitorthe database and manage performance.
    • Learnbasic information on backup and recovery techniques.
    • Gain an understand of the Oracle Database Cloud Service.
    Benefits To YouDiscover 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.
    Prerequisites
    Suggested Prerequisite
    • Workingknowledge of SQL and use of PL/SQL packages
    • Basic knowledge of Linux Operating System
    Audience
    • Technical Administrator
    • Technical Administrator
    • Database Administrators
    • Database Administrators
    • DatabaseDesigners
    • DatabaseDesigners
    • Support Engineer
    • Support Engineer
    Course Objectives
    • ManageOracle Database Storage structures
    • Gain an understand of the Oracle Database Cloud Service
    • InstallOracle Database 12c software
    • Upgradedatabase to Oracle Database 12c
    • Create an Oracle Database
    • Create a container database
    • Monitorthe Database
    • ManageDatabase Performance
    • ImplementDatabase Auditing
    • Configurethe Database Instance Such That Resources Are AppropriatelyAllocated Among Sessions and Tasks
    • ScheduleJobs to Run Inside or Outside of the Database
    • ConfigureOracle Net Services
    • Configureyour Database For Backup and Recovery Operations
    • DescribeOracle 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
    • CourseSchedule
    • Overview of Oracle Database 12c
    Exploring the Oracle Database Architecture
    • Oracle Database memory Structures (overview)
    • ProcessStructures
    • DatabaseStorage Architecture
    • Connecting to the Oracle Database Instance
    • ProcessStartup Sequence
    • ProcessArchitecture
    • Oracle Database Instance Configurations
    • Oracle Database Architecture: Overview
    Oracle Software Installation Basics
    • InstallationOption: Silent Mode
    • Configuring Oracle Linux with Oracle RDBMS Pre-Install RPM
    • EnvironmentVariables
    • 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
    • DataDictionary
    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
    • Toolsfor 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
    • DatabaseUser 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
    • DatabaseBlock contents
    • Managing Table spaces
    • Understanding Storage of Data
    Managing Space
    • Allocating Space
    • RowChaining and Migration
    • Allocating Extents
    • FreeSpace Management Within Segments
    • Types of Segments
    • Creating Tables Without Segments
    • SpaceManagement Overview
    • BlockSpace Management
    Managing Undo Data
    • Transactionsand 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
    • UndoData Overview
    • Managing Undo
    Managing Data Concurrency
    • Overview of Locks
    • DataConcurrency
    • Locking Mechanism
    • DMLLocks
    • EnqueueMechanism
    • LockConflicts
    Implementing Oracle Database Auditing
    • StandardDatabase Auditing
    • Separationfor Duties for Audit Administration (AUDIT_ADMIN and AUDIT_VIEWERroles)
    • Specifying Audit Options
    • DatabaseSecurity
    • Monitoring for Compliance
    • Configuring the Audit Trail
    • Separationof Responsibilities
    • UnifiedAudit Data Trail
    Backup and Recovery Concepts
    • Tuning Instance Recovery
    • Oracle Data Protection Solutions
    • FlashbackTechnology
    • Comparing Complete and Incomplete Recovery
    • Understanding Instance Recovery
    • Phasesof Instance Recovery
    • Using the MTTR Advisor
    • Categoriesof Failures
    Backup and Recovery Configuration
    • ArchivedRedo Log Files
    • Configuring for Recoverability
    • Multiplexing the Control File
    • ArchivedRedo Log File Naming and Destinations
    • Multiplexing the Online Redo Log File
    • OnlineRedo Log File
    • ArchiverProcess
    • Configuring the Fast Recovery Area
    Performing Database Backups
    • Configuring Backup Settings
    • Oracle Secure Backup (overview)
    • Using Recovery Manager (RMAN)
    • BackupTerminology and Types of Backups
    • Backing Up the Control File to a Trace File
    • BackupSolutions Overview
    • Oracle-SuggestedBackup
    • UserManage 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
    • DataRecovery 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
    • AutomaticDatabase Diagnostic Monitor (ADDM)
    • AdvisoryFramework
    • Terminology
    • StatisticLevels
    • AutomaticWorkload Repository (AWR)
    Managing Performance
    • Instance Tuning
    • Performance Tuning Methodology
    • Monitoring Performance
    • Performance Tuning Data
    • Managing Memory
    • PerformancePlanning
    • Tuning Activities
    • PerformanceMonitoring
    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

    All rights reserved. ©1999 - 2022, ISQL Global.

    Terms of Service | Privacy Policy