Oracle Database 12c Admin, Install And Upgrade Accelerated Training Course Online Course

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

All levels
English

Course Description

Oracle Database technology is used by the world's leading companies to manage critical business functions, systems and processes. Oracle Database is the number one database in the world. Over 305,000 top companies trust their critical systems to Oracle Database. Oracle Database is the number one embedded database technology.In fact, 97% of Global Fortune 500 companies use Oracle software. Well-trained, highly-skilled database professionals who can manage critical systems are in high demand. This Oracle Database 12c: Admin, Install and Upgrade Accelerated course covers practical approach. 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.

See more less

What you’ll learn

Live Class Practical Oriented Training
Timely Doubt Resolution
Dedicated Student Success Mentor
Certification & Job Assistance
Free Access to Workshop & Webinar
No Cost EMI Option
Manage Oracle Database Storage structures. Gain an understand of the Oracle Database Cloud Service.
Create a container database. Monitor the Database. Manage Database Performance. Implement Database Auditing
Schedule Jobs to Run Inside or Outside of the Database. Configure Oracle Net Services.
Configure your Database For Backup and Recovery Operations.
Install Oracle Database 12c software. Upgrade database to Oracle Database 12c. Create an Oracle Database.
Configure the Database Instance Such That Resources Are Appropriately Allocated Among Sessions and Tasks.
Describe Oracle Database Architecture . Manage the Oracle Database Instance

Covering Topics

Lecture-1 Introduction

Lecture-2 Exploring the Oracle Database Architecture

Lecture-3 Oracle Software Installation Basics

Lecture-4 Installing Oracle Database Software

Lecture-5 Creating an Oracle Database by Using D.B.C.A.

Lecture-6 Oracle Database Management Tools

Lecture-7 Managing the Database InstanceV

Lecture-8 Configuring the Oracle Network Environment

Lecture-9 Administering User Security

Lecture-10 Managing Database Storage Structures

Lecture-11 Managing Space

Lecture-12 Managing Undo Data

Lecture-13 Managing Data Concurrency

Lecture-14 Implementing Oracle Database Auditing

Lecture-15 Backup and Recovery Concepts

Lecture-16 Backup and Recovery Configuration

Lecture-17 Performing Database Backups

Lecture-18 Performing Database Recovery

Lecture-19 Moving Data

Lecture-20 Performing Database Maintenance

Lecture-21 Managing Performance

Lecture-22 Oracle Database Cloud Service

Curriculum

  Lecture-1 Introduction
Live Lecture 
·         Overview of Oracle Database 12c

·         Overview of Oracle Cloud

·         Overview of the HR Schema

·         Oracle Database 12c Introduction

·         Practical Exercise

  Lecture-2 Exploring the Oracle Database Architecture
Live Lecture 
·           Oracle Database Architecture: Overview

·           Oracle Database Instance Configurations

·           Connecting to the Oracle Database Instance

·           Oracle Database memory Structures (overview)

·           Process Architecture

·           Process Structures

·           Process Start-up Sequence

·           Database Storage Architecture

·           Practical Exercise

  Lecture-3 Oracle Software Installation Basics
Live Lecture 
·         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

·         Practical Exercise

  Lecture-4 Installing Oracle Database Software
Live Lecture 
·         System Requirements for Oracle Database

·         Creating Operating System Groups and Users

·         Types of Installations

·         Practical Exercise

  Lecture-5 Creating an Oracle Database by Using D.B.C.A.
Live Lecture 
·         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)

·         Practical Exercise

  Lecture-6 Oracle Database Management Tools
Live Lecture 
·         Introducing Oracle Database Management Tools

·         Using SQL*Plus

·         Using SQL Developer

·         Logging in to Oracle Enterprise Manager Database Express

·         Enterprise Manager Database Express Home Page

·         Enterprise Manager Cloud Control Framework

·         Using Enterprise Manager Cloud Control

·         Practical Exercise

  Lecture-7 Managing the Database Instance
Live Lecture 
·         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

·         Practical Exercise

  Lecture-8 Configuring the Oracle Network Environment
Live Lecture 
·         Oracle Net Services Overview

·         Oracle Net Listener Overview

·         Establishing Oracle Network Connections

·         Connecting to a Server

·         Tools for Configuring & Managing the Oracle Network

·         Using the Listener Control Utility

·         Using Oracle Net Configuration Assistant

·         Using Oracle Net Manager

·         Practical Exercise

  Lecture-9 Administering User Security
Live Lecture 
·         Database User Accounts (overview)

·         Predefined Administrative Accounts

·         Creating a User

·         Authentication

·         Unlocking a User Account & Resetting the Password

·         Privileges

·         Roles

·         Profiles

·         Practical Exercise

  Lecture-10 Managing Database Storage Structures
Live Lecture 
·         Understanding Storage of Data

·         Database Block contents

·         Exploring the Storage Structure

·         Creating a New Table-space

·         Overview of Table-spaces Created by Default

·         Managing Table-spaces

·         Viewing Table-space Information

·         Using Oracle Managed Files

·         Practical Exercise

  Lecture-11 Managing Space
Live Lecture 
·         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

·         Practical Exercise

  Lecture-12 Managing Undo Data
Live Lecture 
·         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 table-space to a Fixed Size

·         Practical Exercise

  Lecture-13 Managing Data Concurrency
Live Lecture 
·         Overview of Locks

·         Locking Mechanism

·         Data Concurrency

·         DML Locks

·         Enqueue Mechanism

·         Lock Conflicts

·         Practical Exercise

  Lecture-14 Implementing Oracle Database Auditing
Live Lecture 
·         Separation of Responsibilities

·         Database Security

·         Monitoring for Compliance

·         Standard Database Auditing

·         Unified Audit Data Trail

·         Separation for Duties for Audit Administration

·         Configuring the Audit Trail

·         Specifying Audit Options

  Lecture-15 Backup and Recovery Concepts
Live Lecture 
·         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

·         Practical Exercise

  Lecture-16 Backup and Recovery Configuration
Live Lecture 
·         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

·         Practical ExerciseLecture-16 Backup and Recovery Configuration
Live Lecture 
·         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

·         Practical Exercise

  Lecture-17 Performing Database Backups
Live Lecture 
·         Backup Solutions 

·         Oracle Secure Backup 

·         User Managed Backup 

·         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

·         Practical Exercise

  Lecture-18 Performing Database Recovery
Live Lecture 
·         Data Recovery Advisor

·         Loss of a Control File

·         Loss of a Redo Log File

·         Loss of a Data file in NOARCHIVELOG Mode

·         Loss of a Noncritical Data file in ARCHIVELOG Mode

·         Loss of a System-Critical Data file in ARCHIVELOG Mode

·         Practical Exercise

  Lecture-19 Moving Data
Live Lecture 
·         Moving Data: General Architecture

·         Oracle Data Pump

·         SQL*Loader

·         External Tables

·         Practical Exercise

  Lecture-20 Performing Database Maintenance
Live Lecture 
·         Database Maintenance (overview)

·         Viewing the Alert History

·         Terminology

·         Automatic Workload Repository (AWR)

·         Statistic Levels

·         Automatic Database Diagnostic Monitor (ADDM)

·         Advisory Framework

·         Enterprise Manager and Advisors

·         Practical Exercise

  Lecture-21 Managing Performance
Live Lecture 
·         Performance Monitoring

·         Tuning Activities

·         Performance Planning

·         Instance Tuning

·         Performance Tuning Methodology

·         Performance Tuning Data

·         Monitoring Performance

·         Managing Memory

·         Practical Exercise

  Lecture-22 Oracle Database Cloud Service
Live Lecture 
·         Database as a Service Architecture, Features & Tooling

·         Software Editions: Included Database Options &

       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

·         Oracle Database Cloud Service Console to Manage Patches

·         Practical Exercise

Frequently Asked Questions

Basic understanding of Oracle database.

Ans: The course offers a variety of online training options, including: • Live Virtual Classroom Training: Participate in real-time interactive sessions with instructors and peers. • 1:1 Doubt Resolution Sessions: Get personalized assistance and clarification on course-related queries. • Recorded Live Lectures*: Access recorded sessions for review or to catch up on missed classes. • Flexible Schedule: Enjoy the flexibility to learn at your own pace and according to your schedule.

Ans: Live Virtual Classroom Training allows you to attend instructor-led sessions in real-time through an online platform. You can interact with the instructor, ask questions, participate in discussions, and collaborate with fellow learners, simulating the experience of a traditional classroom setting from the comfort of your own space.

Ans: If you miss a live session, you can access recorded lectures* to review the content covered during the session. This allows you to catch up on any missed material at your own pace and ensures that you don't fall behind in your learning journey.

Ans: The course offers a flexible schedule, allowing you to learn at times that suit you best. Whether you have other commitments or prefer to study during specific hours, the course structure accommodates your needs, enabling you to balance your learning with other responsibilities effectively. *Note: Availability of recorded live lectures may vary depending on the course and training provider.