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