Find
in
Avoid scams by dealing locally! Always exchange items and money in person and Never pay in advance. More info

Oracle DBA Corporate Online Training Services



What is Oracle DBA?

A database administrator (short form DBA) is a person responsible for the installation, configuration, upgrade, administration, monitoring and maintenance of databases in an organization. The role includes the development and design of database strategies, system monitoring and improving database performance and capacity, and planning for future expansion requirements. They may also plan, co-ordinate and implement security measures to safeguard the database.

Oracle DBA Corporate Online Training Course Content: -

1. Introduction (Database Architecture)

Describe course objectives
Explore the Oracle 10g/11g database architecture

2. Installing the Oracle Database Software

Explain core DBA tasks and tools
Plan an Oracle installation
Use optimal flexible architecture
Install software with the Oracle Universal Installer (OUI)

3. Creating an Oracle Database

Create a database with the Database Configuration Assistant (DBCA)
Create a database design template with the DBCA
Generate database creation scripts with the DBCA

4. Managing the Oracle Instance

Start and stop the Oracle database and components
Access a database with SQL*Plus and iSQL*Plus
Modify database initialization parameters
Understand the stages of database startup
View the Alert log
Use the Data Dictionary

5. Managing Database Storage Structures

Describe table data storage (in blocks)
Define the purpose of tablespaces and data files
Understand and utilize Oracle Managed Files (OMF)
Create and manage tablespaces
Obtain tablespaces information
Describe the main concepts and functionality of Automatic Storage Management (ASM)

6. Administering User Security

Create and manage database user accounts
Authenticate users
Assign default storage areas (tablespaces)
Grant and revoke privileges
Create and manage roles
Create and manage profiles
Implement standard password security features
Control resource usage by users

7. Managing Schema Objects

Define schema objects and data types
Create and modify tables
Define constraints
View the columns and contents of a table
Create indexes, views and sequences
Explain the use of temporary tables
Use the Data Dictionary

8. Managing Data and Concurrency

Manage data through SQL
Identify and administer PL/SQL Objects
Describe triggers and triggering events
Monitor and resolve locking conflicts

9. Managing Undo Data

Explain DML and undo data generation
Monitor and administer undo
Describe the difference between undo and redo data
Configure undo retention
Guarantee undo retention
Use the undo advisor

10. Implementing Oracle Database Security

Describe DBA responsibilities for security
Apply the principal of least privilege
Enable standard database auditing
Specify audit options
Review audit information
Maintain the audit trail

11. Configuring the Oracle Network Environment

Create additional listeners
Create Net Service aliases
Configure connect - time failover
Control the Oracle Net Listener
Test Oracle Net connectivity
Identify when to use shared versus dedicated servers

12. Proactive Maintenance

Use statistics
Manage the Automatic Workload Repository (AWR)
Use the Automatic Database Diagnostic Monitor (ADDM)
Describe advisory framework
Set alert thresholds
Use server - generated alerts
Use automated tasks
 Respond to this ad


Ad ID: 3262731
Similar ads: