Oracle DBA online training | www.sryitsolutions.com

Oracle DBA Training Contents

FEATURES OF SRYIT:

Course Duration: 60 Hours
Access: With 2 months server access
Trainer Details: 6+ Years Real Time Consultant
Prerequisites: Any Programming Language knowledge will be helpful. It is not compulsory Fresher’s also can learn this course.

Material: Soft Copy of Training Materials (sap abap material), Session Video Recordings will be provided of sessions provided.

After Training: Resume preparation, Interview Questions Career Support will be provided.

Support: 24/7 Customer Support

Contact us for more details and Session Schedules at

USA: +1-319-804-4998  India:+91-9948030675

Email: sryitsolutions@gmail.com

Web: http://www.sryitsolutions.com/

Oracle DBA online training

INTRODUCTION

ü  Identify the oracle product

ü  Describe the basic concept of a relational database

INSTALLING ORACLE DATABASE 10G SOFTWARE

ü  System requirements

ü  Use Oracle Optimal Flexible Architecture (OFA)

ü  Install software with the Oracle Universal Installer

CREATE AN ORACLE DATABASE

ü  Oracle Database Architecture

ü  Oracle instance architecture

ü  Use the Database Creation Assistant

CONTROLLING THE DATABASE

ü  Manually configure the Oracle 10g EM dbconsole

ü  Start and stop the agent

ü  Start and stop the enterprise manager database console

ü  Start and stop the listener

ü  Startup and shutdown the database

STORAGE STRUCTURES

ü  Defining the table spaces and data files

ü  Create table spaces

ü  Manage table spaces

ü  Obtain table space information

ü  Create and manage table space using oracle enterprises manager

ADMINISTERING USERS

ü  Create and manage database user accounts

ü  Create and manage roles

ü  Grant and revoke privileges

ORACLE DATABASE SECURITY — ONLY THEORY

ü  Apply the principal of least privilege

ü  Manage default user accounts

ü  Implement standard password security features

ORACLE NET SERVICES

ü  Understand Oracle Net concepts

ü  Use Oracle Net Manager to create and configure listeners

ü  Use the Oracle Net Manager to configure client and middle-tier connection

ü  Use TNSPING to test Oracle Net connectivity

PERFORMANCE MONITORING

ü  Gather optimizer statistics

ü  View performance metrics

MONITORING AND MANAGING MEMORY

ü  Oracle Memory Structures

ü  Automatic PGA Memory Management

ü  Using the Memory Advisor

ü  Using Automatic Shared Memory Management to avoid long running query issues

MONITORING AND RESOLVING LOCK CONFLICTS

ü  Detect and resolve lock conflicts

ü  Manage deadlocks

DIAGNOSTIC SOURCES

ü  The Alert Log

ü  Viewing Alerts with EM

ü  Alerts Notification —– Only Theory

ü  Editing Thresholds —– Only Theory

ü  Trace Files

PROACTIVE MAINTENANCE: OBJECTIVES — ONLY THEORY

ü  Set warning and critical alert thresholds

ü  Collect and use baseline metrics

ü  Use tuning and diagnostic advisors

ü  Use the Automatic Database Diagnostic Monitor (ADDM)

AUTOMATIC STORAGE MANAGEMENT —- ONLY THEORY

ü  ASM Concepts

ü  ASM General Architecture

ü  Creating an ASM instance

ü  Creating table spaces that use ASM storage

ü  Viewing ASM information

ü  Migrating a table space to use ASM storage.

UNDO MANAGEMENT — ONLY THEORY

ü  Monitor and administer undo

ü  Configure undo retention

ü  Guarantee undo retention

ü  Use the undo advisor

BACKUP AND RECOVERY — ONLY THEORY

ü  Describe the basics of database backup, restore and recovery

ü  List the types of failure that may occur in an Oracle Database

ü  Describe ways to tune instance recovery

ü  Identify the importance of checkpoints, redo log files, and archived log file

MANAGING DATA

ü  Manipulating data through SQL

ü  Using Import

ü  Using Export

DATABASE BACKUPS

ü  Configure ARCHIVELOG mode

ü  Create consistent database backups

ü  Back your database up without shutting it down

ü  Create incremental backups

ü  Automate database backups

ü  Monitor the flash recovery area

MANAGING SCHEMA OBJECTS

ü  Create and modify tables

ü  Define constraints

ü  View the attributes of a table

ü  View the contents of a table

ü  Create indexes and views

DATABASE RECOVERY

ü  Recover from loss of a control file

ü  Recover from loss of a redo log file

ü  Recover from loss of a data file