An introduction to relational databases and SQL; How to use Oracle SQL Developer and other tools; How to retrieve data from a single table; How to retrieve data from two or more tables; How to code summary queries; How to code subqueries; How to insert, update, and delete data; How to work with data types and functions; How to design a database; How to create tables, indexes, and sequences; How to create views; How to manage database security; How to write PL/SQL code; How to manage transactions and locking; How to create stored procedures and functions; How to create triggers; How to work with timestamps and intervals; How to work with large objects; Index.
Murach's Oracle SQL and PL/SQL : Works with All Versions Through 11g