• Oracle 10g: Administration I培訓
  Oracle 10g: Administration I培訓
  培訓大綱：
  1. Oracle Database 10g: Installing Oracle Database 10g Release 2
  Characteristics of a relational database system
  Basic tasks and tools involved in Oracle database administration
  Basic concepts involved in RDBMS and Oracle database administration
  Components involved in the Oracle preinstall process
  How to configure the Oracle Database 10g installation and Oracle install environment using the Oracle Universal Installer
  Install Oracle Database 10g on a UNIX operating system
  2. Oracle Database 10g: Creating Databases Release 2
  Files and logical storage units that make up the Oracle database
  Characteristics of the Oracle instance and its management interfaces
  Basic components of Oracle database architecture
  Configure database identification, management, password, and storage options using the Database Configuration Assistant
  Use the Database Configuration Assistant to set file locations and parameters
  Set database storage settings and creation options and delete a database using the Database Configuration Assistant
  Create an Oracle database, and delete one, using the Database Configuration Assistant
  3. Oracle Database 10g: Database Interfaces Release 2
  Ways of sending SQL commands to a database and how to start SQL*Plus and iSQL*Plus
  Use the DESCRIBE, PROMPT, and SELECT commands to work with data
  Join tables and use DML and DDL statements to manipulate and define data
  Functions of different SQL statements and the function of data locking
  Ways of sending SQL commands to a database and how to start SQL*Plus and iSQL*Plus
  Use SQL*Plus and iSQL*Plus to manage data
  Basic elements of PL/SQL and the uses of PL/SQL
  Characteristics of and how Oracle works within some common database interfaces
  4. Oracle Database 10g: Database Control and Storage Structures Release 2
  Use the Oracle Database 10g management framework
  Start up and shut down an Oracle 10g database
  Characteristics of initialization parameters and the alert log and how to view them
  Start and stop the Oracle Enterprise Manager Database Control, Oracle Listener, and Oracle Database 10g instance
  Recognize how table data is stored and create tablespaces as well as manipulate tablespaces in an Oracle database
  5. Oracle Database 10g: Users and Security Release 2
  Create user accounts and profiles, grant privileges and assign quotas to users, and create a role and assign it to a user
  Administer user accounts on an Oracle 10g database
  Restrict access to an Oracle database
  Implement database security by configuring user profiles
  Implement password security by configuring user profiles
  Monitor database activity using Oracle''s built-in audit tools
  Implement fine-grained auditing in an Oracle 10g database
  Audit database activity in an Oracle 10g database
  6. Oracle Database 10g: Managing Schema Objects and Data Release 2
  Basic features of objects in a database schema
  Create and modify tables in an Oracle 10g database
  Create, delete, and modify tables in an Oracle 10g database
  Recognize the most common index types, create indexes and views, and use sequences in an Oracle 10g database
  Work with indexes, views, and sequences in an Oracle 10g database
  Manipulate tables, views, and indexes in an Oracle 10g database
  Manage data using the INSERT, UPDATE, DELETE, COMMIT, and ROLLBACK commands
  Use Oracle''s Data Pump to export and import data
  Export and import data using Oracle''s Data Pump utility
  7. Oracle Database 10g: The SQL*Loader and PL/SQL Release 2
  Function of the SQL*Loader and the files it uses
  Load data using the SQL*Loader
  Characteristics of PL/SQL objects, functions, and procedures
  Characteristics of PL/SQL packages and triggers and the configuration options that control PL/SQL performance
  Basic concepts of PL/SQL
  8. Oracle Database 10g: Oracle Net Services and Shared Servers Release 2
  Create and configure an Oracle Net listener in Oracle Database 10g
  Monitor Oracle Net Services using the Listener Control utility
  Create and configure an Oracle Net Listener
  Configure local name resolution in a given scenario
  Configure local Oracle Net Services aliases
  Configure advanced connection options and test Oracle Net connectivity
  Oracle server connection types
  Initialization parameters used to configure Shared Server
  Monitor Shared Server
  Configure and verify Shared Server
  9. Oracle Database 10g: Monitoring and Maintenance Release 2
  Repair invalid and unusable objects
  Detect and repair unusable indexes
  Monitor performance using dynamic performance views, Enterprise Manager, and optimizer statistics
  Gather optimizer statistics for a database schema
  Set thresholds and baselines for performance metrics
  Functions of various tuning and diagnostic advisors and how to use them in a given scenario
  Manage the AWR and use the ADDM to review database performance in Oracle Database 10g
  Configure a database for proactive maintenance
  10. Oracle Database 10g: Managing Undo Data and Lock Conflicts Release 2
  Factors to take into consideration when managing undo
  Estimate required tablespace size and resize a tablespace in a given scenario
  Calculate undo tablespace sizing and resize an undo tablespace
  How locks are used to ensure concurrent user access to a database
  Manage lock conflicts
  Detect and resolve lock conflicts
  11. Oracle Database 10g: Managing Backup and Recovery Release 2
  Types of database failure that can occur in an Oracle 10g database and identify possible solutions
  Tune instance recovery and configure a database for maximum recoverability
  Multiplex the Oracle 10g redo log and archive redo log files
  Configure a database for backup and recovery
  Configure and manage database backups
  Schedule database backups and back up control files to trace
  Configure database backups
  Back up a database
  Types of media failure that can cause an instance to fail
  Recover from the loss of control files, redo log files, and datafiles
  Perform flashback recovery operations in Oracle database 10g
  Recover a database
  ?
  ?
  ?
• 
  ?
• 
  ?
• 
  ?
  ?
  ?
  ?
• 
  ?
  ?

?
?

?

?

?

?

?
?

?
?

?

?

?

?
???

?

?
?

?

?