Please Submit Your Feedback

Your email address and contact will not be published. Required fields are marked *

Book Now
6 months internship in delhi ncr
Home contact Us Sitemap
Janakpuri: 9999991236
Nirman Vihar: 9999087993
Oracle 11g DBA Training
Oracle 11g DBA Training
  • Oracle 11g DBA Training
  • Prerequisites
  • How we Provide
  • Objective
  • Projects and JOB
  • Topics
What is Oracle 11g DBA?

Oracle 11g is a new version of database management system. XPERT INFOTECH provides oracle 11g dba training according to the current requirement of IT industry. The Oracle Database 11g is a relational database management system (RDBMS) produced and marketed by Oracle Corporation. The specialty of this new version is the inclusion of grid computing capability, represented by `g` in the name 11g. The term 10g DBA is often used for 11g Database Administrator, which represents a person or a group of people responsible for creation and maintenance of an Oracle 10g Database. Oracle Corporation offers a certification programme for DBAs under which a DBA can appear for an examination to test his DBA skills. 

Oracle 11g Database provides efficient, reliable, secure data management for high-end applications such as high-volumeon-line transaction processing (OLTP) environments, query-intensive data warehouses, and demanding Internet applications. Our faculty provide how the student will learn and how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques.

This course is designed to give you a firm foundation in basic database administration and advances your success as an Oracle professional in the area of database administration. You will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. The lesson topics are reinforced with structured hands-on practices. This course is designed to prepare you for the corresponding oracle Certified Associate exam. Oracle continues to dominate the database industry. Several versions of Oracle are being used in the industry. Oracle is usually conducted on Microsoft Window Server platform. If you prefer, you can opt for Oracle on Linux/Ubuntu.

Before going through 11g Database live project training candidate should have knowledge of given concepts listed below:
  • Knowledge of Working knowledge of SQL.
  • Knowledge of Basic understanding of databases.
Oracle 11g DBA Training provided by Real time Oracle Developer of our company, has more than 4 years of domain experience.

  • We will provide real time project training with code explanation and implementation.
  • Our training modules are completely designed according to current IT market.
  • After completion of 75% of course, student will go through Major Project Training, Live Project Training, Interview Preparation and Recruitment process in IT Industry.
  • Student will go through the training of SQL and database as a complimentary package before starting of Oracle 11g DBA.
  • We offer regular, fast track and weekend training in Oracle 11g DBA Course.
  • Study material is provided with the course which consist of concepts, examples and real time examples.
Benefits of Courses
  • Database Administrator
Oracle 11g DBA Training provided by Real time Oracle 11g DBA Developer of our company, has more than 6 years of domain experience.

  • We will provide real time project training with code explanation and implementation.
  • Our training modules are completely designed according to current IT market.
  • After completion of 75% of course, student will go through Major Project Training, Live Project Training, Interview Preparation and Recruitment process in IT Industry.
  • Student will go through the training of HTML, CSS and JavaScript as a complimentary package before starting of Oracle 11g DBA .
  • We offer regular, fast track and weekend training in Oracle 11g DBA course.
  • Study material is provided with the course which consist of concepts, examples and real time examples.
Oracle Database 11g Release 2 DBA - Part I
Introduction to Oracle Database 11g
  • Relational database concepts
  • Database administration tasks
  • DBA responsibilities
Oracle Database 11g Architecture
  • Oracle database architecture
  • The Oracle instance
  • Memory structures
  • Background processes
  • Server and client processes
  • The Oracle database
  • Overview of Oracle ASM architecture
Installation and Configuration of an Oracle Database
  • System Hardware Requirements
  • Optimal Flexible Architecture
  • Authentication methods for a database
  • Oracle environment variables
  • Install Oracle software using the Oracle Universal Installer (OUI)
  • Use the database Configuration Assistant
  • Create a database with DBCA
  • Manage a database with DBCA
  • Delete a database with DBCA
  • Manage Templates using DBCA
  • Upgrade a database using Database Upgrade Assistant (DBUA)
Administer a Database Instance
  • Administrative tools available to a DBA
  • Using SQL*Plus in Oracle to manage a database
  • Administer the database using Enterprise Manager (EM)
  • Start and stop the EM Database Console
  • Access EM
  • EM navigation
  • Grant EM administrative privileges to a user
  • Overview of Oracle Restart
Configure the Oracle Network Environment
  • Overview of network configuration
  • Oracle Net Listener configuration and management
  • Oracle Net Naming methods
  • Tools for configuring and managing the Oracle network
  • Use Enterprise Manager to create and configure the Listener
  • Configure client connections with Net Manager
  • View listener configuration
  • Start and stop the Oracle listener
  • Enable Oracle Restart to monitor the listener
  • Use TNSPING to test Oracle Net connectivity
  • Connect to the database
  • Configure Net Services with Enterprise Manager
  • Overview of Shared Server architecture
  • Identify when to use Shared Servers and when to use Dedicated Servers
Manage an Oracle Instance
  • Access an Oracle database
  • Database authentication methods
  • Password file
  • The Startup Process
  • Initialization parameters
  • Shutdown a database and instance using SQL
  • Startup a database and instance using SQL
  • View alert log and trace files
  • View or modify initialization parameters with EM
Tablespace and Datafile Management
  • Overview of tablespaces and datafiles
  • Use EM to view the storage structure of the database
  • Create and alter tablespace commands
  • Locally managed tablespaces
  • Dictionary managed tablespaces
  • Bigfile tablespaces
  • Temporary tablespaces
  • Multiple temporary tablespaces
  • Create tablespaces
  • Manage tablespaces
  • Use standard and non-standard block sizes
  • Create and manage tablespaces using OMF
  • Drop tablespace command
Manage Redo Logs
  • Redo log overview
  • Plan redo logs
  • Redo log data dictionary tables
  • Log switches and checkpoints
  • Log file maintenance
  • Add and drop log file members and groups
  • Clear a log file
  • Move or rename an online redo log file
  • Multiplex redo log files
  • Use EM to manage redo logs
  • Manage online redo log files with OMF
  • List redo log information
Manage Control Files
  • The usage of the control file
  • The contents of a control file
  • Manage control files
  • Replace a lost or damaged control file
  • Mirror a control file
  • Standby control file
  • Manage control files with OMF
  • List control file information
Manage Schema Objects
  • Create a new table
  • View the attributes and contents of a table
  • Understand data integrity
  • Define constraints
  • Alter tables
  • Create indexes
  • View index attributes
  • Create views
  • Create and use sequences
Manage Users
  • Database administration accounts
  • User accounts
  • Create a user account
  • Operating system authentication
  • Change a user's password
  • Manage a user account
  • Drop a user account
  • Monitor user information
  • Terminate user sessions
  • Product user profiles
Manage Profiles and Resources
  • Overview of user profiles
  • Profile resource parameters
  • Create profile command
  • Manage passwords with profiles
  • Maintain profiles
  • Drop profiles
Managing Privileges
  • Database access
  • Oracle supplied roles
  • System level privileges
  • Object level privileges
  • The grant and revoke commands
  • Create roles
  • Modify and drop roles
  • Control the availability of roles
  • Use predefined roles
  • Synonyms
  • Listing valid grants
Database Auditing
  • Overview of database auditing
  • Auditing SYS statements
  • Auditing end user sessions
  • Statement auditing
  • Privilege auditing
  • Auditing modifications made to database objects
  • Audit table relocation
  • Auditing from Enterprise Manager
Undo Management
  • Undo data overview
  • Monitor and administer undo
  • Configure undo retention
  • Switch undo tablespaces
  • Specify the retention period
  • Guarantee undo retention
  • Retention period for flashback queries
  • View undo space information
  • Use the undo advisor
  • Size the undo tablespace
  • Manage undo with EM
Moving Data
  • Create directory objects
  • Data Pump Export and Import
  • Data Pump architecture
  • Data Pump data dictionary views
  • Data Pump interactive mode
  • Data Pump API
  • Use Data Pump to export data
  • Use Data Pump to import data
  • SQL Loader
  • Overview of SQL Loader
  • Command line parameters
  • Record filtering
  • Control file keywords
  • Datafiles
  • SQL Loader data paths
Manage an ASM Instance
  • Overview of Automatic Storage Management
  • ASM Storage Components
  • Set up initialization files for an ASM instance
  • Startup and Shutdown ASM Instances
  • Administer ASM disk groups
Data Concurrency and Lock Conflicts
  • Levels of locking in Oracle
  • Methods used to acquire locks
  • Possible causes of contention
  • Prevent locking problems
  • Detect lock contention
  • Resolve conflicts in an emergency
Proactive Database Maintenance
  • Self Monitoring Architecture
  • Automatic Workload Repository
  • Automatic Database Diagnostic Monitoring
  • Monitor an Oracle database
  • Use the Advisors
  • Set up notification rules
Performance Management
  • Tuning information sources
  • Identify unusable objects
  • Optimizer Statistics collection
  • Automated statistics collection
  • Performance metrics
  • Use the advisors
  • React to performance issues
Backup and Recovery Considerations
  • Backup solutions
  • Overview of Oracle Secure Backup
  • Oracle Suggested Backup Strategy
  • Database backup, restore and recover
  • Types of failure
  • Tune instance recovery
  • Checkpoints, redo log files and archive log files
  • Alter the ARCHIVELOG mode of a database
  • Configure a database for recoverability
Database Backups
  • Types of RMAN backup
  • Backup sets and image copies
  • Perform backups using EM
  • Automate database backups
  • Configure backup settings
  • Catalog settings
  • Monitor the flash recovery area
  • Manage backups
Database Recovery
  • Restore and recovery operations
  • Recover an entire database from backup
  • Recover from the loss of a system critical data file
  • Recover from the loss of a control file
  • Recover from the loss of a redo log file
  • Data Recovery Advisor
  • Data Recovery Advisor Views
Work with Oracle Support
  • Enterprise Manager Support Workbench
  • Register for security updates
  • Work with Oracle support
  • Log Service Requests
  • Manage patches
Oracle Database 11g Release 2 DBA - Part II
Backup and Recovery Considerations
  • Oracle Suggested Backup Strategy
  • Plan and Implement a Backup and Recovery Strategy
  • Define a Backup Strategy
  • Define a Disaster Recovery Plan
  • The Advantages and Disadvantages of Different Backup Methods
  • Test a Backup and Recovery Plan
Oracle Recovery Structures and Processes
  • Architectural Components of Backup and Restore
  • Redo Logs, Checkpoints and Archives
  • Multiplexing Control Files and Redo Logs
  • Types of Database Failure
Memory Management
  • Automatic Shared Memory Management
  • PGA Memory Management
  • Automatic Memory Management
  • The Memory Advisor
  • Memory Allocation Advisors
  • Memory Management Data Dictionary Views
Using Archivelog and Noarchivelog Modes
  • The Archive Modes of a Database
  • Altering the Archive Mode of a Database
  • Configuring Multiple Archival Destinations
  • Configuring Multiple ARCH Processes
  • Data Dictionary Tables for Archiving
Troubleshooting Utilities
  • Database Synchronization
  • Using Log and Trace Files to Diagnose Problems
  • Detecting Block Corruption
  • The ANALYZE Command
  • The ANALYZE Command
  • Detecting Block Corruption
  • The DBMS_REPAIR Package
  • Use DBVERIFY to Validate the Database File Structure
  • Block Media Recovery
  • Automatic Diagnostic Repository (ADR)
  • The ADR Command Line Tool (ADRCI)
  • The Health Monitor
Recovery Manager Overview
  • Overview of Recovery Manager
  • RMAN Features and Components
  • Connect to RMAN
  • Start Up and Shut Down a Target Database Using RMAN
Create a Recovery Catalog
  • Create a Recovery Catalog
  • Use a Flashback Recovery Area
  • Register and Unregister a Database
  • Control File Information
  • Control File Information
  • RESYNC CATALOG command
  • Virtual Private Catalogs
  • Merge Catalogs
  • Backup a Recovery Catalog
Backing up with RMAN
  • Channel Allocation
  • The Configure Channel Command
  • Types of RMAN Backup
  • Recovery Manager Commands
  • Performing Backups with RMAN
  • The Backup Command
  • The Copy Command
  • Backup File Image Copies
  • Perform Full, Incremental and Cumulative Backups
  • Use Data Dictionary Tables
Maintain a Recovery Catalog
  • Reset Database Command
  • Change the Availability Status of Backups and Copies
  • Catalog Backups Made with Operating System Commands
  • Generate Reports and Lists
  • Configuration Values
  • Cross Check Backups and Copies
  • Delete Backups
  • Drop Database and Archival Backups
Restore and Recover with RMAN
  • Overview of Restore
  • The Restore Command
  • Restore a Database in Noarchivelog Mode
  • Restore and Recover a Database in Archivelog Mode
  • Incomplete Recovery using Until Time and Until Sequence
  • Restore and Recover a Tablespace
  • Automatic tempfile Recovery
  • Recover a Datafile Not Backed Up
  • Recover a Lost Redo Log Group
  • Re-create a Password Authentication File
  • Apply Incremental Backups to Restore Datafile Image Copies
  • The Switch command
  • The Data Recovery Advisor (DRA)
  • Restore and Recover the Database on a New Host
Create a Duplicate Database with RMAN
  • Overview of Database Duplication
  • Database Duplication
  • Duplication Options
  • Create Files for the Duplicate Database
  • Prepare an Auxiliary Instance for Duplication
  • Create a Duplicate Database
  • Clone a Running Database without a Backup
Manage Space for the Database
  • Transport Tablespaces
  • Transport Databases
Monitor, Tune RMAN
  • Recovery Manager Tuning Overview
  • Tuning RMAN Backup Performance
  • Synchronous and Asynchronous I/O
  • Instance Recovery Performance Tuning
  • RMAN Messages
  • Troubleshoot RMAN
  • RMAN Detected Block Corruptions
  • Configure and Use Flashback Database
  • Monitor Flashback Database
  • Flash Recovery Area Space Usage
  • Flashback Query
  • Retrieve Row History with Flashback Versions Query
  • Audit or Recover from Transactions with Flashback Transactions Query
  • Flashback Table
  • Recover Dropped Tables with Flashback Drop
  • The Recycle Bin
  • Recover Tables to a Point in Time with Flashback Table
  • Flashback Database
  • Flashback Restore Points
  • Flashback Transaction Backout
Oracle Total Recall
  • Overview of Oracle Total Recall
  • Manage Flashback Archives
  • Flashback Data Archive and Auditing
  • Flashback Data Archive Uses
Automate Tasks with the Scheduler
  • Introduction to the Scheduler
  • Scheduler Related Parameters
  • Access Rights
  • Create a Program
  • Drop a Program
  • Create a Schedule
  • Create a Job
  • Job Classes
  • Windows
  • Window Group
  • Monitoring and Logging
  • Use Time Based, Event Based and Complex Schedules
  • Multi Destination Jobs
Manage Space in Segments
  • Tablespace Monitoring
  • Segment Management Enhancements
  • Segment Advisor
  • Segment Space Estimation
  • Online Segment Shrink
  • Proactive Tablespace Management
Manage Space in Blocks
  • Tuning Activities
  • Use Statistic Preferences
  • Optimizer Statistics Collection
  • Monitor The Performance of Sessions And Services
  • Automatic Workload Repository (AWR)
  • The Benefits of Automatic Database Replay
Database Performance by SQL Tuning
  • Application and SQL Tuning
  • SQL Tuning Advisor
  • SQL Access Adviso
  • SQL Performance Analyze
Automatic Storage Management
  • Overview of ASM
  • ASM Instance Creation
  • SYSASM Role
  • Administer ASM Disk Groups
  • ASM Files
  • ASM Startup and Shutdown
  • ASM Data Dictionary Views
  • Migrate a Database to ASM Using RMAN
  • The ASM Command Line Tool
  • Use 4KB Sector Disks
Managing Resources with Resource Manager
  • Overview of the Database Resource Manager
  • Create Resource Plans
  • Create Resource Consumer Groups
  • Create Resource Plan Directives
  • Limit CPU Utilization at the Database Level
  • Instance Caging
  • Control Resources by User Groups
  • Specify an Instance Plan
  • Monitor the Resource Manager
  • Data Dictionary Views
Oracle Database 11g Performance Tuning
  • Tuning Questions
  • Who tunes
  • What to tune
  • How to tune
Monitoring With Basic Tools
  • Monitoring tools overview
  • Enterprise Manager
  • V$ views, Statistics and Metrics
  • Wait Events
  • Time Model: Overview
Identifying the Problem
  • Tuning Life Cycle Phases
  • Identify a Tuning Issue
  • Remedy one problem
Identifying Problem SQL Statements
  • Characteristics of a bad SQL statement
  • Role of the Optimizer
  • Generate explain plan
  • Access Paths Choices
  • Trace the execution
SQL Plan Management
  • Automatic Maintenance Tasks
  • SQL Profiles
  • SQL Access Advisor
  • SQL Outlines
  • SQL Plan Baselines
Change Management
  • Types of changes
  • SQL Performance Analyzer
  • DB Replay
  • Server-Generated Alerts
Using Metrics and Alerts
  • Benefits of Metrics
  • Database Control Usage Model
  • User-Defined SQL Metrics
Using AWR Based Tools
  • Automatic Maintenance Tasks
  • Using ADDM
  • Using Active Session History
  • Historical Data View
Monitoring an Application (Using Services)
  • Service Overview
  • Managing Service
  • Service Aggregation and Tracing
  • Tracing Your Session
  • Working with Metric Baselines
  • Setting Adaptive Alert Thresholds
  • Configuring Normalization Metrics
Tuning the Shared Pool
  • Shared Pool Operation
  • Mutex
  • Statspack/AWR Indicators
  • Library Cache Activity
  • Diagnostic Tools
  • UGA and Oracle Shared Server
  • Large Pool
Tuning the Buffer Cache
  • Architecture
  • Tuning Goals and Techniques
  • Symptoms
  • Solutions
Tuning PGA and Temporary Space
  • Monitoring SQL Memory Usage
  • Temporary Tablespace Management
Automatic Memory Management
  • Automatic Memory Management Architecture
  • Dynamic SGA Feature
  • Managing Automatic Memory Management
Tuning Block Space Usage
  • Space Management
  • Extent Management
  • Anatomy of a Database Block
  • Block Space Management
Tuning I/O
  • I/O Architecture
  • Striping and Mirroring
  • Using RAID
  • I/O Diagnostics
  • Using Automatic Storage Management
Performance Tuning: Summary
  • Important Initialization Parameters with Performance Impact
  • Database High Availability: Best Practices
  • Tablespace: Best Practices
  • Statistics Gathering
Using Statspack
  • Introduction to Statspack
  • Capturing Statspack Snapshots
  • Reporting with Statspack
  • Statspack considerations
  • Statspack and AWR
Download Oracle 11g DBA Course Contents : Oracle 10g DBA Training Course Contents
What We Provide
  Copyright © 2012. All Rights Reserved - Xperia Technologies Pvt. Ltd.

Home   Links   Privacy Policy   Terms of Use   Contact Us