Casteel J.Oracle 11g: SQL

Course Technology – 2009, 608 p., 2nd edition
ISBN: 1439041288, 9781439041284Oracle 11G: SQL is not simply a study guide; it is written for individuals who have just a basic knowledge of databases and can be utilized in a course on this latest implementation of SQL from Oracle.Overview of Database Concepts
Basic SQL SELECT Statements
Table Creation and Management
Constraints
Data Manipulation and Transaction Control
Additional Database Objects
User Creation and Management
Restricting Rows and Sorting Data
Joining Data from Multiple Tables
Selected Single-Row Functions
Group Functions
Subqueries and MERGE Statements
Views
Appendix A Tables for the JustLee Books Database
Appendix B SQL*Plus and SQL Developer Overview
Appendix C Oracle Resources
Appendix D SQL*Loader
Appendix E SQL Tuning Topics
Appendix F SQL in Various Databases