Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

"Certification Oriented Training on Oracle DBA&APP" is no longer available

No Reviews Yet

Koramangala 6th Block, Bangalore

Course ID: 18230

Koramangala 6th Block, Bangalore

No Reviews Yet

About the Course

Certification Oriented Training on Oracle DBA&APP'S DBA by Industry Expert.

Topics Covered

1. Introduction to IT & Databases
Overview of IT and Current IT
Trends What is Database?
Why Database?
Types of Databases
Major Databases and Database Vendors
Database Market Share and Trends
Factors influencing Database Choice
Getting ready to adopt and support Database
2. Roles and Responsibilities of DBA
Traditional Roles and Responsibilities of DBA
The changing role of DBA
Emergence of DBA 2.0
The Enterprise DBA
3. Oracle Database Architecture
Database, Instance
Memory Structures ? Database Buffer
Cache, Redo Log Buffer, Shared Pool
Process Structures ? DBWn ,LGWR,
CKPT, SMON, PMON, RECO, ARCn
Physical & Logical Structures
4. Installing Oracle Database Server Software
Identifying Database Releases
System Requirements for Installation
Optimal Flexible Architecture (OFA)
Setting Environment Variables
Oracle Universal Installer (OUI)
Installing Oracle Software
5. Creating Oracle Database
Planning the Database Creating
Database using DBCA
Configuring Database Listener
Exploring the seed database and Sample
6. Managing Oracle Instance
Initialization Parameters
Managing Initialization Parameters -
Static and Dynamic parameters, PFILE,
SPFILE, Managing Database Startup and
Shutdown, Automatic Diagnostic Repository
(ADR) , Alert Log and Trace Files
Understanding Data Dictionary Views
Dynamic Performance Views
7. Managing Data Files & Tablespaces
Table space and Data Files
Creating Table spaces
Altering Table spaces
Dropping Table spaces
Viewing Table space Information
8. User Administration
Database User Accounts, Predefined
Accounts, Creating Users, User
Authentication Managing Privileges,
Managing Roles and Profiles
tnsnames.ora, listener.ora, Configuring
Listener, Naming methods, Using NETCA
Oracle 11g Easy Connect Method,
Establishing Database Connectivity from
Oracle Database Clients
9. Managing Undo Data
Transactions and Undo Data
Undo Vs Redo
Managing Undo data
Configuring Undo Retention
10. Managing Temporary Tablespaces
Temporary Table space Concepts
Creating Temporary Tablespaces
Temporary Table space Groups
Managing Table space Groups
11. Managing Control Files
Understanding Control Files, Multiplexing
Control Files, Re-creating Control Files,
Backing up Control Files
12. Managing Online Redo Log & Archived Log Files
Understanding Online and Archived Redo
Log Files, Configuring Database Archive
mode, Managing Online Redo Log Files
13. Configuring Oracle Network
Oracle Net Services, sqlnet.ora,
Schemas
14. Backup and Recovery
Backup and Recovery Concepts
Instance Recovery, Media Recovery
Concepts of User Managed Backups
Backup and Recovery using RMAN
RMAN Concepts, Recovery Catalog,
Retention Policies, Full & Incremental
Backups, Image Copy and Backup Set
backups, Hot and Cold backups using
RMAN, Complete and In- complete
backups using RMAN, Performing
Recovery using RMAN, Concepts of Tape
backups, Oracle Secure Backup (OSB)
15. Oracle Database Utilities
Oracle Data Pump Utility
Concepts of Logical backups
Data Pump Exports and Imports
Taking Logical backups with Data Pump
Exports and Imports
SQL*Loader Utility
Loading external data using SQL*Loader
ADRCI Utility, Concepts of ADRCI
Using ADRCI to view Diagnostic Data
DBVERIFY Utility, Performing integrity
checks using DBVERIFY
ORAPWD Utility, Creating Password file
using ORAPWD, Using Password file
Authentication
DBNEWID Utility, Changing DBID and
DBNAME using DBNEWID
16. Database Security
Security Overview
Security Requirements
Database Security
Protecting Privileged Accounts
Security Updates and Patches
17. Database Cloning & Refresh
Cloning Concepts and Considerations
Cloning Techniques
Performing Database Cloning
Performing Database Refreshing
18. DBA+
User Managed Backups & Recovery
Transportable Tablespaces
Creating Database using Manual
Procedures, Dropping Database
19. Real Time Concepts
Database Life Cycle
Database Environments ?
Development, QA and Production
Environments, DBA Responsibilities
Project Execution Models - Onsite,
Offsite, Offshore , Onsite-Offshore
Models, U.S Context and India Context,
Executing a DBA Support project,
SLAs, Understanding IT Infrastructure
Library (ITIL) Concepts, Automating
routine DBA tasks and importance of
Automation in DBA Projects
Troubleshooting Performance Issues

Who should attend

All Working and Non Working People

Pre-requisites

Knowledge on Computers

What you need to bring

Pen,Book.Laptop

Key Takeaways

Knowledge on Oracle DBA 7Oracle Apps DBA

Date and Time

Not decided yet.

About the Trainer

Avg Rating

Reviews

Students

Courses

Vijay

MTech

He has more than 10 years of exp into the teaching field. He is a real time expert

Reviews

No reviews currently Be the First to Review

Discussions

Post your requirement and let us connect you with best possible matches for Corporate Training Post your requirement now

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more