Learning SQL : a step by step guide using Oracle /
Richard Earp and Sikha Bagui.
- Boston, [Mass.] ; London : Addison-Wesley, c2003.
- xvi, 350 p. : ill. ; 24 cm.
Includes index.
0.The software engineering process and relational databases -- 1.Getting statted with Orace 8 in the Windows environment -- 2.More beginning SQL commands -- 3.The Cartesian product, the join, and aliases -- 4.Functions and matching (LIKE) -- 5.Query development, privileges, and derived structures-- 6.Set operations -- 7.Joins versus subqueries -- 8.Group by and having -- 9.Correlated subqueries -- 10.Create tables and SQLloader -- 11.Multiple commas, START files and repots in SQLPLUS -- 12.Beginning PL/SQL examples: anonymous BLOCKS procedures, functions, and packages -- 13.Introduction to triggers.