loading......

coming soon

Coming Soon

We are in process of building the inventory of good professionals in this category

Got it!

Where do you need ?

location

Please select a Location.

Enquire

Submit your enquiry for Certification Oriented Training on Oracle DBA&APP

Please enter valid question or comment

Please enter your name.

Please enter valid email

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Xchangetechslearning

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer

Share

course photo

Certification Oriented Training on Oracle DBA&APP

Koramangala 6th Block, Bangalore

15,000

No Reviews Yet
0 Interested

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
Reviews
There are no Reviews yet. Be the First to Review
Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions

Comment ?

Questions Guidelines

  • Start your question with simple statements like "what", "when", "where", or "how".
  • Ensure your question or answer is not offensive or insensitive - it may be voted down or banned.
  • Please provide as much detail as possible as this will allow our members to better understand and respond to your question.
  • Take some time to categorize your question. This will greatly help other users find the question.


You can add upto 6 Images

Ask


There are no Reviews yet. Be the First to Review

Date and Time

Not decided yet.

About the Trainer

Vijay

MTech


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

Students Interested 0

Course Id: 18230