Industrial-Sized Deals Books Gift Guide Books Gift Guide Shop Men's Athletic Shoes Learn more nav_sap_plcc_6M_fly_beacon Adele egg_2015 All-New Amazon Fire TV Beauty Deals Gifts Under $50 Amazon Gift Card Offer minions minions minions  Amazon Echo Starting at $84.99 Kindle Black Friday Deals Shop Now HTL
SQL Fundamentals (3rd Edition) and over one million other books are available for Amazon Kindle. Learn more

Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your email address or mobile phone number.

SQL Fundamentals (2nd Edition) 2nd Edition

35 customer reviews
ISBN-13: 007-6092013976
ISBN-10: 0130669474
Why is ISBN important?
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Have one to sell? Sell on Amazon
Buy used
Condition: Used - Good
Condition: Used: Good
Comment: Item is in good condition. May include some wear and creases on the cover. Fast shipping. Free delivery confirmation with every order.
Access codes and supplements are not guaranteed with used items.
38 Used from $0.01
More Buying Choices
10 New from $9.28 38 Used from $0.01 1 Collectible from $9.96

There is a newer edition of this item:

Free Two-Day Shipping for College Students with Amazon Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student

Get Up to 80% Back Rent Textbooks

Editorial Reviews 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 --This text refers to an out of print or unavailable edition of this title.

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

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.


Hero Quick Promo
Holiday Deals in Kindle Books
Save up to 85% on more than 1,000 Kindle Books. These deals are valid until November 30, 2015. Learn more

Product Details

  • Paperback: 864 pages
  • Publisher: Prentice Hall PTR; 2 edition (May 17, 2002)
  • Language: English
  • ISBN-10: 0130669474
  • ISBN-13: 978-0130669476
  • Product Dimensions: 7 x 1.2 x 9.5 inches
  • Shipping Weight: 2.7 pounds
  • Average Customer Review: 4.4 out of 5 stars  See all reviews (35 customer reviews)
  • Amazon Best Sellers Rank: #2,480,828 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

13 of 13 people found the following review helpful By Carlos Santiago VINE VOICE on November 19, 2002
Format: Paperback
Choosing one particular SQL book out of the dozens available was not an easy task. Here are the reasons that made me choose this one over the others:
* Book organization - Chapters are very well structured with very descriptive sections, making it easy to find what you want. The first page of every chapter lists the contents by section
* Ease of reading - Everything is explained and described with tables or diagrams. Chapters are summarized at the end with the most important points covered. SQL code is explained in detail using numeric references that are explained separately from the code. Other books clutter the code with explanations making them hard to read and follow
* Oracle and Access code examples - Two of the most widely used DBs are covered, allowing the reader to see the slight, but nevertheless important differences in coding requirements for each platform. Command results are also presented for every example to allow the reader to compare them with their results
* Topics covered - From What is SQL to How to use Oracle and Access, the book is detailed and specific without being overkill
* CD - It contains all the examples in the book, plus all the tables and data. The CD is compatible with 98/ME/XP/2000 and NT. The Oracle code can be used with Unix and their flavors
Some examples could have been more realistic though, instead of using lunches, fruits and colors in many of them. But this is a very personal opinion that will not affect the evaluation.
I have no regrets in choosing this book, it has made me understand the SQL virtues and also its limitations. The book was definitely created with a wide audience in mind, written with no silly jokes and no fancy graphics or fonts to show off. This is a very straight, solid SQL foundation book for people with not much time for distractions.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
9 of 9 people found the following review helpful By Jennifer Fowler on December 7, 2001
Format: Paperback
This is a *very* useful book. It explains the SQL language in a very clear and concise manner, covering the language in detail and offering excellent explanations. The book is also organized extremely well. The countless diagrams and screen shots are invaluable while working thru the examples.
Having come to a point where I needed to learn SQL (and understand it), and fast, I picked this book out of 4 I was considering. I whole-heartedly believe I made the right decision. Not only did I learn SQL, but I understood it too.
The book covers both MS Access and Oracle so if you're using either of those, and you need to learn the SQL language, this book is a great start! Heck, even if you won't be using Access or Oracle but have access to them for the purpose of the examples (I used Access for the examples but I needed to learn SQL for use with MySQL and MSSQL), this book should benefit you greatly.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
8 of 9 people found the following review helpful By Hakuna Matata on January 31, 2011
Format: Paperback
The entire layout is very clean and the phrasing is concise. I was able to understand and grasp the concepts outlined in this book with little effort. I really like the way the author organizes the book because it felt like I was being taught by someone rather than just reading things from a book. Everything is approached logically and carefully, which made for a good learning environment.

You definitely need to follow along and use some sort of SQL application to get the full benefit from this. I was afraid at first that I would be limited to Oracle or Access, but it seems like the information here is probably applicable to most SQL systems. I personally used a free iPad application called Empress SQL Master and had no problems. The examples were simple and not very realistic, but definitely showed proof of concept.

The only problems I had with this book were very minor and mostly had to do with aesthetics. Sometimes the font was too small, or difficult to read (Large blocks of boldface console text). Although, the previous statement may be more of a testament to my poor eyesight. As well, the book is in black and white, which may be a pro for some, con for others.

Overall I would say this is a no-nonsense approach to quickly and efficiently learn SQL commands and their limitations.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
5 of 5 people found the following review helpful By Doubting Thomas on December 30, 2002
Format: Paperback
I use many computer texts, and this title is one of the best, most clearly written guides/manuals I have seen. It has excellent organization, clear presentation, easy-to-understand examples. If you need SQL this is definitely the book. In a genre where authors often slap together sloppy books in record time (for low pay) this is a standout.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
3 of 3 people found the following review helpful By A Customer on March 25, 2000
Format: Paperback
This is a very well organized and practical hands-on book. It explains what you have to do and then if you follow the exercises in the book, it works. I have tried the examples on ORACLE and they worked. This is one of the few books I bought recently that the CD actually works. The book assumes the readers have no prior knowledge of SQL. I would recommend this book to anyone wanting to learn SQL.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
2 of 2 people found the following review helpful By Stuart R. Ainsworth on June 13, 2000
Format: Paperback
I bought this book to cram for a job interview; although I've spent some time as an Access developer (read: power user), I've never really spent that much time looking at SQL as a language. I bought this book because it focused on Access and Oracle.
I really like the format of this book, because it does read like a workbook. The author introduces a topic, provides some examples, and then gives you some exercises. The code is available on a CD-ROM (which is nice if you're trying to cram a lot of information in a very tight time frame).
However, the editing is horrible, and it can detract from the learning. One example is the note from the editor to the author that was mistakenly left in the manuscript (whoops!) on page 347.
Overall, it is a handy workbook/reference, and should probably stay on your shelf.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Most Recent Customer Reviews

What Other Items Do Customers Buy After Viewing This Item?