×

Uh-oh, it looks like your Internet Explorer is out of date.

For a better shopping experience, please upgrade now.

Oracle9i: SQL, with an Introduction to PL/SQL / Edition 1
     

Oracle9i: SQL, with an Introduction to PL/SQL / Edition 1

by Lannes Morris-Murphy
 

See All Formats & Editions

ISBN-10: 0619212845

ISBN-13: 9780619212841

Pub. Date: 07/16/2003

Publisher: Cengage Learning


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

Overview


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.

Product Details

ISBN-13:
9780619212841
Publisher:
Cengage Learning
Publication date:
07/16/2003
Edition description:
New Edition
Pages:
576
Product dimensions:
7.50(w) x 9.12(h) x 1.21(d)

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

Customer Reviews

Average Review:

Post to your social network

     

Most Helpful Customer Reviews

See all customer reviews