TAILIEUCHUNG - Introduction Oracle9i

After completing this lesson, you should be able to do the following: List the features of Oracle9i Discuss the theoretical and physical aspects of a relational database Describe the Oracle implementation of the RDBMS and ORDBMS | Introduction Schedule: Timing Topic 60 minutes Lecture 60 minutes Total Objectives After completing this lesson, you should be able to do the following: List the features of Oracle9i Discuss the theoretical and physical aspects of a relational database Describe the Oracle implementation of the RDBMS and ORDBMS Lesson Aim In this lesson, you gain an understanding of the relational database management system (RDBMS) and the object relational database management system (ORDBMS). You are also introduced to the following: SQL statements that are specific to Oracle iSQL*Plus, which is used for executing SQL and for formatting and reporting purposes Oracle9i Scalability Reliability Single development model Common skill sets One management interface One vendor Oracle9i Features Oracle offers a comprehensive high-performance infrastructure for e-business. It is called Oracle9i. Oracle9i includes everything needed to develop, deploy, and manage Internet applications. Benefits include: .

• Cơ sở dữ liệu
• Oracle XML Applications
• database
• data management
• Oracle XML
• Performance Tuning
• XML Data
• Administration
• Oracle Blocks Efficiently
• Oracle Data Storage Structures
• Oracle Enterprise Manager
• EXPORT IN ORACLE
• Oracle Server
• Managing an Oracle Instance
• Tuning the Oracle Shared Server
• Oracle Architectural Components
• System APIs
• Oracle Workflow
• Data Dictionary
• Managing Undo Data
• SQL Statement Tuning
• Creating Views
• Oracle9i Datetime Functions
• Managing Privileges
• Managing RolesRoles
• Advanced Subqueries
• Using Resource Manager
• Auditing
• Hierarchical Retrieval