课程培训
Oracle 11g: Administration I培训

Oracle 11g: Administration I培训

培训大纲:
1. Oracle Database 11g: Database Architecture and Installation
Main structural components of Oracle Database 11g
Components of the Oracle Database 11g memory structures
Functions of the Oracle Database 11 server and background processes
How information is stored and structured within the Oracle Database 11g storage architecture
Necessary tasks and essential tools required to administer an Oracle Database 11g database
Planning and carrying out an installation of Oracle Database 11g software using the Oracle Universal Installer (OUI)
Install Oracle Database 11g software in a given scenario
2. Oracle Database 11g: Database Creation, Instance Management, and Connectivity
Creating, configuring, or deleting a database using the Database Configuration Assistant (DBCA) and managing a database instance using various Oracle tools
Scope and capabilities of Oracle Database 11g initialization parameters and the steps for maintaining them
Configuring database startup and shutdown options, administering a blackout, and using alerts and dynamic data to assess database performance
Using the Data Dictionary to find information about users, objects, constraints, and storage
Create a database using the DBCA and manage instances using Enterprise Manager
Ways of configuring and managing the Oracle network and the steps for creating a new Oracle Net Listener via Enterprise Manager
Connecting to an Oracle Database 11g database using different naming methods as well as advanced connection options and when to employ connection pooling
Using and configuring Oracle Net Services in a given scenario
3. Oracle Database 11g: Storage Structures and User Security
Purposes of table spaces and datafiles
Creating a new tablespace
How to manage the storage of information by maintaining tablespaces and viewing their information, and automating manual storage using Automatic
Storage Management (ASM)
View tablespace information and create a new tablespace
Creating and authenticating database user accounts
Granting and revoking privileges and creating and managing roles
Creating and managing profiles, implementing password security, and assigning quotas
4. Oracle Database 11g: Managing the Schema, Data, and Concurrency
Features and functions of schemas and data types and the steps for modifying a table
Using constraints to maintain data integrity, view the contents of a table, and perform actions on the table
Ways of improving data update and retrieval, storing queries, speeding up performance by creating and using indexes, views, sequences, and temporary tables
Create a table with columns and also create constraints and indexes, in a given scenario
Ways for manipulating data with SQL commands and for administering PL/SQL objects
Triggering events and monitoring and resolving locking conflicts
5. Oracle Database 11g: Managing Undo Data, Database Security, and Maintenance
Managing undo operations in Oracle Database 11g to allow users to roll back transactions
Requirements and best practices for implementing database security according to international and regional laws
Enabling, specifying, maintaining, and reviewing database auditing
Process for obtaining and applying Critical Patch Updates (CPUs)
Configure an Oracle Database 11g database to support retention and implement database security in a given scenario
Managing and gathering optimizer statistics
Managing Automatic Workload Repository (AWR) statistics, using the Automatic Database Diagnostic Monitor (ADDM), and utilizing advisors
Viewing and configuring automated tasks and setting alert thresholds
6. Oracle Database 11g: Performance Monitoring, Recovery Concepts and Backup
Monitoring and analyzing performance, managing memory, and troubleshooting invalid objects that affect performance
Ways to anticipate and avoid various types of failure that can occur in Oracle Database 11g
Process used to configure an Oracle Database 11g database for instance recovery
Features of different backup strategies you can employ in Oracle Database 11g
Using RMAN to configure, schedule, manage, and view backup operations
Resolve performance issues, prepare the database for recovery, and perform a database backup in a given scenario
7. Oracle Database 11g: Recovering, Moving, and Enhancing the Oracle Database
Tools required and steps performed in identifying whether a recovery is necessary
Recovering various types of database files
Features of the various options for moving data in Oracle Database 11g
Importing, exporting, and moving data between Oracle databases using Oracle Data Pump
Recover the database from a media failure and move data using the Data Pump Wizard in a given scenario
Using the Enterprise Manager Support Workbench and Oracle Support to investigate, report on, and resolve problems
Searching MetaLink for new critical patches and logging service requests
Managing and applying patches in Oracle Database 11g




如果您想学习本课程,请预约报名
如果没找到合适的课程或有特殊培训需求,请订制培训
培训特点:
针对实际需求,顾问式咨询,互动式授课,案例教学,小班授课,实际项目演示
培训讲师:
中国科学院软件研究所,计算研究所高级研究人员
IBM,oracle,微软,vmware等大型公司高级工程师,项目经理,技术支持专家
中科信软培训中心,资深讲师
大多名牌大学,硕士以上学历,相关技术专业,理论素养丰富
多年实际项目经历,大型项目实战案例,热情,乐于技术分享。
针对客户实际需求,案例教学,互动式沟通,学有所获
报名表下载
联系我们 更多>>

电话咨询:010-62883247

                010-62884854

电子邮件:soft@info-soft.cn  

 

点击这里给我发消息

点击这里给我发消息

点击这里给我发消息

qrcode_for_gh_98c3580f6c5a_430.jpg

订制培训 更多>>