Oracle core Dba Placement Assistance Training institute

Oracle core Dba Placement Assistance Training institute

-Introduction to database management systems and databases

What is a database?
Popular database management system (DBMS) software and why Oracle DBMS
History and Current trends of DBMS and Database Administration
Tasks of a Database Administrator

Introduction to DBA
Tasks of an Oracle Database Administrator
Installation of Oracle Database Software
Optimal Flexible Architecture (OFA)
Oracle Universal Installer
Prerequisite Checks
Installation
Configuration Assistants

Creating an Oracle Database
Database Architecture
Exploring the Storage Structure
Control Files
Redo Log Files
Table spaces and Data files
Segments, Extents, and Blocks
Oracle Instance Management
Oracle Memory Structures
Oracle Processes
Data Dictionary
Database Control
Grid Control
Database Configuration Assistant (DBCA) Overview
Creating a Database
Passwords and Storage
File Locations and Backup Recovery
Content and Initialization Parameters
Other Actions with DBCA

Managing the Database
Starting and Stopping iSQL*Plus
Starting and Stopping Database Control
Accessing Database Control
SYSOPER and SYSDBA
Database Home Page
Changing the Listener Status
NOMOUNT MOUNT OPEN States
SHUTDOWN Options
Initialization Parameter Files
Viewing the Alert Log
Net Services
Oracle Net Services
Oracle Net Listener
Monitoring the Listener
Listening Addresses
Static Database Registration
Listener Control Utility
Oracle Net Connections
Directory Naming
Advanced Connections
Oracle Net Manager
Configuring Service Aliases with Net Manager

Managing Schema Objects
Schemas
Accessing Schema Objects
Schema Object Namespaces
Specifying Data Types in Tables
Other Data Types
Creating and Modifying Tables
Understanding Data Integrity
Defining Constraints
Viewing the Attributes of a Table
Viewing the Contents of a Table
Creating Indexes
Creating Views
Using a Sequence

Storage Structures

Tablespaces and Data Files

Space Management in Tablespaces

Storage for Locally Managed Tablespaces

Altering a Tablespace

Actions with Tablespaces

Dropping Tablespaces

Viewing Tablespace Information

Administering Users

Database User Accounts

Creating a User

Profiles and Users

Authenticating Users

Database Users and Schemas

Privileges : System and Object

Roles

Assigning Quota to Users

Assigning Roles to Users

Managing Data

Data Pump Export

Data Pump Import

DIRECTORY Objects

Control File Syntax Considerations

Input Data and Data Files

Loading Methods

Comparing Direct and Conventional Path Loads

Loading Data with SQL*Loader

External Tables
Transportable tablespace

Undo Management

Undo Data

Transactions and Undo Data

Storing Undo Information

Monitoring Undo

Administering Undo

Configuring Undo Retention

Guaranteeing Undo Retention

Sizing the Undo Tablespace

Using the Undo Advisor

Backup and Recovery Concepts

Backup and Recovery Issues

Categories of Failures

Instance Recovery

Phases of Instance Recovery

Tuning Instance Recovery

Configuring for Recoverability

ARCHIVELOG Mode

Configuring Backup Strategy

Scheduling Backups: Review

Backup Control File to Trace

Manage Backups

Database Recovery

Opening a Database

Changing Instance Status

Keeping a Database Open

Scenarios:

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

Oracle Recovery Manager

Oracle Recovery Catalog maintenance

Backups using Oracle Recovery Manager

Recovery using Oracle recovery manager

Database Cloning using RMAN

Tablespace Point in time recovery
Incomplete recovery

Thanks&Regards
Elegant IT Services,
#352, 2nd Floor,Aswath Nagar
Varthur main road,Near Railway Fly Over
Maratha halli,Land mark : Chemmunar Jewellers,
Bangalore - 560037.Ph:-9886541264/87
www.elegantitservices.com