H2K Home HOME
Contact H2K CONTACT

Courses Offered


Follow us on

Twitter    Facebook    LinkedIn     Youtube

Demo Schedules

New Demo Schedules

Demo sessions for the month of April 2010




MAKE A PAYMENT

Enter the Amount to Pay & Click the button

$.00


TESTIMONIALS


Thank you for all the support to our team and project. Your training helped  a lot to move forward quickly. Thanks a lot

Manager, McKesson










Greetings!
SAP class was simply excellent! Thank you! You were just too good!!!
I'm glad I attended your training classes. It seems pretty simple and  interesting now. I want to start practicing on it. After I'm done with, may be I'll ask for any help I need. Your teaching techniques are easy to understand, help to build more confidence to work on real time projects.

Regards,
Mani










Hi H2K Infosys Team,
Thank you for providing me training. After I took training from you and worked on few projects as per your guidance and Now I settled as software QA analyst. When I joined your training, I am new to IT field, at present I am IT pro and  helping my co workers who have been working from a while. I owe a lot to H2K Infosys. I pray god every day to grow H2K Infosys. Good Luck.

Mathew










To be frank I was very satisfied with your training for what I have paid, And Thats why I keep telling my friends about your training center ,when they ask me ,I will do so in the present and in future also. Since I liked your training class I tell my friends and I want them also to be benefited like me. And one more thing is that u give us chances to attend the classes n number of times which is hard to find in other training centers, through that way we learn different things and concepts, through different teaching staffs. At times u also gives importance to our decisions and conveniences which is really great. Whoever asks me for sure I will say your training center only at present and in future also. I have heard many of training centers through my friends and I feel urs is good in some way or the other. Good work.

Thank you,
Sridevi










Again I'm really pleased with the course, told someone in my company how great it is; and now she's interested in taking the course as well.

Thank you,
Lak








COURSES > Oracle DBA

Oracle







Oracle 11g featuers will be discussed

DETAILS

Installing the Oracle Database 10g
Installing the Oracle Database 10g Software
Explain core DBA tasks and tools
Plan an Oracle installation
Use optimal flexible architecture
Install software with the Oracle Universal Installer (OUI)

Creating an Oracle 10g Database
Creating an Oracle 10g Database
Create a database with the DatabaseConfiguration Assistant (DBCA)
Create a database design template with the DBCA
Generate database creation scripts with the DBCA

Managing the Oracle Instance
Managing the Oracle Instance
Start and stop the Oracle database and components
Use Enterprise Manager (EM)
Access a database with SQL*Plus and iSQL*Plus
Modify database initialization parameters
Understand the stages of database startup
View the Alert log
Use the Data Dictionary

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
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 in Oracle
Managing Schema Objects in Oracle 10g Database
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 Undo Data
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

Configuring the Oracle Network Environment
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
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
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

Oracle 10g Database Backup
Oracle 10g Database 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
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
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
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
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)
Explain the general architecture of Data Pump
Use Data Pump Export and Import to move data between Oracle databases
Use external tables to move data via platform-independent files

Configuring Recovery Manager
Configuring Recovery Manager in Oracle 10g Database
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

Recovery Manager(RMAN)
Using Recovery Manager(RMAN)
RMAN Command Overview
Parallelization of Backup Sets
Compressed Backups
Image Copy
Whole Database and Incremental Backups
LIST and REPORT commands
Enable ARCHIVELOG mode for the database
Use Recovery Manager
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
Creating a new temporary tablespace
Altering the default temporary tablespace for a database

Incomplete Recovery
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
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

Monitoring and Managing Memory
Monitoring and Managing Memory in Oracle 10g Database
Oracle Memory Structures
Automatic Shared Memory Management
SGA Tuning Principles
Database Control and Automatic Shared Memory Management
Behavior of Auto-Tuned and Manual SGA Parameters
Resizing SGA_TARGET
PGA Management Resources
Using the Memory Advisor

Performance Management
Automatic Performance Management
Identifying Tunable Components
Oracle Wait Events and System Statistics
Troubleshooting and Tuning Views
Direct Attach to SGA for Statistic Collection
Workload Repository
Advisory Framework
ADDM Scenarios and Usage Tips
Using the SQL Tuning and SQL Access Advisor

Monitoring and Managing Storage
Monitoring and Managing Storage
Database Storage Structures
Space Management Overview
Oracle-Managed Files (OMF)
Row Chaining and Migrating
Proactive Tablespace Monitoring
Managing Resumable Space Allocation
SYSAUX Tablespace
Monitoring table and index space usage

Automatic Storage Management
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

Automating Tasks
Patching, cloning, upgrade and migration
High availability architecture
Oracle 11g features will be covered.