ORACLE DBA

ORACLE DBA

Overview:
Database administrators (DBAs) use specialized software to store and organize data. The role may include capacity planning, installation, configuration, database design, performance monitoring, troubleshooting, as well as backup and data recovery. Oracle Database is a multi-model database management system produced and marketed by Oracle Corporation. Each database requires at least one database administrator (DBA) to administer it. Because an Oracle database system can be large and can have many users, often this is not a one person job. In such cases, there is a group of DBAs who share responsibility.

Training Objectives of ORACLE DBA
Oracle DBA Training is designed for individuals who would like to become Oracle DBAs. The data is the most important asset for any organization and hence this makes the job of DBA quite demanding. Oracle dba Training starts with SQL and move to advanced SQL, Programming and Database Administration I, and Database Administration II. This course provides the SQL skills that allow developers, database administrators and end-users to write queries against single and multiple tables, manipulate data in tables and take advantage of Oracle supplied row functions.

Target Students and Prerequisites:
Students must be familiar with data processing concepts and techniques.

Course Contents:
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 tables paces
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 tablespaces that use ASM storage
Viewing ASM information
Migrating a tablespace 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

About the Trainer

10 + Years of IT experience, provided training for over 1000+ professionals online Real-time IT experience which enables to provide dedicated quality training. Teaching is his passion vast experience in providing online training around the globe with good communication skills.