 |
|
|
|
|
|
|
Classifieds: Education / Training | | Online Core DBA Training | | Posted By: Atul Kumar at: 24, Jun 2009 4:29:24 PM IST | Focus Thread is the Number 1 Online Oracle Apps Training company in the globe. Our low cost but high quality instructor lead trainings have received raving testimonials, see this link
http://www.focusthread.com/training/35-training-testimonials/87-training-
Our trainers are experienced consultants with many years of field experience. You can reap the benefits of their expertise, gained from several large scale real-life Oracle Apps implementations.
Visit us at http://www.focusthread.com/training
Course Fee: USD 399/-
Duration: 30 Days [training sessions weekends + hands-on practice on weekdays]
Training Schedule: 1,2, 8,9, 15, 16 August 09
COURSE CONTENTS:
Day 1
--------
Setting up VMware :
Introduction to VMWARE
Benefits of VMWARE
Usage of VMWARE
Create a VM machine (Linux / Windows)
Create Virtual disks
NAT
Mount ISO''s
Install Applications at VMWARE
Linux Install
Port forwarding (NAT)
Introduction to DBA
Relational Database Systems
Integrity Constraints
Structured Query Language
Tasks of an Oracle Database Administrator
Installation of Oracle Database Software
Optimal Flexible Architecture (OFA)
Oracle Universal Installer
Prerequisite Checks
Installation
Configuration Assistants
Creating an Oracle Database
Database Architecture
Exploring the Storage Structure
Control Files
Redo Log Files
Tablespaces and Datafiles
Segments, Extents, and Blocks
Oracle Instance Management
Oracle Memory Structures
Oracle Processes
Data Dictionary
Database Control
Grid Control
Database Configuration Assistant (DBCA) Overview
Creating a Database
Passwords and Storage
File Locations and Backup Recovery
Content and Initialization Parameters
Other Actions with DBCA
Day 2
-------
Managing the Database
Starting and Stopping iSQL*Plus
Starting and Stopping Database Control
Accessing Database Control
SYSOPER and SYSDBA
Database Home Page
Changing the Listener Status
NOMOUNT MOUNT OPEN States
SHUTDOWN Options
Initialization Parameter Files
Viewing the Alert Log
Net Services
Oracle Net Services
Oracle Net Listener
Monitoring the Listener
Listening Addresses
Static Database Registration
Listener Control Utility
Oracle Net Connections
Directory Naming
Advanced Connections
Oracle Net Manager
Configuring Service Aliases with Net Manager
Managing Schema Objects
Schemas
Accessing Schema Objects
Schema Object Namespaces
Specifying Data Types in Tables
Other Data Types
Creating and Modifying Tables
Understanding Data Integrity
Defining Constraints
Viewing the Attributes of a Table
Viewing the Contents of a Table
Creating Indexes
Creating Views
Using a Sequence
Day 3
-----
Storage Structures
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 tablespace
Undo 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
Day 4 and Day 5
--------------------
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
Incomplete 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)
Some FAQs related to this course:
1) Where is the Location of training?
- This training is done online, using interactive Web Conferencing software. Hence you do not need to travel and can attend the training from home. The participants will be able to get their queries answered in real-time from the trainer.
2) How about Audio?
- You will listen to the instructor using an interactive audio Conferencing software. Hence, this training will be more of a one on one interaction training where you can ask your doubts at time of training session.
3) What is the cost of the training course?
- $ 399 (Three Hundred & Ninety Nine US Dollars Only) for entire course.
4) What is the duration?
- The training is scheduled for one month. Training sessions will be conducted on weekends. Also, we will provide hands-on support during weekdays.
5) What will be the timings of training?-
Indian Standard Time (IST) – 5:30 pm
Eastern Standard Time (EST) – 8:00 am
Greenwich Mean Time (GMT) – 12:00 pm
Pacific Standard Time (PST) - 5:00 am
Mountain Standard Time (MST) – 6:00 am
Central Standard Time (CST) - 7:00 am
6)Would we be provided with learning material?
- We will send you soft of training material via email. |
| |
More Education / Training classifieds |
|
|
|
|
|
| Advertisements |
|
|
|
|
| Advertisements |
|
