熱點推薦:
您现在的位置: 電腦知識網 >> 編程 >> Oracle >> 正文

Oracle9i OCP課程大綱

2022-06-13   來源: Oracle 

  
  Introduction to Oraclei: SQL
  Introduction
   Writing Basic SQL SELECT Statements
   Restricting and Sorting Data
   SingleRow Functions
   Displaying Data from Multiple Tables
   Aggregating Data Using Group Functions
   Subqueries
   Producing Readable Output with iSQL*Plus
   Manipulating Data
   Creating and Managing Tables
   Including Constraints
   Creating Views
   Other Database Objects
   Controlling User Access
   SQL Workshop
   Using SET Operators
   Oraclei Datetime Functions
   Enhancements to the GROUP BY Clause
   Advanced Subqueries
   Hierarchical Retrieval
   Oraclei Extensions to DML and DDL Statements
  
  Oraclei Database Administration Fundamentals I
  Introduction
   Oracle Architectural Components
   Getting Started with the Oracle Server
   Managing an Oracle Instance
   Creating a Database
   Using Data Dictionary and Dynamic Performance Views
   Maintaining the Control File
   Maintaining Online Redo Log Files
   Managing Tablespaces and Data Files
   Storage Structure and Relationships
   Managing Undo Data
   Managing Tables
   Managing Indexes
   Maintaining Data Integrity
   Managing Password Security and Resources
   Managing Users
   Managing Privileges
   Managing Roles
   Auditing
   Loading Data into a Database
   Using Globalization Support
  
  Oraclei Database administration Fundamentals II
   Networking Overview
   Oracle Net Architecture
   Basic Oracle Net Server Side Configuration
   Naming Method Configuration
   Usage and Configuration of the Oracle Shared Server
   Backup and Recovery Overview
   Instance and Media Recovery Structures
   Configuring the Database Archiving Mode
   Oracle Recovery Manager Overview and Configuration
   UserManaged Backups
   RMAN Backups
   UserManaged Complete Recovery
   RMAN Complete Recovery
   UserManaged Incomplete Recovery
   RMAN Incomplete Recovery
   RMAN Maintenance
   Recovery Catalog Creation and Maintenance
   Export and Import Utilities
   Workshop
  
  Oraclei Database Performance Tuning
   Overview of Oraclei Database Performance Tuning
   Diagnostic and Tuning Tools
   Database Configuration and I/O Issues
   Sizing the Shared Pool
   Sizing the Buffer Cache
   Dynamic Instance Resizing
   Sizing Other SGA Structures
   Tuning the Oracle Shared Server
   Optimizing Sort Operations
   Tuning Undo Segments
   SQL Statement Tuning
   Managing Statistics
   Using Oracle Blocks Efficiently
   Using Oracle Data Storage Structures Efficiently
   Application Tuning
   Using Materialized Views
   Monitoring and Detecting Lock Contention
   Using Resource Manager
   Tuning the Operating System
   Workshop Overview

From:http://tw.wingwit.com/Article/program/Oracle/201311/17965.html
    推薦文章
    Copyright © 2005-2022 電腦知識網 Computer Knowledge   All rights reserved.