Oracle DBA Online Training & Placement @ Crescent IT Solutions

1

• Crescent IT Solutions
• Visit http//www.crescentits.com
• Call Us [phone]-5479/2879, 704-248-2649

2
Oracle DBA Online Training Placement Support _at_
Crescent IT Solutions

• Oracle DBA - Course Content
• Introduction
• Identify the oracle product
• Describe the basic concept of a relational
  database
• Installing oracle database 10g software
• System requirements
• Use Oracle Optimal Flexible Architecture (OFA) 
• Install software with the Oracle Universal
  Installer
• Visit http//www.crescentits.com

3
Oracle DBA Online Training Placement Support _at_
Crescent IT Solutions

• Oracle DBA - Course Content
• Create an oracle database
• Oracle Database Architecture
• Oracle instance architecture
• Use the Database Creation Assistant
• Controlling the database
• Manually configure the Oracle 10g EM dbconsole
• Start and stop the agent 
• Start and stop the enterprise manager database
  console 
• Start and stop the listener 
• Startup and shutdown the database
• Visit
  http//www.crescentits.com

4
Oracle DBA Online Training Placement Support _at_
Crescent IT Solutions

• Oracle DBA - Course Content
• Storage Structures 
• Defining the tablespaces and data files
• Create tablespaces
• Manage tablespaces
• Obtain tablespace information
• Create and manage tablespace using oracle
  enterprises manager
• Visit
  http//www.crescentits.com

5
Oracle DBA Online Training Placement Support _at_
Crescent IT Solutions

• Oracle DBA - Course Content
• Administering users
• Create and manage database user accounts 
• Create and manage roles 
• Grant and revoke privileges 
• Oracle Database Security  ---  Only Theory
• Apply the principal of least privilege
• Manage default user accounts
• Implement standard password security features
• Visit
  http//www.crescentits.com

6
Oracle DBA Online Training Placement Support _at_
Crescent IT Solutions

• Oracle DBA - Course Content
• Oracle Net Services
• Understand Oracle Net concepts
• Use Oracle Net Manager to create and configure
  listeners
• Use the Oracle Net Manager to configure client
  and middle-tier connection
• Use TNSPING to test Oracle Net connectivity
• Visit
  http//www.crescentits.com

7
Oracle DBA Online Training Placement Support _at_
Crescent IT Solutions

• Oracle DBA - Course Content
• Performance Monitoring
• Gather optimizer statistics
• View performance metrics
• Monitoring and Managing Memory
• Oracle Memory Structures
• Automatic PGA Memory Management
• Using the Memory Advisor
• Using Automatic Shared Memory Management to avoid
  long running query issues
• Visit
  http//www.crescentits.com

8
Oracle DBA Online Training Placement Support _at_
Crescent IT Solutions

• Oracle DBA - Course Content
• Monitoring and Resolving Lock Conflicts
• Detect and resolve lock conflicts
• Manage deadlocks
• Diagnostic Sources
• The Alert Log
• Viewing Alerts with EM
• Alerts Notification   ----- Only Theory
• Editing Thresholds ----- Only Theory
• Trace Files
• Visit
  http//www.crescentits.com

9
Oracle DBA Online Training Placement Support _at_
Crescent IT Solutions

• Oracle DBA - Course Content
• Proactive Maintenance Objectives   ---  Only
  Theory
• Set warning and critical alert thresholds
• Collect and use baseline metrics
• Use tuning and diagnostic advisors
• Use the Automatic Database Diagnostic Monitor
  (ADDM)
• Visit
  http//www.crescentits.com

10
Oracle DBA Online Training Placement Support _at_
Crescent IT Solutions

• Oracle DBA - Course Content
• Automatic Storage Management  ---- Only Theory
• ASM Concepts
• ASM General Architecture
• Creating an ASM instance
• Creating tablespaces that use ASM storage
• Viewing ASM information
• Migrating a tablespace to use ASM storage.
• Visit
  http//www.crescentits.com

11
Oracle DBA Online Training Placement Support _at_
Crescent IT Solutions

• Oracle DBA - Course Content
• Undo Management  ---  Only Theory
• Monitor and administer undo
• Configure undo retention
• Guarantee undo retention
• Use the undo advisor
• Visit
  http//www.crescentits.com

12
Oracle DBA Online Training Placement Support _at_
Crescent IT Solutions

• Oracle DBA - Course Content
• Backup and Recovery    ---  Only Theory
• Describe the basics of database backup, restore
  and recovery
• List 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 file
• Visit
  http//www.crescentits.com

13
Oracle DBA Online Training Placement Support _at_
Crescent IT Solutions

• Oracle DBA - Course Content
• Managing Data
• Manipulating data through SQL
• Using Import
• Using Export
• Visit
  http//www.crescentits.com

14
Oracle DBA Online Training Placement Support _at_
Crescent IT Solutions

• Oracle DBA - Course Content
• Database backups
• Configure ARCHIVELOG mode
• Create consistent database backups
• Back your database up without shutting it down
• Create incremental backups
• Automate database backups
• Monitor the flash recovery area
• Visit
  http//www.crescentits.com

15
Oracle DBA Online Training Placement Support _at_
Crescent IT Solutions

• Oracle DBA - Course Content
• Managing schema objects
• Create and modify tables
• Define constraints
• View the attributes of a table
• View the contents of a table
• Create indexes and views
• Visit
  http//www.crescentits.com

16
Oracle DBA Online Training Placement Support _at_
Crescent IT Solutions

• Oracle DBA - Course Content
• Database Recovery
• Recover from loss of a control file
• Recover from loss of a redo log file
• Recover from loss of a data file
• Visit
  http//www.crescentits.com

17
Contact US

• Crescent IT Solutions
• Address 10919 west road,apt 518 Houston, Tx,
  USA, 77064
• Phone No [phone]-2649/713-589-2879/713-589-54
  79
• Toll Free 1-800-929-0849
• eMail training_at_crescentits.com
• Website http//www.crescentits.com