Oracle9i: SQL, with an Introduction to PL/SQL / Edition 1
by Lannes Morris-Murphy
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…
See more details below
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: