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