Signup as a Tutor

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

Oracle DBA Training in Hyderabad

No Reviews Yet

Basheer Bagh, Hyderabad

Course ID: 26773

Basheer Bagh, Hyderabad

Students Interested 0 (Seats Left 0)

₹ 12,000

No Reviews Yet

Date and Time

Not decided yet.

Mahesh picture
Mahesh

Oracle Consultant

About Mahesh

Having 15 years of experience as Oracle Consultant.
No reviews currently

About the Course

The leading and most widely used DBMS across the world today are the Oracle Database, Microsoft SQL Server, MySQL database etc. Out of the three DBMS technologies, Oracle Database is the most popular and widely used database in the world today.

Topics Covered

Exploring the Oracle Database Architecture
Creating an Oracle Database
Managing the Database Instance
Managing Database Storage Structures (Table spaces & Segments)
Administering User Security
Managing Data Concurrency
Managing Undo Data
Configuring the Oracle Network Environment
Backup and Recovery Concepts (cold, hot & RMAN)
Use of RMAN Recovery Catalog & Configuring Backup Settings
Performing Database Backups with RMAN
Performing Database Recovery
Moving Data - Export & Import, External Tables & SQL Loader
Using Flashback Technology I
Using Flashback Technology II
Implementing Oracle Database Auditing
Implementing Oracle Database Auditing
Database Maintenance
Performance Management
Managing Performance by SQL Tuning
Diagnosing the Database
Managing Space
Managing Space for the Database
Managing the ASM Instance
Duplicating a Database / Cloning Database
Data Guard
Installing your Oracle Software
Database Patches & Database Upgrades
Introduction to Real Application Clusters
OLTP vs OLAP
Data modeling
Snake-Flow diagram
Dimensions and Facts
IQD preparation
IQD publishing
Cube generation
Cube publishing into portal
Validations
Adhoc reports
Zero suppression reports
Performance and Tuning with OLAP
Backup and recovery in OLAP

Who should attend

Any Graduate

Pre-requisites

SQL, PL/SQL,LINUX

What you need to bring

Laptop

Key Takeaways

Database Administrators (DBAs) are responsible for the design, implementation, support and maintenance of computerized databases in today's organizations. The role also includes architecting, building and scaling databases for future data growth and capacity. They are also responsible for security, performance and availability of data to users and customers.

Reviews

No reviews currently

Discussions

Students Interested 0 (Seats Left 0)

₹ 12,000

Post your requirement and let us connect you with best possible matches for Oracle Database Post your requirement now
₹ 12,000 Enquire