Oracle 11g Data Base Administration Express Introduction for Support Personnel (OR227 11g)培训课程
培训大纲：
1. Introduction
- Basic Concepts of a Relational Database
- Core Database Administrator Tasks
2. Architecture
- Oracle Database Architecture
- Instance Architecture
- Use the Management Framework
- 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. Storage Structures
- Purpose of Tablespaces and Data Files
- Create and Manage Tablespaces
- Obtain Tablespace Information
5. Administering Users
- Create and Manage Database User Accounts
- Manage Roles
- Grant and Revoke Privileges
- Control Resource Usage by Users
6. Oracle Database Security
- Apply the Principal of Least Privilege
- Manage Default User Accounts
- Implement Standard Password Security Features
- Audit Database Activity
7. Oracle Net Services
- Oracle Net Concepts
- Use Oracle Net Manager to Create and Configure Listeners
- Configure Client and Middle-Tier Connection
- Use the Listener Control Utility to Control the Oracle Net Listener
- Use TNSPING to Test Oracle Net Connectivity
8. Performance Monitoring
- Troubleshoot Invalid / Unusable Objects
- Gather Optimizer Statistics
- View Performance Metrics
- Reacting to Performance Issues
9. Diagnostic Sources
- Alert Logs and Trace Files
- Enterprise Manager and Alerts
- Controlling Trace File Size
- Alert Notification
10. Backup and Recovery Concepts
- Basics of Database Backup, Restore, and Recovery
- Types of Failure that May Occur in an Oracle Database
- Ways to Tune Instance Recovery
- Importance of Checkpoints, Redo Log Files, and Archived Log File
- Configure ARCHIVELOG Mode
- Flashback Database / Table / Query
11. Database Backups
- Create Consistent Database Backups and Incremental Backups
- Automate Database Backups
- Monitor the Flash Recovery Area
- Back Up Your Database without Shutting It Down
12. Database Recovery
- Loss of a Control File
- Loss of a Redo Log File
- Loss of a Data File
- A Day in the Life of a DBA
- Periodic and As Needed Tasks
13. Scheduler
- Creating Jobs and Job Classes
- Creating Schedules and Windows
- Scheduler Programs
- Prioritizing Jobs
- Scheduler Component Reuse
- Query Scheduler Information
14. SQL Tuning Tools
- Optimizer Overview
- Execution Plans
- Rule-Based Optimization (Desupported)
- Cost-Based Optimization
- Table and Index Statistics
- DBMS_STATS
- Execution Plans
- Autotrace
- SQL_TRACE and TKPROF
- Using Hints
- Stored Outlines and Plan Stability
15. Performance Tuning
- Application Identification
- Enterprise Manager Tools
- SQL Tuning Advisor
- SQL Access Advisor
- DBMS_SQLTUNE
- DBMS_ADVISIOR
- Quick Tune
如果您想学习本课程，请
预约报名
如果没找到合适的课程或有特殊培训需求，请
订制培训
除培训外，同时提供相关技术咨询与技术支持服务，有需求请发需求表到邮箱soft@info-soft.cn,或致电4007991916
技术服务需求表点击在线申请
服务特点：
海量专家资源，精准匹配相关行业，相关项目专家，针对实际需求，顾问式咨询，互动式授课，案例教学，小班授课，实际项目演示，快捷高效，省时省力省钱。
专家力量：
中国科学院软件研究所，计算研究所高级研究人员
oracle,微软，vmware，MSC,Ansys，candence,Altium,达索等大型公司高级工程师，项目经理，技术支持专家
中科信软培训中心，资深专家或讲师
大多名牌大学，硕士以上学历，相关技术专业，理论素养丰富
多年实际项目经历，大型项目实战案例，热情，乐于技术分享
针对客户实际需求，案例教学，互动式沟通，学有所获
