Book Abstract:
Sams Teach Yourself SQL in 24 Hours, Third Edition presents the key features of SQL (Structured Query Language) in an easy to understand format with updated code examples, notes, diagrams, exercises, and quizzes. New material covers more information on transactions, constructs, embedded databases, and object-oriented programming. In this edition, the authors include examples based on a database like MySQL, a very popular open source database.

Book Link:

http://www.informit.com/library/library.aspx?b=STY_Sql_24hours

Contents:
1. Introduction to RDBMS
2. Introduction to Oracle
3. Getting started with Oracle8i
4. Creating sample tables
5. Changing structure and data
6. Arithmetic and Date Functions
7. String, Conversion,and Miscellaneous functions
8. Grouping Data
9. Joining Tables
10. Views
11. Subqueries
12. Indexing, clustering, sequence, and pseudo columns
13. Security
14. Report Generation using SQL*PLUS commands
15. Introduction to PL/SQL
16. Control structures
17. Exception handling
18. Cursor Handling
19. Procedures,functions and packages
20. Database Triggers
21. LOBs
22. Object Types
23. VARRAY and Nested Table
24. Native Dynamic SQL

Book Link:

http://srikanthtechnologies.com/books/orabook/oraclebook.html

Contents:
Chapter 1: Introduction
Chapter 2: Entity-Relationship Model
Chapter 3: Relational Model
Chapter 4: SQL
Chapter 5: Other Relational Languages
Chapter 6: Integrity Constraints
Chapter 7: Relational Database Design
Chapter 8: Object-Oriented Databases
Chapter 9: Object-Relational Databases
Chapter 10: Storage and File Structure
Chapter 11: Indexing and Hashing
Chapter 12: Query Processing

Book Link:

http://www.cs.sfu.ca/CC/354/zaiane/material/notes/contents.html

This Oracle/SQL tutorial provides a detailed introduction to the SQL query language and the Oracle Relational Database Management System. Further information about Oracle and SQL can be found on the web site www.db.cs.ucdavis.edu/dbs.
Read more and Download →

This paper is designed to help you get started with Oracle 10g on SUSE LINUX 9.3. This will help you to work on latest SUSE OS and latest Oracle Database 10g from Oracle. Oracle 10g is supported and certified only on SUSE LINUX Enterprise Server (SLES) but occasionally for development and testing purposes you will prefer to have it up and running on your desktop for quick access. Instruction provided here will also work on SUSE LINUX 9.2.
Read more and Download →