Friday, 9 March 2018
Mastering Oracle SQL and SQL*Plus
This book is a translation and enhancement of the third edition of a book I wrote about SQL in Dutch. The first edition was published in February 1993, the second edition in April 1998, and I finished the third edition to reflect Oracle Database 10g in the summer of 2004. I always thought that there were more than enough books in English about the SQL language out there already, but finally, some good friends convinced me to publish an English version of my book. I hate thick books. I start reading them, put them aside on a certain pile on my desk, from where they are purged every now and then (if the pile becomes too high), without being read to the end. Therefore, in my own book, I have tried to be as concise as possible.
This is not a book about advanced SQL. It is not a book about the Oracle optimizer and diagnostic tools. And it is not a book about relational calculus, predicate logic, or set theory. This book is a SQL primer. It is meant to help you learn Oracle SQL by yourself. It is ideal for self-study, but it can also be used as a guide for SQL workshops and instructor-led classroom training.This is a practical book; therefore, you need access to an Oracle environment for hands on exercises. All the software that you need to install Oracle Database 10g on Microsoft