We've noticed this is not your region.
Redirect me to my region
What do you want to learn today?

Oracle DBA 12c Training course

ENDED
Online Training by  FuturePoint
Inquire Now
Online / Training

Details

Oracle Database 12c  Course Contents:

 

Oracle Database 12c Introduction

Oracle Database Architecture: Overview

CDB & PDB

Oracle Database Instance Configurations

Connecting to the Oracle Database Instance Oracle Database memory Structures Process Architecture

Process Structures Process Startup Sequence Oracle Software Installation Basics

Installation

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 Installing Oracle Database Software

System Requirements for Oracle Database

Creating Operating System Groups and Users Types of Installations

DB creation

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) Oracle Database Management Tools

startup and shutdown

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 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 Configuring the Oracle Network Environment

12c network

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 Administering User Security

Database User Accounts 

Predefined Administrative Accounts

Creating a User

Authentication

Unlocking a User Account and Resetting the Password Privileges Roles Profiles Managing

Database Storage Structures

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 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

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 Managing Data Concurrency

Overview of Locks

Locking Mechanism

Data Concurrency

DML Locks

Enqueue Mechanism

Lock Conflicts

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

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 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 Performing Database Backups

Backup Solutions Overview

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 Performing Database Recovery

Data Recovery Advisor

Loss of a Control File

Loss of a Redo Log File

Loss of a Datafile in NOARCHIVELOG Mode

Loss of a Noncritical Datafile in ARCHIVELOG Mode Loss of a System-Critical

Datafile in ARCHIVELOG Mode Moving Data

Moving Data: General Architecture

Oracle Data Pump

SQL*Loader

External Tables

Performing Database Maintenance

Database Maintenance 

Viewing the Alert History

Terminology

Automatic Workload Repository (AWR)

Statistic Levels

Automatic Database Diagnostic Monitor (ADDM) Advisory Framework Enterprise

Manager and Advisors Managing Performance

Performance Monitoring

Tuning Activities

Performance Planning

Instance Tuning

Performance Tuning Methodology

Performance Tuning Data

Monitoring Performance

Managing Memory

http://www.futurepointtech.com/oracle-dba-11g-training.html     

Drop a mail [email protected]  we will get in touch with u

 

Speaker/s

http://www.futurepointtech.com/oracle-dba-11g-training.html     

Schedules

Oct 19, 2019 - Oct 18, 2020
ENDED
No. of Days: 30
Total Hours: 35
Reviews
Be the first to write a review about this course.
Write a Review

Future Point Technologies is a Thirteen  Years old leading Software Training center based in Hyderabad. The Future Point Technologies is an Institute dedicated to teaching Core Computer Technologies to students and professionals. 

 

FUTUREPOINT  Offers CLASS Room, ONLINE and CORPORATE Trainings.

 

  • ATTEND THE DEMO AND CHECK THE QUALITY OF OUR EXPERIENCED TRAINERS

We offer Online Training , so you get trained from where you are from our experienced trainers, In the weekdays as well as weekends by the Real Time Professionals .
The program is designed to provide rich learning experience for students using Internet .

Courses  Offerings 
      

  • Amazon Web Services
  • Android
  • AIX Administration
  • Business Analyst
  • BIRT Reporting
  • CA Siteminder
  • CCNA, CCNP Security, CCIE , CheckPoint
  • Citrix  XenApp
  • Cognos 10 BI & Tm1
  • Crystal Reports
  • Data Stage
  • DB2 DBA
  • Dell Bhoomi
  • Dev Ops
  • Dot Net
  • Google Web Tool Kit
  • Golden Gate
  • Hadoop
  • Hyperion  Essabase, Planning, HFR , HFM , DRM
  • IBM Websphere Commerce server Admin
  • IBM Lotus Notes (Development) 
  • IBM Lotus Notes Domino Server Administration
  • IBM Message Broker
  • IBM MQ Series Administration ...
FuturePoint Technologies
Plot No:60, 2nd Floor ,Western Hills, Opp: Sri Chaitanya Junior Kalasala Behind Arjuna Theatre, KPHB,Hyderabad - 500072
4040178841
Sending Message
Please wait...
× × Speedycourse.com uses cookies to deliver our services. By continuing to use the site, you are agreeing to our use of cookies, Privacy Policy, and our Terms & Conditions.