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
如果您想学习本课程，请
预约报名
如果没找到合适的课程或有特殊培训需求，请
订制培训
除培训外，同时提供相关技术咨询与技术支持服务，有需求请发需求表到邮箱soft@info-soft.cn,或致电4007991916
技术服务需求表点击在线申请
服务特点：
海量专家资源，精准匹配相关行业，相关项目专家，针对实际需求，顾问式咨询，互动式授课，案例教学，小班授课，实际项目演示，快捷高效，省时省力省钱。
专家力量：
中国科学院软件研究所，计算研究所高级研究人员
oracle,微软，vmware，MSC,Ansys，candence,Altium,达索等大型公司高级工程师，项目经理，技术支持专家
中科信软培训中心，资深专家或讲师
大多名牌大学，硕士以上学历，相关技术专业，理论素养丰富
多年实际项目经历，大型项目实战案例，热情，乐于技术分享
针对客户实际需求，案例教学，互动式沟通，学有所获
