Posted: 28 days ago

Oracle DBA Training in Bangalore

Shortlist Click to Shortlist
+91 95387 34732

Send Email Response

  • Courses: Others
  • Locality: BTM Layout
  • Posted by: Institute / School / Tutor
Description for "Oracle DBA Training in Bangalore"

Pragathi Technologies,
#12,Level 2, Shravanthi Blue Chip,
100Ft Ring Road, BTM 1st Stage,
Bangalore-68 PH- +91-9538734732

Oracle Database 11g: Administration Workshop I DBA Release 2

Required Prerequisites:
• Taken Oracle Introduction to SQL course or equivalent experience
• Oracle Database: Introduction to SQL
Suggested Prerequisites:
• Taken Oracle PL/SQL course or equivalent experience
Course Objectives:
• Install Oracle Grid Infrastructure
• Install and configure Oracle Database 11g
• Configure Oracle Net services
• Monitor and administer undo data
• Manage the database storage structures
• Create and administer user accounts
• Perform basic backup and recovery of a database
• Manage data concurrency
• Monitor performance
• Describe Oracle Database Architecture
Course Topics:
Exploring the Oracle Database Architecture
• Oracle Database Architecture Overview
• Oracle ASM Architecture Overview
• Process Architecture
• Memory structrues
• Logical and physical storage structures
• ASM storage components
Installing your Oracle Software
• Tasks of an Oracle Database Administrator
• Tools Used to Administer an Oracle Database
• Installation: System Requirements
• Oracle Universal Installer (OUI)
• Installing Oracle Grid Infrastructure
• Installing Oracle Database Software
• Silent Install
Creating an Oracle Database
• Planning the Database
• Using the DBCA to Create a Database
• Password Management
• Creating a Database Design Template
• Using the DBCA to Delete a Database
Managing the Oracle Database Instance
• Start and stop the Oracle database and components
• Use Oracle Enterprise Manager
• Access a database with SQLPlus
• Modify database installation parameters
• Describe the stages of database startup
• Describe database shutdown options
• View the alert log
• Access dynamic performance views
Manage the ASM Instance
• Set up initialization parameter files for ASM instance
• Start up and shut down ASM instances
• Administer ASM disk groups
Configuring the Oracle Network Environment
• Use Enterprise Manager to create and configure the Listener
• Enable Oracle Restart to monitor the listener
• Use tnsping to test Oracle Net connectivity
• Identify when to use shared servers and when to use dedicated servers
Managing Database Storage Structures
• Storage Structures
• How Table Data Is Stored
• Anatomy of a Database Block
• Space Management in Tablespaces
• Tablespaces in the Preconfigured Database
• Actions with Tablespaces
• Oracle Managed Files (OMF)
Administering User Security
• Database User Accounts
• Predefined Administrative Accounts
• Benefits of Roles
• Predefined Roles
• Implementing Profiles
Managing Data Concurrency
• Data Concurrency
• Enqueue Mechanism
• Resolving Lock Conflicts
• Deadlocks
Managing Undo Data
• Data Manipulation
• Transactions and Undo Data
• Undo Data Versus Redo Data
• Configuring Undo Retention
Implementing Oracle Database Auditing
• Describe DBA responsibilities for security
• Enable standard database auditing
• Specify audit options
• Review audit information
• Maintain the audit trail
Database Maintenance
• Manage optimizer statistics
• Manage the Automatic Workload Repository (AWR)
• Use the Automatic Database Diagnostic Monitor (ADDM)
• Describe and use the advisory framework
• Set alert thresholds
• Use server-generated alerts
• Use automated tasks
Performance Management
• Performance Monitoring
• Managing Memory Components
• Enabling Automatic Memory Management (AMM)
• Automatic Shared Memory Advisor
• Using Memory Advisors
• Dynamic Performance Statistics
• Troubleshooting and Tuning Views
• Invalid and Unusable Objects
Backup and Recovery Concepts
• Part of Your Job
• Statement Failure
• User Error
• Understanding Instance Recovery
• Phases of Instance Recovery
• Using the MTTR Advisor
• Media Failure
• Archive Log Files
Performing Database Backups
• Backup Solutions: Overview
• Oracle Secure Backup
• User-Managed Backup
• Terminology
• Recovery Manager (RMAN)
• Configuring Backup Settings
• Backing Up the Control File to a Trace File
• Monitoring the Flash Recovery Area
Performing Database Recovery
• Opening a Database
• Data Recovery Advisor
• Loss of a Control File
• Loss of a Redo Log File
• Data Recovery Advisor
• Data Failures
• Listing Data Failures
• Data Recovery Advisor Views
Moving Data
• Describe ways to move data
• Create and use directory objects
• Use SQL*Loader to move data
• Use external tables to move data
• General architecture of Oracle Data Pump
• Use Data Pump export and import to move data
Working with Support
• Use the Enterprise Manager Support Workbench
• Work with Oracle Support
• Log service requests (SR)
• Manage patches
Oracle Database 11g: Administration Workshop II DBA Release 2
Required Prerequisites:
• Oracle Database 11g Database Administration
• Oracle Database 11g: Administration Workshop I DBA Release 2
Suggested Prerequisites:
• Working knowledge of SQL and how to use PL/SQL packages
Course Objectives:
• Back and recover a database (and its parts) with RMAN (command-line and Enterprise Manager)
• Use flashback technology to view past states of data and to revert either objects or the entire database back to a past state
• Use an appropriate and flexible memory configuration for your database
• Identify burdensome database sessions and poorly performing SQL
• Configure the Oracle Database for optimal recovery
• Configure the database instance such that resources are appropriately allocated among sessions and tasks
• Schedule jobs to run inside or outside of the database
• Use compression to optimize database storage and duplicate a database
Course Topics:
Core Concepts and Tools of the Oracle Database
• The Oracle Database Architecture: Overview
• ASM Storage Concepts
• Connecting to the Database and the ASM Instance
• DBA Tools Overview
Configuring for Recoverability
• Purpose of Backup and Recovery (B&R), Typical Tasks and Terminology
• Using the Recovery Manager (RMAN)
• Configuring your Database for B&R Operations
• Configuring Archivelog Mode
• Configuring Backup Retention
• Configuring and Using a Flash Recovery Area (FRA)
Using the RMAN Recovery Catalog
• Tracking and Storing Backup Information
• Setting up a Recovery Catalog
• Recording Backups
• Using RMAN Stored Scripts
• Managing the Recovery Catalog (Backup, Export, Import, Upgrade, Drop and Virtual Private Catalog)
Configuring Backup Settings
• Configuring and Managing Persistent Settings for RMAN
• Configuring Autobackup of Control File
• Backup optimization
• Advanced Configuration Settings: Compressing Backups
• Configuring Backup and Restore for Very Large Files (Multisection)
Creating Backups with RMAN
• RMAN backup types
• Creating and Using the following:
- Backup Sets and Image Copies
- Whole Database Backup
- Fast Incremental Backup
- Configure Backup Destinations
- Duplexed Backup Sets
- Archival Backups
Restore and Recovery Task
• Restoring and Recovering
• Causes of File Loss
• Automatic Tempfile Recovery
• Recovering from the Loss of a Redo Log Group
• Recovering from a Lost Index Tablespace
• Re-creating a Password Authentication File
• Complete and Incomplete Recovery
• Other Recovery Operations
Using RMAN to Perform Recovery
• Complete Recovery after Loss of a Critical or Noncritical Data File
• Recovering Image Copies and Switching Files
• Restore and Recovery of a Database in NOARCHIVELOG Mode
• Incomplete Recovery
• Performing Recovery with a Backup Control File
• Restoring from Autobackup: Server Parameter File and Control File
• Restoring and Recovering the Database on a New Host
Monitoring and Tuning RMAN
• Monitoring RMAN Jobs
• Balance Between Speed of Backup Versus Speed of Recovery
• RMAN Multiplexing
• Synchronous and Asynchronous I/O
Diagnosing the Database
• Data Recovery Advisor (DRA)
• Block Corruption
• Automatic Diagnostic Repository (ADR)
• Health Monitor
• The ADR Command-Line Tool, ADRCI
Using Flashback Technology I
• Flashback Technology: Overview and Setup
• Using Flashback Technology to Query Data
• Flashback Table
• Flashback Transaction Query
• Performing Flashback Transaction Backout
Using Flashback Technology II
• Oracle Total Recall
• Flashback Drop and the Recycle Bin
Performing Flashback Database
• Configuring Flashback Database
• Performing Flashback Database Operations
• Monitoring Flashback Database
Managing Memory
• Oracle Memory Structures
• Oracle Database Memory Parameters
• Using Automatic Memory Management
• Automatic Shared Memory Management
• Using Memory Advisors
• Using Data Dictionary Views
Managing Database Performance
• Tuning Activities
• Using Statistic Preferences
• Optimizer Statistics Collection
• Monitor the Performance of Sessions and Services
• Automatic Workload Repository (AWR)
• Describing the Benefits of Database Replay
Managing Performance by SQL Tuning
• SQL Tuning and SQL Advisors
• Using SQL Tuning Advisor
• SQL Access Advisor
• SQL Performance Analyzer Overview
Managing Resources
• Database Resource Manager: Overview and Concepts
• Accessing and Creating Resource Plans
• Creating Consumer Group
• Specifying Resource Plan Directives, including:
• - Limiting CPU Utilization at the Database Level
• - Instance Caging
• Activating a Resource Plan
• Monitoring the Resource Manager
Automating Tasks with the Scheduler
• Simplifying Management Tasks
• Creating a Job, Program, and Schedule
• Using Time-Based, Event-Based, and Complex Schedules
• Describing the Use of Windows, Window Groups, Job Classes, and Consumer Groups
• Multi-Destination Jobs
Managing Space in Blocks
• Free Space Management
• Monitoring Space
• Compressing Data
Managing Space in Segments
• Segment Creation on Demand
• Additional Automatic Space-Saving Functionalit
• Shrinking Segments
• Segment Advisor
• Managing Resumable Space Allocation
Managing Space for the Database
• Using 4 KB-Sector Disks
• Transporting Tablespaces
• Transporting Databases
Duplicating a Database
• Purpose and Methods of Cloning a Database
• Using RMAN to Create a Duplicate Database
• Cloning a Database from a Backup
• Duplicate a Database Based on a Running Instance
• Targetless Duplicating a Database
• Oracle SQL & PL/SQL Performance Tuning Workshop - Oracle Core
• Duration: 20 hours
• Prerequisites: Basics of SQL and DBA knowledge
• SQL Performance Tuning Workshop provides hands-on learning to SQL Performance Tuning techniques, features and best practices.
• The course provides focus on performance tuning techniques for SQL, PL/SQL code and hands-on learning for participants.
• This course introduces the participants to identify performance issues using oracle utilities viz Explain Plan / TKPROF, diagnosis the issue and take corrective action.
• Course includes performance-tuning techniques for SQL query, PL/SQL program, and use of other Oracle database objects viz Materialized views, Partitions, Indexes etc to improve database performance.
• Module 1: Introduction with Oracle Architecture
• Module 2: Query Optimization, SQL Query Execution, Explain Plan, Auto trace, Locking Mechanisms, and Interpret TKPROF
• Module 3: Speeding up Queries with Semi Joins and Anti Joins
• Module 4: Understand Statistics, Indexes, and Partitions
• Module 5: Hints, Parsing, and Dynamic SQLs
• Module 6: Views, Materialized Views
• Module 7: Bulk Data processing, Parallel DML, DWH features like External table, Merge, Multi-table Insert
• Module 8: Rewriting SQL for Performance, Merging Multiple SQL to Single SQL, Use of Temporary Tables,
• Module 9: Using AWR and ADDM Reports in Oracle11g r2
• Module 10: Performance Tuning using Oracle Enterprise Manager 11g r2
• Module 11: Tuning Scenarios
• Hands-on Activities for every required section.
(Oracle 11g – RAC on Enterprise Linux)
Duration: 20 hours
Suggested Prerequisites:
• Oracle Database Administrator (DBA) 9i/10g/11g.

Course Topics:

• Hardware
• Software

Configure Linux for Oracle
• OS Requirements
• Oracle Groups and User Account
• Create Mount Points
• Configure Kernel Parameters
• Configure /etc/hosts
• Configure SSH for User Equivalence
• Establish User Equivalence
• Test Connectivity

Prepare the Shared Disks
• Disk Partitions
• Oracle Cluster File System (OCFS) Release 2
• Configure OCFS2
• Configure O2CB to Start on Boot and Adjust O2CB Heartbeat Threshold
• Creat and format the OCFS2 filesystem on the unused disk partition
• Mount the OCFS2 filesystem
• Create the directories for shared files
• Automatic Storage Management (ASM)
• Installing ASM
• Configuring ASMLib

Install Oracle Software
• Installing ASM
• Install Oracle Clusterware
• Create the ASM Instance
• Create the RAC Database
• Startup and Shutdown Steps ( Instance and Database)
• Maintenance Commands – (crsctl and srvctl)
• Backup and Recovery files
For Details Please contact :
Pragathi Technologies,
#12,Level 2, Shravanthi Blue Chip,
100Ft Ring Road, BTM 1st Stage,
Bangalore-68 PH- +91-9538734732

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
Courses - Software Training | Locality - Adarsh Nagar
Posted: 3 hours ago by Institute / School / Tutor   |   Computer courses - Bangalore
Courses - Software Training | Locality - Nrupatunga Road
Posted: 3 hours ago by Institute / School / Tutor   |   Computer courses - Bangalore
Courses - Software Training | Locality - Pragathi Nagar
Posted: 3 hours ago by Institute / School / Tutor   |   Computer courses - Bangalore
Courses - Others | Locality - Amalobhavi Nagar
Posted: 7 hours ago by Institute / School / Tutor   |   Computer courses - Bangalore
Courses - Others | Locality - Amrutha Halli
Posted: 7 hours ago by Institute / School / Tutor   |   Computer courses - Bangalore
Courses - Embedded Systems | Locality - Marathahalli Outer Ring Road
Posted: 7 hours ago by Institute / School / Tutor   |   Computer courses - Bangalore
Courses - Others | Locality - BK Nagar Main Road
Posted: 7 hours ago by Institute / School / Tutor   |   Computer courses - Bangalore
Courses - Others | Locality - Chola Nagar
Posted: 7 hours ago by Institute / School / Tutor   |   Computer courses - Bangalore
Courses - Software Training | Locality - Bannerghatta Road
Posted: 7 hours ago by Institute / School / Tutor   |   Computer courses - Bangalore
Locality - Marathahalli
Posted: 7 hours ago by Institute / School / Tutor   |   Computer courses - Bangalore
Promote your business on
(Premium packages / Banners / Leads)
Mail us at