 |
 |
 |
|
We have always received excellent feedback from our Trainees. Please have a look at them - here To know about the schedule of our trainings, click here. Our next batch of Online - Oracle Core DBA Training is scheduled on 11th September 2010. Our online Core DBA Training is mostly hands-on based. It will help candidates to learn Oracle 10g Database Architecture and day-to-day activities of a DBA such as Database installation, backup & recovery, troubleshooting performance issues. We give special care to every trainee to complete the hands-on lab exercises on each topic. Extra topics on Linux is also covered to help trainees get comfortable with Linux. Live demo to every concept is provided as part of weekend discussions. Latest technologies in server virtualization is used and can be easily implemented on individual trainees' workstations. Course Fee: USD 399/- [Theory sessions on Weekends + Hands-on practice on Weekdays as per your availability] Training Schedule: 11, 12, 18, 19, 25 & 26 September 2010 See the Detailed Course Breakdown Below By Scrolling Down COURSE CONTENTS:
Day 1 Setting up VMware : Introduction to VMWARE Introduction to DBA
Managing the Database
Managing Schema Objects Tablespaces and Data Files Space Management in Tablespaces Storage for Locally Managed Tablespaces Altering a Tablespace Actions with Tablespaces Dropping Tablespaces Viewing Tablespace Information Administering Users Database User Accounts Creating a User Profiles and Users Authenticating Users Database Users and Schemas Privileges : System and Object Roles Assigning Quota to Users Assigning Roles to Users Managing Data Objectives Manipulating Data Through SQL The INSERT Command The UPDATE Command The DELETE Command The COMMIT and ROLLBACK Commands Integrity Constraints and DML Data Pump Export Data Pump Import DIRECTORY Objects SQL*Loader The SQL*Loader Control File Control File Syntax Considerations Input Data and Data Files Loading Methods Comparing Direct and Conventional Path Loads Loading Data with SQL*Loader External Tables Transportable tablespaceUndo Management Undo Data Transactions and Undo Data Storing Undo Information Monitoring Undo Administering Undo Configuring Undo Retention Guaranteeing Undo Retention Sizing the Undo Tablespace Using the Undo Advisor -------------------- Backup and Recovery Concepts Backup and Recovery Issues Categories of Failures Instance Recovery Phases of Instance Recovery Tuning Instance Recovery Using the MTTR Advisor Configuring for Recoverability ARCHIVELOG Mode Configuring Backup Strategy Scheduling Backups: Review Backup Control File to Trace Manage Backups Database Recovery Opening a Database Changing Instance Status Keeping a Database Open Scenarios: Loss of a Control File Loss of a Redo Log File Loss of a Data File in NOARCHIVELOG Mode Loss of a Noncritical Data File in ARCHIVELOG Mode Loss of a System-Critical Data File in ARCHIVELOG Mode Oracle Recovery Manager Oracle Recovery Catalog maintenance Backups using Oracle Recovery Manager Recovery using Oracle recovery manager Database Cloning using RMAN Tablespace Point in time recovery Day 6 ----- Monitoring and Resolving Lock Conflicts Locks Locking Mechanism Data Concurrency DML Locks Enqueue Mechanism Lock Conflicts Possible Causes of Lock Conflicts Detecting Lock Conflicts Resolving Lock Conflicts Deadlocks Performance Monitoring Performance Monitoring Monitoring Methodologies Database and Instance Metrics Data Dictionary Metrics Optimizer Statistics Schedule Optimizer Statistics Collection Dynamic Performance Views Viewing Metric Information Reacting to Performance Issues Reacting to Performance Issues Proactive Maintenance Server Generated Alerts Thresholds Setting Thresholds Baseline Measurements Tuning and Diagnostic Advisors SQL Tuning and Access Advisors Memory Advisors Segment Advisor Automatic Workload Repository (AWR) Managing the AWR Automatic Database Diagnostic Monitor (ADDM)
|