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 : +1-718-305-1757
USA : +1-718-313-0499
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
 
 
LiveZilla Live Help