Oracle 10g Security Administration培訓(xùn)
Oracle 10g Security Administration培訓(xùn)
培訓(xùn)大綱：
1. SQL and PL/SQL
Basic SQL Syntax
Advanced SQL Queries
PL/SQL Program Structure
Accessing the Database
Handling Exceptions
2. Create an Oracle Database
Oracle Database Architecture
Instance Architecture
Management Framework and the Database Creation Assistant
3. Controlling the Database
Start and Stop the Agent, the Enterprise Manager Database Console, and the Listener
Startup and Shutdown the Database
4. Administering Users
Create and Manage Database User Accounts and Manage Roles
Grant and Revoke Privileges
Control User Resource Usage
5. Managing Schema Objects
Create and Modify Tables, Indexes and Views, and Define Constraints
View the Attributes and the Contents of a Table
6. Oracle Database Security
Apply the Principal of Least Privilege
Manage Default User Accounts
Implement Standard Password Security Features and Audit Database Activity
7. Proactive Maintenance: Objectives
Set Warning and Critical Alert Thresholds
Collect and Use Baseline Metrics
Use Tuning/Diagnostic Advisors/ADDM/ADR
8. Recovery Manager Configuration
Parameters Affecting RMAN
Use of a Flashback Recovery Area
The CONFIGURE Command
Persistent Settings
NOCATALOG / CATALOG Mode
Channel Allocation
Controlfile Autobackup
Retention Policies
9. Recovery Manager Operations
Using the BACKUP Command
Creating Backup Sets / Image Copies
Compressed Backups
Incremental Backups
Block Change Tracking
RMAN Backup Monitoring
REPORT and LIST commands
10. Non-Critical Loss Recovery
Password and Network Files
Read-Only Tablespaces
Temporary Tablespaces
Index Tablespaces
Redo Log Members / Control Files
11. Database Recovery
Complete Recovery
Incomplete Recovery
12. Automatic Database Management
Management and Advisory Framework
Automatic Statistics Collection
Automated Workload Repository
Database Advisors
Automatic Statistics Collection
13. Virtual Private Database
Row-Level Control
14. Column-Level Security
Column-Level Control
15. Oracle Auditing
16. Full Security Monitoring
DBMS_ADVISIOR
Quick Tune
?
?
?
?

?

?
?

?

?