SQL Fundamentals (2nd Edition)

3.5 avg rating
( 8 ratings by Goodreads )
 
9780130669476: SQL Fundamentals (2nd Edition)

Don't just learn "generic" SQL! Learn SQL to get results with the world's top database platforms: Oracle 9i for the enterprise, and Microsoft Access 2000 for the desktop! Based on John Patrick's hands-on SQL course for IT pros at the University of California, Berkeley, SQL Fundamentals, Second Edition shows exactly how to retrieve the data you want, when you need it, in any application -- from ad hoc reports to the data warehouse. Unlike competitive books, SQL Fundamentals, Second Edition emphasizes practical concepts and examples from the latest versions of both leading SQL implementations: Access 2000 on the desktop, and Oracle 9i for the enterprise. You'll start with the basics: creating simple queries to retrieve information from a single table. Next, you'll move on to more complex queries involving many tables. Patrick shows how to create tables and views that divide a complex process into a series of simple steps; summarize your data; work with each form of join; and much more. Throughout, he emphasizes techniques for writing SQL queries that are easy to understand, verify, modify, and extend. All tables used in the book are furnished in both Oracle and Access format.The accompanying CD-ROM contains a library of Access databases and code for building Oracle databases.

"synopsis" may belong to another edition of this title.

Review:

SQL Fundamentals 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

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.

"About this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

1.

John J. Patrick
Published by Prentice Hall PTR (2002)
ISBN 10: 0130669474 ISBN 13: 9780130669476
New Paperback Quantity Available: 1
Seller
Ergodebooks
(RICHMOND, TX, U.S.A.)
Rating
[?]

Book Description Prentice Hall PTR, 2002. Paperback. Book Condition: New. 2. Bookseller Inventory # DADAX0130669474

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 31.35
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds

2.

Patrick, John J.
Published by Prentice Hall PTR (2002)
ISBN 10: 0130669474 ISBN 13: 9780130669476
New Paperback Quantity Available: 2
Seller
Murray Media
(North Miami Beach, FL, U.S.A.)
Rating
[?]

Book Description Prentice Hall PTR, 2002. Paperback. Book Condition: New. Bookseller Inventory # P110130669474

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 38.35
Convert Currency

Add to Basket

Shipping: US$ 2.99
Within U.S.A.
Destination, Rates & Speeds

3.

Patrick, John J.
Published by Prentice Hall PTR
ISBN 10: 0130669474 ISBN 13: 9780130669476
New PAPERBACK Quantity Available: 1
Seller
Cloud 9 Books
(Wellington, FL, U.S.A.)
Rating
[?]

Book Description Prentice Hall PTR. PAPERBACK. Book Condition: New. 0130669474 New Condition. Bookseller Inventory # NEW6.0044724

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 59.99
Convert Currency

Add to Basket

Shipping: US$ 4.99
Within U.S.A.
Destination, Rates & Speeds