Oracle 9i:SQL with an introduction to PL/SQL

Description

Oracle9i SQL not only prepares students for the first exam in both the Oracle Database Administrator (DBA) and Internet Application Developer Certification Tracks; it offers them a solid understanding of Oracle9i SQL and how to use it effectively. This textbook is not simply a study guide; it is written for individuals who have just a basic knowledge of databases and can be utilized in a course on this latest implementation of SQL from Oracle. A business case that follows the progress of an online book retailer, JustLee Books, runs through every chapter, and many of the examples in each chapter build on this case. In addition, hands-on activities at the end of each chapter, such as review questions, assignments, and a case project, help to reinforce Oracle9i SQL skills.

Table of Contents

1. Overview of Database Concepts
2. Basic SQL SELECT Statements
3. Restricting Rows and Sorting Data
4. Joining Multiple Tables
5. Selected Single-Row Functions
6. Group Functions
7. Subqueries
8. Table Creation and Management
9. Constraints
10. Data Manipulation
11. Views
12. Additional Database Objects
13. User Creation and Management
14. Formatting Readable Output
15. Introduction to PL/SQL
16. Cursors and Exceptions
Appendices
A: Tables for the JustLee Books Database
B: SQL Syntax Guide
C: Oracle 9i Practice Exams (A-E)
D: Oracle Resources

Features

• Offers complete coverage of Oracle9i SQL and how to use this technology on the job
• Maps to the Oracle Certification Exam #IZ0-007, Introduction to Oracle9i: SQL, as well as Exam #lZ0-001, Introduction to Oracle: SQL and PL/SQL
• Includes two introductory chapters on PL/SQL to help prepare students for application development courses as well as Exam #IZ0-001
• CD includes features 50-question certification practice test by Boson Software.
• Can be bundled with Course Technology Kit for Oracle9i Software, which includes the Oracle9i Database software

描述

Oracle9i SQL不僅為Oracle資料庫管理員（DBA）和網路應用程式開發人員認證路徑的第一個考試做好準備，還提供了對Oracle9i SQL的深入理解以及如何有效使用它的知識。這本教科書不僅僅是一本學習指南，它是為那些對資料庫只有基本知識的人而寫的，可以在Oracle的最新SQL實現課程中使用。一個商業案例貫穿每一章，跟踪一家在線圖書零售商JustLee Books的進展，每一章的許多示例都建立在這個案例之上。此外，每一章末尾的實踐活動，如復習問題、作業和案例項目，有助於鞏固Oracle9i SQL技能。

目錄

1. 數據庫概念概述
2. 基本的SQL SELECT語句
3. 限制行和排序數據
4. 多表聯接
5. 選擇單行函數
6. 群組函數
7. 子查詢
8. 表的創建和管理
9. 約束
10. 數據操作
11. 視圖
12. 其他數據庫對象
13. 用戶創建和管理
14. 格式化可讀輸出
15. PL/SQL入門
16. 游標和異常
附錄
A：JustLee Books數據庫的表
B：SQL語法指南
C：Oracle 9i練習考試（A-E）
D：Oracle資源

特點

- 提供完整的Oracle9i SQL覆蓋範圍，以及如何在工作中使用這項技術
- 符合Oracle認證考試#IZ0-007《Oracle9i入門：SQL》，以及考試#lZ0-001《Oracle入門：SQL和PL/SQL》
- 包含兩個關於PL/SQL的入門章節，以幫助學生為應用程式開發課程以及考試#IZ0-001做好準備
- CD附帶由Boson Software提供的50道認證練習測試
- 可與Oracle9i軟體的Course Technology套件捆綁在一起，該套件包括Oracle9i資料庫軟體