SQL Fundamentals - Softcover

Patrick, John J.

Softcover

ISBN 10: 0130669474 ISBN 13: 9780130669476

Publisher: Pearson P T R, 2002

Synopsis

A new edition of this title is now available, ISBN-10: 0137126026 ISBN-13: 9780137126026

About this title

About the Author

JOHN J. PATRICK is a computer consultant and software developer specializing in relational database technology. He teaches SQL Fundamentals and other database courses at the University of California, Berkeley Extension, and has over 20 years of experience in software development at Bank of America, Chevron, Kaiser Permanente, and other leading firms.

From the Back Cover

SQL for Oracle, Access—and the real world!

• The hands-on, real-world SQL guide for every business and IT professional
• Master SQL for the world's two top databases: Oracle and Microsoft Access
• How to write SQL queries that are easy to understand, verify, modify, and extend
• Covers everything from basic SELECT statements to complex joins
• CD-ROM: extensive library of sample databases and code

Don't just learn "generic" SQL: learn SQL to get results with the world's top database platforms-Oracle for the enterprise, and Microsoft Access for the desktop! Based on John Patrick's hands-on SQL course at the University of California, Berkeley, this book shows exactly how to retrieve the data you want, when you need it, in any application-from ad hoc reports to the data warehouse. From the simplest SELECT statements to the most sophisticated joins, Patrick shows you exactly how to write SQL queries that are easy to understand, verify, modify, and extend. SQL Fundamentals, Second Edition teaches you to:

• Write simple statements to retrieve, store, or modify data
• Build complex queries that draw information from multiple tables
• Create your own tables
• Summarize your data: basic and advanced techniques
• Understand and ensure data integrity
• Work with unions, subqueries, self joins, cross joins, inner joins, and outer joins

CD-ROM INCLUDED

The accompanying CD-ROM contains all the SQL code and tables from the book, Microsoft Access databases, and code for building the corresponding Oracle databases.

Excerpt. © Reprinted by permission. All rights reserved.

Preface

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. If I do so, I will put my revised opinion and the reasons that have caused me to change my thinking on the Web site for this book,sqlfun

Edition details

• Publisher: Pearson P T R
• Publication date: 2002
• Language: English
• ISBN 10: 0130669474
• ISBN 13: 9780130669476
• Binding: Paperback
• Number of pages: 834