Training on dba 10G,11G in Hyderabad - Hyderabad

Saturday, 11 December 2010

Item details

City: Hyderabad, Andhra Pradesh
Offer type: Offer
Price: Rs 8,000

Contacts

Contact name sudhakardas
Phone 9246554001

Item description

Oracle Database 10g/11g: Administration
What you will learn at S.L. Data Solutions?
This course is your first step towards success as an Oracle professional, designed to give you a firm foundation in basic database administration. In this class, you'll learn how to install and maintain an Oracle database. You will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. You will also learn 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, backup/recovery techniques, recovering the database using RMAN and Flashback technology. Database performance monitoring, in addition to the steps to take to resolve common problems and improve performance.
Prerequisites:
Knowledge of SQL and PL/SQL
Course Objectives:
Install Oracle Database 10g and configure a database
Manage the Oracle instance
Manage the Database storage structures
Create and administer user accounts
Configure Oracle Net services
Perform backup and recovery of a database
Move data between databases and files
Use RMAN to create and manage backup sets and image copies
Recover the database to a previous point in time
Use Oracle's Flashback technology to recover your database
Monitor, troubleshoot, and maintain a database
Use the various Database advisors and views to monitor and improve database performance
Review database log files for diagnostic purposes
Transport data across platforms
Patching using opatch tool
Cloning using EM/Manual methods
Creating Standby database to get availability
Basic concepts of RAC (Real application cluster) to implement high availability
Course Topics
Introduction (Database Architecture
Describe course objectives
Explore the Oracle 10g database architecture
Installing the Oracle Database Software
Explain core DBA tasks and tools
Plan an Oracle installation
Use optimal flexible architecture
Creating an Oracle Database
Create a database with the Database Configuration Assistant (DBCA
Create a database design template with the DBCA
Generate database creation scripts with the DBCA
Managing the Oracle Instance
Start and stop the Oracle database and components
Access a database with SQL*Plus and iSQL*Plus
Modify database initialization parameters
Understand the stages of database startup
View the Alert log
Managing Database Storage Structures
Describe table data storage (in blocks
Define the purpose of tablespaces and data files
Understand and utilize Oracle Managed Files (OMF
Create and manage tablespaces
Obtain tablespace information
Describe the main concepts and functionality of Automatic Storage Management (ASM
Administering User Security
Create and manage database user accounts
Authenticate users
Assign default storage areas (tablespaces
Grant and revoke privileges
Create and manage roles
Create and manage profiles
Implement standard password security features
Control resource usage by users
Managing Schema Objects
Define schema objects and data types
Create and modify tables
Define constraints
View the columns and contents of a table
Create indexes, views and sequences
Explain the use of temporary tables
Use the Data Dictionary
Managing Data and Concurrency
Manage data through SQL
Identify and administer PL/SQL Objects
Describe triggers and triggering events
Monitor and resolve locking conflicts
Managing Undo Data
Explain DML and undo data generation
Monitor and administer undo
Describe the difference between undo and redo data
Configure undo retention
Guarantee undo retention
Use the undo advisor
Implementing Oracle Database Security
Describe DBA responsibilities for security
Apply the principal of least privilege
Enable standard database auditing
Specify audit options
Review audit information
Maintain the audit trail
Configuring the Oracle Network Environment
Use Enterprise Manager for configuring the Oracle network environment
Create additional listeners
Create Net Service aliases
Configure connect-time failover
Control the Oracle Net Listener
Test Oracle Net connectivity
Identify when to use shared versus dedicated servers
Proactive Maintenance
Use statistics
Manage the Automatic Workload Repository (AWR
Use the Automatic Database Diagnostic Monitor (ADDM
Describe advisory framework
Set alert thresholds
Use server-generated alerts
Use automated tasks
Performance Management
Use Enterprise Manager pages to monitor performance
Use the SQL Tuning Advisor
Use the SQL Access Advisor
Use Automatic Shared Memory Management
Use the Memory Advisor to size memory buffers
Use performance related dynamic views
Troubleshoot invalid or unusable objects
Backup and Recovery Concepts
Identify the types of failure that may occur in an Oracle Database
Describe ways to tune instance recovery
Identify the importance of checkpoints, redo log files, and archived log files
Configure ARCHIVELOG mode
Performing Database Backups
Create consistent database backups
Back your database up without shutting it down
Create incremental backups
Automate database backups
Monitor the flash recovery area
Performing Database Recovery
Recover from loss of a control file
Recover from loss of a redo log file
Perform complete recovery following the loss of a data file
Performing Flashback
Describe Flashback database
Restore the table content to a specific point in the past with Flashback Table
Recover from a dropped table
View the contents of the database as of any single point in time with Flashback Query
See versions of a row over time with Flashback Versions Query
View the transaction history of a row with Flashback Transaction Query
Moving Data
Describe available ways for moving data
Create and use directory objects
Use SQL*Loader to load data from a non-Oracle database (or user files
Backups
Backing up the data using regular backups like exp/imp
Data backup using cold and hot methods
RMAN backups
Configuring Recovery Manager
Recovery Manager Features and Components
Using a Flash Recovery Area with RMAN
Configuring RMAN
Control File Autobackups
Retention Policies and Channel Allocation
Using Recovery Manager to connect to a target database in default NOCATALOG mode
Displaying the current RMAN configuration settings
Altering the backup retention policy for a database
Recovering from Non-critical Losses
Recovery of Non-Critical Files
Creating New Temporary Tablespace
Recreating Redo Log Files, Index Tablespaces, and Indexes
Read-Only Tablespace Recovery
Authentication Methods for Database Administrators
Loss of Password Authentication File
Altering the default temporary tablespace for a database
Incomplete Recovery
Recovery Steps
Server and User Managed Recovery commands
Recovering a Control File Autobackup
Creating a New Control File
Incomplete Recovery Overview
Incomplete Recovery Best Practices
Simplified Recovery Through RESETLOGS
Point-in-time recovery using RMAN
Flashback
Flashback Database Architecture
Configuring and Monitoring Flashback Database
Backing Up the Flash Recovery Area
Using V$FLASH_RECOVERY_AREA_USAGE
Flashback Database Considerations
Using the Flashback Database RMAN interface
Using Flashback Database EM Interface
Managing and monitoring Flashback Database operations
Automatic Storage Management
ASM General Architecture and Functionalities
Dynamic Performance View Additions
Managing an ASM Instance
ASM Disk Groups
Using asmcmd Command Line
Migrating Your Database to ASM Storage
Creating an ASM instance in a separate Oracle Home
Migrating a tablespace to use ASM storage
Patches
Patch is bugfix/enhancement
Patch applications using OPatch tools
Cloning
cloning the instance using manual methods
EM tool is another way for automated cloning
Create mirrored copies for testing
Availability
creating standby database setup to avoid disaster recovery
Basic knowledge towards RAC (Earlier OPS
Versions:
Complete course will be on 10g/11g
Knowledge towards 9i and obsoleted features in former versions