Synopses & Reviews
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.
Prepares students for the first exam in both the Oracle DBA and Internet Application Developer Certification Tracks, and offers a solid general understanding of Oracle9i SQL.
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\n