Posted: 1 month ago


Shortlist Click to Shortlist
+91 98807 56789
+91-80-4227 7050

Send Email Response

  • Course: Career Counseling
  • Locality: Dommasandra
  • You are: Offering professional course

No. 11, MKB SQUARE, Near Vijaya Bank, Outer Ring Road, Marthahalli Bridge, Bangalore - 37.
9880756789 / 08042277050
MNP Technologies is a leading and premier IT training institute in Bangalore. MNP Technologies provides a high-quality of training to our students and we provide advanced labs to do practical experiments and Classrooms to become an expert in any IT Course.
We provide expert trainers who have work experience in TOP MNC Company across India. Our trainer are real time experience faculty will provide a best training methodology and courseware with 100% real time project scenarios, Cost-Effective and Quality in all the courses


Exploring the Oracle Database Architecture
• Explain the Memory Structures
• Describe the Process Structures
• Overview of Storage Structures
Preparing the Database Environment
• Identify the tools for Administering an Oracle Database
• Plan an Oracle Database installation
• Install the Oracle software by using Oracle Universal Installer (OUI)
• Creating an Oracle Database
• Create a database by using the Database Configuration Assistant (DBCA)
Managing the Oracle Instance
• Setting database initialization parameters
• Describe the stages of database startup and shutdown
• Using alert log and trace files
• Using data dictionary and dynamic performance views
Configuring the Oracle Network Environment
• Configure and Manage the Oracle Network
• Using the Oracle Shared Server architecture
Managing Database Storage Structures
• Overview of table space and data files
• Create and manage table spaces
• Space management in table spaces

Administering User Security
• Create and manage database user accounts
• Grant and revoke privileges
• Create and manage roles
• Create and manage profiles
Managing Data and Concurrency
• Monitor and resolve locking conflicts
Managing Undo Data
• Overview of Undo
• Transactions and undo data
• Managing undo
Database Maintenance
• Use and manage optimizer statistics
• Use and manage Automatic Workload Repository (AWR)
• Use advisory framework
• Manage Alerts and Thresholds
Performance Management
• Use Automatic Memory Management
• Use Memory Advisors
• Troubleshoot invalid and unusable objects
Backup and Recovery Concepts
• Identify the types of failure that can occur in an Oracle database
• Describe ways to tune instance recovery
• Identify the importance of checkpoints, redo log files, and archived log files
• Overview of flash recovery area
• Configure ARCHIVELOG mode
Performing Database Backups
• Create consistent database backups
• Back up your database without shutting it down
• Create incremental backups
• Automate database backups
• Manage backups, view backup reports and monitor the flash recovery area
Performing Database Recovery
• Overview of Data Recovery Advisor
• Use Data Recovery Advisor to Perform recovery (Control file, Redo log file and Data file)
Moving Data
• Describe and use methods to move data (Directory objects, SQL*Loader, External Tables)
• Explain the general architecture of Oracle Data Pump
• Use Data Pump Export and Import to move data between Oracle databases
Configuring for Recoverability
• Configure multiple archive log file destinations to increase availability
• Define, apply and use a retention policy
• Configure the Flash Recovery Area
• Use Flash Recovery Area
Using the RMAN Recovery Catalog
• Identify situations that require RMAN recovery catalog
• Create and configure a recovery catalog
• Synchronize the recovery catalog
• Create and Use RMAN stored scripts
• Back up the recovery catalog
• Create and use a virtual private catalog
Configuring Backup Specifications
• Configure backup settings
• Allocate channels to use in backing up
• Configure backup optimization
Using RMAN to Create Backups
• Create image file backups
• Create a whole database backup
• Enable fast incremental backup
• Create duplex backup and back up backup sets
• Create an archival backup for long-term retention
• Create a multisession, compressed and encrypted backup
• Report on and maintain backups
Using RMAN to Perform Recovery
• Perform complete recovery from a critical or noncritical data file loss using RMAN
• Perform incomplete recovery using RMAN
• Recover using incrementally updated backups
• Switch to image copies for fast recovery
• Restore a database onto a new host
• Recover using a backup control file
• Perform Disaster recovery
• Using RMAN to Duplicate a Database
• Creating a duplicate database
• Using a duplicate database
Performing Table space Point-in-Time Recovery
• Identify the situations that require TSPITR
• Perform automated TSPITR
Monitoring and Tuning RMAN
• Monitoring RMAN sessions and jobs
• Tuning RMAN
• Configure RMAN for Asynchronous I/O
Using Flashback Technology
• Restore dropped tables from the recycle bin
• Perform Flashback Query
• Use Flashback Transaction
Additional Flashback Operations
• Perform Flashback Table operations
• Configure, Monitor Flashback Database and Perform Flashback Database operations
• Set up and use a Flashback Data Archive
Diagnosing the Database
• Set up Automatic Diagnostic Repository
• Using Support Workbench
• Perform Block Media Recovery
Managing Memory
• Implement Automatic Memory Management
• Manually configure SGA parameters
• Configure automatic PGA memory management
Managing Database Performance
• Use the SQL Tuning Advisor
• Use the SQL Access Advisor to tune a workload
• Understand Database Replay
Space Management
• Manage presumable space allocation
• Describe the concepts of transportable table spaces and databases
• Reclaim wasted space from tables and indexes by using the segment shrink functionality
Managing Resources
• Understand the database resource manager
• Create and use Database Resource Manager Components
Automating Tasks with the Scheduler
• Create a job, program, and schedule
• Use a time-based or event-based schedule for executing Scheduler jobs
• Create lightweight jobs
• Use job chains to perform a series of related tasks
Administering the Scheduler
• Create Windows and Job Classes
• Use advanced Scheduler concepts to prioritize jobs
• Data guard
• Data guard Architecture
• Protection Modes
• Configuration Physical Standby
• Configuration Logical Standby
• Switchover and Failover
• Cascaded Standby Database
• Oracle Database Advance Administration
• Automatic Storage Management
• ASM Architecture
• Configuring ASM
• Configuring Raw Device
• Configuring ASM Disks
• Start and Shutdown ASM
• Maintaining Disk groups
• Migrating from and to ASM
• ASMCMD command Line
• Workshop withscenariors
• Assessment
• Oracle Real Application Clusters(RAC)
• RAC components

1. Oracle Cluster ware
• Background processes in RAC
• Database files in RAC
1. Server parameter file
2. Data files
3. Control files
4. Online redo log files
5. Archived redo log files
6. Other files
• Maintaining read consistency in RAC
• Cache Coherency
• Cache fusion
• Global Resource Directory
• Mastering of resources
• Lock management
• Multi-instance transaction behavior
• Recovery
1. Cache recovery
2. Transaction recovery
3. Online block recovery
• Storage Management
• Disk fundamentals
• RAID concepts
• Storage options for RAC
1. RAW devices
2. Clustered file system

See more ads by this user
Mark as Spam
Safety tips for buyers / sellers
Use      keys to browse Next/Prev ads
Similar classified ads which may interest you :
Get similar ads More details
Course - Others | Locality - Marathahalli Outer Ring Road
Posted: 1 hour ago   |   Professional courses - Bangalore
Course - Management | Locality - Chikkanayakanahalli
Posted: 1 hour ago   |   Professional courses - Bangalore
Course - Management | Locality - Chikkalasandra
Posted: 1 hour ago   |   Professional courses - Bangalore
Course - Management | Locality - Chikkabidarakallu
Posted: 1 hour ago   |   Professional courses - Bangalore
Course - Management | Locality - Chikkabanavara
Posted: 1 hour ago   |   Professional courses - Bangalore
Course - Management | Locality - ChikkaSandra
Posted: 1 hour ago   |   Professional courses - Bangalore
Course - Management | Locality - Chikka Madiwala
Posted: 1 hour ago   |   Professional courses - Bangalore
Course - Management | Locality - Chikka Lakshmaiah Layout
Posted: 1 hour ago   |   Professional courses - Bangalore
Course - Management | Locality - Chikka Bettahalli
Posted: 1 hour ago   |   Professional courses - Bangalore
Course - Management | Locality - Chikka Basavanapura
Posted: 1 hour ago   |   Professional courses - Bangalore
Promote your business on
(Premium packages / Banners / Leads)
Mail us at