| Oracle8i SQL与PL/SQL引论
|
Exam 1Z0-001：
Introduction to Oracle8i: SQL and PL/SQL |
 |
| |
| 预备知识 |
| Familiarity with data processing concepts and techniques,
Ability to use a graphical user interface (GUI). |
| |
| 考试简介 |
| 本课程将向学员全面介绍数据服务器技术。本课程将涉及到关系数据库和对象关系数据库的概念以及功能强大的SQL
和PL/SQL 编程语言。学员将学习如何创建和维护数据库对象以及如何存储、提取、和操作数据。此外，学员还将学习如何创 |
| 建可被多种表格、报告、和数据管理应用 |
|
|
| 程序所共享和共用的PL/SQL 应用程序代码块。本课程将通过演示和动手实践活动来强化基本概念。 |
| |
| 考试目标 |
Control data/user access
Create and maintain database objects
Conditionally control code flow (loops, control structures,
and explicit cursors)
Retrieve, insert, update, and delete data
Use basic SQL*Plus commands
Describe relational database concepts
Control transactions
Handle runtime errors
Describe the features and syntax of PL/SQL
|
| |
| 考试概要 |
Relational Technology and Simple
Single-Row and Group Functions
Joins and Subqueries
Modifying Data and Security
Creating and Managing Tables and Views
Other Database Objects and Data Dictionary
PL/SQL Basics
Interacting with the Database
Working with Composite Datatypes and Collections
Exception Handling
|
|
|
|
Login |
|
