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

No Reviews Yet

Koramangala 6th Block, Bangalore

Course ID: 18230

Koramangala 6th Block, Bangalore

Students Interested 0 (Seats Left 0)

₹ 15,000

No Reviews Yet

Date and Time

Not decided yet.

Vijay

MTech

About Vijay

He has more than 10 years of exp into the teaching field. He is a real time expert
No reviews currently Be the First to Review

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

No reviews currently Be the First to Review

Discussions

Students Interested 0 (Seats Left 0)

₹ 15,000

Post your requirement and let us connect you with best possible matches for Corporate Training Post your requirement now
₹ 15,000 Enquire

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 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