Oracle Database 10g: Administration Workshop I (Self-Study Course)

 

Who should attend

  • Database administrators
  • Technical consultants
  • System analysts

Course Objectives

  • Introduction
  • Explain the course objectives
  • Identify the Oracle product line
  • Describe the basic concepts of a relational database
  • Know core database administrator tasks
  • Installing Oracle Database 10g Software
  • Identify system requirements
  • Use optimal flexible architecture
  • Install software with the Oracle Universal Installer
  • Create an Oracle Database
  • Describe Oracle Database Architecture
  • Understand the instance architecture
  • Use the management framework
  • Use the Database Creation Assistant
  • Data - Managing
  • Working with Databases

Product Description

  • Introduction
    • Explain the course objectives
    • Identify the Oracle product line
    • Describe the basic concepts of a relational database
    • Know core database administrator tasks
  • Installing Oracle Database 10g Software
    • Identify system requirements
    • Use optimal flexible architecture
    • Install software with the Oracle Universal Installer
  • Create an Oracle Database
    • Describe Oracle Database Architecture
    • Understand the instance architecture
    • Use the management framework
    • Use the Database Creation Assistant
  • Database interfaces
    • Use structured query language (SQL)
    • Use Procedural Language/Structured Query Language (PL/SQL)
    • Use Java
    • Use the Oracle C++ Call Interface (OCCI)
  • Controlling the database
    • Start and stop the agent
    • Start and stop the enterprise manager database console
    • Start and stop the listener
    • Startup and shutdown the database
  • Storage Structures
    • Define the purpose of tablespaces and data files
    • Create tablespaces
    • Manage tablespaces
    • Obtain tablespace information
    • Create and manage tablespaces using Oracle Managed Files (OMF)
  • Administering users
    • Create and manage database user accounts
    • Create and manage roles
    • Grant and revoke privileges
    • Control resource usage by users
  • 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
  • Managing Data
    • Manipulating data through SQL
    • Using Import
    • Using Export
    • Using SQL Loader
  • PL/SQL
    • Identify PL/SQL objects
    • Understand triggers and triggering events
    • Identify configuration options that affect PL/SQL performance
  • Oracle Database Security
    • Apply the principal of least privilege
    • Manage default user accounts
    • Implement standard password security features
    • Audit database activity
  • Oracle Net Services
    • Understand Oracle Net concepts
    • Use Oracle Net Manager to create and configure listeners
    • Use the listener control utility to control the Oracle Net Listener
    • Use the Oracle Net Manager to configure client and middle-tier connection
    • Use TNSPING to test Oracle Net connectivity
  • Oracle Shared Server
    • Understand when to use Oracle Shared Servers
    • Configure Oracle Shared Servers
    • Monitoring Shared Servers
  • Performance Monitoring
    • Troubleshoot invalid and unusable objects
    • Gather optimizer statistics
    • View performance metrics
    • React to performance issues
  • Proactive Maintenance: Objectives
    • Set warning and critical alert thresholds
    • Collect and use baseline metrics
    • Use tuning and diagnostic advisors
    • Use the Automatic Database Diagnostic Monitor (ADDM)
    • Manage the Automatic Workload Repository
  • Undo Management
    • Monitor and administer undo
    • Configure undo retention
    • Guarantee undo retention
    • Use the undo advisor
  • Monitoring and Resolving Lock Conflicts
    • Detect and resolve lock conflicts
    • Manage deadlocks
  • Backup and Recovery Concepts
    • 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
    • Configure ARCHIVELOG mode
  • 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
  • Database Recovery
    • Recover from loss of a control file
    • Recover from loss of a redo log file
    • Recover from loss of a data file

Price on request