deserves praise because it documents the implementation of Structured Query Language (SQL) in Oracle databases and Access databases simultaneously. Readers find out how to do simple single-table queries, more complicated multitable queries, table creation, joins, unions, and calculations in both environments in a variety of circumstances. For those who've never worked with SQL before and plan to use one of the two covered platforms, this book will make a fine starting point, since it explains elementary SQL concepts too.
Here's the approach: Author John J. Patrick sets out a task--for example, writing a statement that yields a left outer join of two databases. Then he proceeds to accomplish the task in both Access and Oracle, presenting the platforms' respective SQL statements side by side. The differences between the two implementations of SQL are obvious, making it easy for someone familiar with one of the two environments to adapt to the other. The reader will also find the numbered and highlighted key passages, which include details on the facing page, very helpful.
Patrick, who based this book on a university course he teaches, knows the value of practical experience--he's loaded SQL Fundamentals with exercises in addition to the tasks he completes himself. He leaves most of these to the reader but provides solutions to some of the more interesting ones. Databases for the illustrations and exercises are included on the companion CD-ROM. --David Wall
--This text refers to an alternate
From the Inside Flap
SQL is now one of the most important computer languages. It is used in over 100 software products, and new ones are being added all the time. This book shows you how to get the most out of your database. It explains how to use SQL to solve practical problems, using the most widely used SQL products Oracle and Microsoft Access. Oracle and Access are both widely used, easily available and run on personal computers. By learning these two products in detail, you will have all the basic skills to use any of the many products based on SQL.
Every concept in this book is illustrated with an example of SQL code. In most cases, a task is set, then the SQL code is given to complete that task. The beginning and result tables of data are also shown. There are more than 200 of these examples. Each part stands on its own. You can read this book sequentially or skip around to find the parts that you need.
Be sure to look at the appendices for practical tips on how to run Oracle and Access. The CD-ROM contains the database files and the code for all the examples.
In several places throughout this book, I have expressed opinions about computer technology, something that many other technical books avoid doing. These opinions are my own and I take full responsibility for them. I also reserve the right to change my mind.