About this Product

Write a Review

• Overview
• |
• Table of Contents

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