tumblr hit counter

Oracle Apps DBA

Oracle APPS DBA Online Training Course

INTRODUCTION TO ORACLE DBA

? What is DBA ?

? Why a Company needs a DBA?

? Roles & Responsibilities of DBA

? Oracle Architecture

? Physical and Logical Phase of Database

? Types of files(Control file, Redolog file and Datafile)

? Different types of Datafiles

? Instance

? SGA(System Global Area) and Background Process

DATABASE CREATION

? Different Startup Modes

? Different Shutdown Modes

? Types of Database Creation

? Manual Method of Creation

TABLESPACE MANAGEMENT

? Introduction to Table space

? Types of Table space(BIG & SMALL)

? Temporary Table space

? Altering/Renaming a Table space

? Renaming a data file

? Temporary Groups

? Table space Encryption(11g)

STORAGE PARAMETERS

? What are segments?

? What are extents?

? What is Blocks?

? Oracle Blocks

? Estimation of Extents

? Dictionary Managed Table space

? Locally Managed Table space

? Storage Parameters(Initial, Next, Min Extents, Xtents, Pctincrease)

USER MANAGEMENT

? Who are Database Users?

? Why to create a User?

? Creation of Users

? Assigning Privileges

? Creating and granting Roles

? Allocating table space Quotas to Users

? Assigning default table space for the Users

? Setting Profiles for the Users

? Levels of Authentication

? Schema Management(11g)

? Security(11g)

UNDO MANAGEMENT

? What is Undo?

? Why Undo required?

? Pending offline status

? Flashback Features

? Flashback Table

? Flashback query

? Flashback Version query

SPFILE & OMF

? What is spfile?

? Difference between spfile and pfile

? Advantages of spfile

? What is OMF?

? Advantages of OMF

? Files conventions of OMF

NETWORKING IN ORACLE

? Introduction to Oracle Networking

? Network default location

? Editing Network file

? Listener.ora

? Tnsnames.ora

? Introduction to Database Links

? Types of Database Links

? Introduction to Materialized views

? Advantages of Materialized view

? Refresh Modes

REDO-LOG & CONTROLFILE MANAGEMENT

? Introduction to Redo log

? Status of Redo logs

? Multiplexing the Redo log files

? Re-creation of Control file

? Renaming the Database

? Multiplexing the Control file

LOGICAL BACKUP

? What is a logical backup

? Why it is required

? Export/import Utility

? Data Pump

? Difference between Data Pump and Traditional Export/import

? Impdp/expdp

? Transportable Table spaces

PHYSICAL BACKUP

? Introduction to Physical backup

? Types of Physical backup

? Cold & Hot backup

? Recovery scenarios

? RMAN backup

? RMAN Point in time recovery

? RMAN 11g new features

PEFORMANCE TUNING

? What is Performance Tuning?

? Why Tuning required?

? Types of Tuning

? Database Tuning

? Tuning

? SQL Tuning

? Memory Tuning

? Network Tuning

? Partitioning and Indexes

? Partitioning Enhancements

? AWR/ASH/ASMM/ADDM

? RAT(Real Application Testing)(11g)

? SQL Performance Analyses (11g)

? Row chaining and Row migration

? Resemble Table spaces

AVAILABILITY

? Introduction to Data Guard

? Types of Standby databases

? 11g New features in Data Guard

? Types of Protection modes

? Active standby/snapshot standby(11g)

? Log Miner

? RMAN Point in time Recovery

? Introduction to Database Cloning

? RMAN Cloning

? Automatic Storage Management(ASM)

ADVANCED SQL Topics

? HOW TO USE SAS MACROS IN SQL

? How dictionary table and views can simplify programming SQL options

? How to retrieve Raw data different from DATABASES to SAS environment using SQL Statements

? To create table in different databases using SAS sql statement

? To manage in different databases using SAS Sql Statements

SQL-LOADER

? Introduction to SQL Loader

? Types of files

? Control file

? Infile

? Bad file

? Discard file

? Data file

AUDITING

? What is auditing?

? Why auditing performed?

? Types of Auditing

? Levels of Auditing

FLASHBACK FEATURES

? Flashback Database

? Flashback Archive(11g)

MISCELLANEOUS

? Oracle 11g Installations

? Comparison between Oracle 10g and Oracle 11g

? New features Introduced in Oracle 10g

? Upgradation from Oracle 10g to Oracle11g

 
 

Contact Us

Enter the letter in the text field
captcha

Contact us

NewYorkSys Inc.
15 Roaring Brook Rd,
Chappaqua, NY 10514.
CALL US :
USA : +203-446-9097
USA : +203-446-9231
Mail : info@trainingoracleapps.com

Online Training

We have a complete range of Online IT Training Programs and courses to provide high precision training for individuals, corporate organizations and various business firms.

Our Service

Online Training is a full-service IT Consulting and Staffing Company serving Corporate clients Nationwide. We provide staff augmentation, contract, and contract-to-hire IT professionals.

CAREERS

Oracle Apps DBA Online Training also provides recruiting services for it strong client base. We recruit IT professionals on a contract, contract-to-hire, and full-time basis. We utilize our existing placement base at the client site