Classes
ORACLE COURSES
ORACLE DBA

Duration: 40 Classroom Hours, weekends and weekday evenings.
ORACLE Access: 2 Months ORACLE access for practice and home study from the date of enrollment.

Course Outline

Oracle10g™ Database: Administration I ™

  • Installing Oracle10g™ Database Software
  • Identify system requirements
  • Use Optimal Flexible Architecture
  • Install software with Oracle Universal Installer
  • Identify and configure commonly used environment variables
  • Creating an Oracle Database
  • Explain the Oracle database architecture
  • Explain the instance architecture
  • Use the management framework
  • Use DBCA to Create a database
  • Use DBCA to Configure a database
  • Use DBCA to Drop a database
  • Use DBCA to Manage templates
  • 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
  • Name database objects
  • Select appropriate data types
  • Create and use sequences
  • Managing Data
  • Manipulate data through SQL using INSERT, UPDATE, and DELETE
  • Use Data Pump to export data
  • Use Data Pump to import data
  • Load data with SQL Loader
  • Create directory objects
  • PL/SQL
  • Identify PL/SQL objects
  • Describe triggers and triggering events
  • Identify configuration options that affect PL/SQL performance
  • Undo Management
  • Monitor and administer undo
  • Configure undo retention
  • Guarantee undo retention
  • Use the Undo Advisor
  • Describe the relationship between undo and transactions
  • Size the undo tablespace
  • Monitoring and Resolving Lock Conflicts
  • Detect and resolve lock conflicts
  • Manage deadlocks
  • Describe the relationship between transactions and locks
  • Explain lock modes within the Oracle10g™ Database
  • Database Interfaces
  • Use SQL*Plus and iSQL*Plus to access the Oracle10g™ Database
  • Use SQL*Plus and iSQL*Plus to describe the logical structure of tables
  • Use SQL to query, manipulate, and define data using SELECT, UPDATE/INSERT/DELETE and
  • CREATE/ALTER/DROP statements
  • Identify common database interfaces
  • Describe a database transaction
  • Controlling the Database
  • Start and stop iSQL*Plus
  • Start and stop Enterprise Manager Database Control
  • Start and stop the Oracle Listener
  • Start up and shut down Oracle10g™ Database
  • Describe startup and shutdown options for the Oracle Database
  • Handle Parameter files
  • Locate and view the Database alert log
  • Oracle Database Security
  • Apply the principal of least privilege
  • Manage default user accounts
  • Implement standard password security features
  • Audit database activity
  • Register for security updates
  • Oracle Net Services
  • Use Database Control to Create additional listeners
  • Use Database Control to Create Oracle Net service aliases
  • Use Database Control to Configure connect time failover
  • Use Listener features
  • Use the Oracle Net Manager to configure client and middle-tier connections
  • Use TNSPING to test Oracle Net connectivity
  • Describe Oracle Net Services
  • Describe Oracle Net names resolution methods
  • Backup and Recovery Concepts
  • Describe the basics of database backup, restore and recovery
  • Describe 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
  • Configure a database for recoverability
  • Storage Structures
  • Define the purpose of tablespaces and data files
  • Create tablespaces
  • Manage tablespaces (alter, drop, generate DDL, take offline, put on line, add data files, make
    read-only/read-write)
  • Obtain tablespace information from EM and the data dictionary
  • Drop tablespaces
  • Describe the default tablespaces
  • Administering Users
  • Create and manage database user accounts
  • Create and manage roles
  • Grant and revoke privileges
  • Control resource usage by users
  • Oracle Shared Servers
  • Identify when to use Oracle Shared Servers
  • Configure Oracle Shared Servers
  • Monitor Shared Servers
  • Describe the shared server architecture
  • Performance Monitoring
  • Troubleshoot invalid and unusable objects
  • Gather optimizer statistics
  • View performance metrics
  • React to performance issues
  • Proactive Maintenance
  • 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
  • Describe server generated alerts
  • Database Backups
  • Create consistent database backups
  • Back up your database without shutting it down
  • Create incremental backups
  • Automate database backups
  • Monitor the flash recovery area
  • Describe the difference between image copies and backup sets
  • Describe the different types of database backups
  • Backup a control file to trace
  • Manage backups
  • Database Recovery
  • Recover from loss of a Control file
  • Recover from loss of a Redo log file
  • Recover from loss of a system-critical data file
  • Recover from loss of a non system-critical data file

Oracle10g™ Database: Administration II ™

  • Using Globalization Support Objectives
  • Customize language-dependent behavior for the database and individual sessions
  • Specify different linguistic sorts for queries
  • Use datatime datatypes
  • Query data using case insensitive and accent insensitive searches
  • Obtain Globalization support configuration information
  • Securing the Oracle Listener
  • Secure the listener
  • Remove default EXTPROC entry and add a separate listener to handle external procedure calls
  • Configuring Recovery Manager
  • Configure database parameters that affect RMAN operations
  • Change RMAN default settings with CONFIGURE
  • Manage RMAN's persistent settings
  • Start RMAN utility and allocate channels
  • Recovering from User Errors
  • Recover a dropped table using Flashback technology
  • Perform Flashback table operation
  • Manage the recycle bin
  • Recover from user errors using Flashback versions query
  • Perform transaction level recovery using Flashback Transaction query
  • Dealing with Database Corruption
  • Define block corruption and list its causes and symptoms
  • Detect database corruptions using the following utilities: ANALYZE DBVERIFY
  • Detect database corruptions using the dbms_repair package
  • Implement the DB_BLOCK_CHECKING parameter to detect corruptions
  • Repair corruptions using RMAN
  • Automatic Database Management
  • Use the Database Advisors to gather information about your database
  • Use the SQL Tuning Advisor to improve database performance
  • Use automatic undo retention tuning
  • Using Recovery Manager
  • Use the RMAN BACKUP command to create backup sets and image copies
  • Enable block change tracking
  • Manage the backups and image copies taken with RMAN with the LIST and REPORT
    commands
  • Diagnostic Sources
  • Use the alert log and database trace files for diagnostic purposes
  • View alerts using Enterprise Manager
  • Adjust thresholds for tracked metrics
  • Control the size and location of trace files
  • Recovering from Non-Critical Losses
  • Recover temporary tablespaces
  • Recover a redo log group member
  • Recover index tablespaces
  • Recover read-only tablespaces
  • Recreate the password file
  • Monitoring and Managing Storage
  • Tune redo writing and archiving operations
  • Issue statements that can be suspended upon encountering space condition errors
  • Reduce space-related error conditions by proactively managing tablespace usage
  • Reclaim wasted space from tables and indexes using the segment shrink functionality
  • Estimate the size of new table and indexes
  • Use different storage options to improve the performance of queries
  • Rebuild indexes online
  • Automatic Storage Management
  • Set up initialization parameter files for ASM and database instances
  • Execute SQL commands with ASM file names
  • Start up and shut down ASM instances
  • Administer ASM disk groups
  • Use RMAN to migrate your database to ASM
  • Monitoring and Managing Memory
  • Implement Automatic Shared Memory Management
  • Manually configure SGA parameters for various memory components in the SGA
  • Use Automatic PGA Memory Management
  • Database Recovery
  • Recover the control file
  • Explain reasons for incomplete recovery
  • Perform incomplete recovery using EM
  • Perform incomplete recovery using RMAN
  • Perform incomplete recovery using SQL
  • Perform database recovery following a RESETLOGS operation
  • Flashback Database
  • Determine which flashback technology to use for each recovery situation
  • Configure and sue Flashback Database
  • Monitor the Flashback Database
  • Use the Enterprise Manager Recovery Wizard to flashback database
  • Manage (or maintain) the Flash Recovery Area
  • Managing Resources
  • Configure the Resource Manager
  • Assign users to Resource Manager groups
  • Create resource plans within groups
  • Specify directives for allocating resources to consumer groups
  • Automating Tasks with the Scheduler
  • Simplify management tasks by using the Scheduler
  • Create a job, program, schedule, and window
510-440-1200 or via email
info@mtiedge.com