- 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
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
???
?
?
?
?
?
|
首頁 課程表 在線聊 報名 講師 品牌 QQ聊 活動 就業
班級規模及環境--熱線:4008699035 手機:15921673576( 微信同號)