Introduction to Oracle 9i. SQL. Student Guide, Volume 1

Introduction to Oracle9i: SQL consists of two modules, SQL1 and Extended Data Retrieval with SQL. SQL1 covers creating database structures and storing, retrieving, and manipulating data in a relational database. Extended Data Retrieval with SQL covers advanced SELECT statements, Oracle SQL, and iSQL*Plus Reporting.
1 Writing Basic SQL SELECT Statements
2 Restricting and Sorting Data
3 Single-Row Functions
4 Displaying Data from Multiple Tables
5 Aggregating Data Using Group Functions
6 Subqueries
7 Producing Readable Output with iSQL*Plus
8 Manipulating Data
9 Creating and Managing Tables
10 Including Constraints
11 Creating Views
12 Other Database Objects
13 Controlling User Access
14 SQL Workshop Workshop Overview
15 Using SET Operators
16 Oracle 9i Datetime Functions
17 Enhancements to the GROUP BY Clause
18 Advanced Subqueries
19 Hierarchical Retrieval
20 Oracle 9i Extensions to DML and DDL Statements
Appendix A-E, including Practice Solutions, and the Additional Practices are missing here.