| Oracle9i SQL 引论 |
Exam 1Z0-007：
Introduction to Oracle9i: SQL |
 |
| |
| 预备知识 |
Familiarity with data processing concepts and techniques
Ability to use a graphical user interface (GUI) |
| |
| 考试简介 |
本课程将向学员全面介绍数据服务器技术。本课程将涉及到关系数据库和对象关系数据库的概念以及功能强大的SQL
编程语言。学员将学习如何创建和维护数据库对象以及如何存储、提取、和操作数据。学员将学习如何利用ROLLUP、CUBE、集合运算符、和分层提取等高级方法来提取数
据。学员还将学习如何使用iSQL*Plus 工 |
|
|
| 具来编写SQL 和SQL*Plus脚本文件，从而生成类似报告的输出结果。本课程将通过演示和动手实践活动来强化基本概念。 |
| |
| 考试目标 |
Describe relational and object relational database concepts
Retrieve, insert, update, and delete data
Use the Single row and Group functions
Retrieve data using additional advanced techniques like
using ROLLUP, CUBE, set operators, correlated subqueries
and hierarchical queries
Solve problems by using multicolumn subqueries, subqueries
in the from clause of a SELECT statement, correlated subqueries,
and scalar subqueries
Use the iSQL*Plus environment
Write scripts to generate script files
Generate reports using iSQL*Plus
Create and maintain database objects
Control transactions
Control data/user access
Use the Oracle9i Single row functions
Use GROUPING SETS and the WITH clause
Use the Oracle9i extensions to DML and DDL statements
Apply techniques in real life simulation
|
| |
| 考试概要 |
Overview of Oracle Databases
Limiting, Sorting, and Manipulating Return Data
Advanced Data Selection in Oracle
Subqueries
Creating Oracle Database Objects
Manipulating Oracle Data
Creating Other Database Objects Oracle
User Access Control in Oracle
|
|
|
|
Login |
|
