Programming Books C Java PHP Python Learn more Browse Programming Books
The Language of SQL and over one million other books are available for Amazon Kindle. Learn more
Buy New
$13.46
Qty:1
  • List Price: $19.99
  • Save: $6.53 (33%)
FREE Shipping on orders over $35.
In Stock.
Ships from and sold by Amazon.com.
Gift-wrap available.
Sell yours for a Gift Card
We'll buy it for $3.11
Learn More
Trade in now
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

The Language of SQL: How to Access Data in Relational Databases Paperback – June 3, 2010

ISBN-13: 978-1435457515 ISBN-10: 143545751X Edition: 1st

Buy New
Price: $13.46
21 New from $9.23 19 Used from $11.90
Amazon Price New from Used from
Kindle
"Please retry"
Paperback
"Please retry"
$13.46
$9.23 $11.90
Year-End%20Deals%20in%20Books

Frequently Bought Together

The Language of SQL: How to Access Data in Relational Databases + Sams Teach Yourself SQL in 10 Minutes (4th Edition) + Sql Guide (Quickstudy: Computer)
Price for all three: $40.63

Buy the selected items together
If you buy a new print edition of this book (or purchased one in the past), you can buy the Kindle edition for only $2.99 (Save 79%). Print edition purchase must be sold by Amazon. Learn more.


Shop the new tech.book(store)
New! Introducing the tech.book(store), a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Product Details

  • Paperback: 256 pages
  • Publisher: Cengage Learning PTR; 1 edition (June 3, 2010)
  • Language: English
  • ISBN-10: 143545751X
  • ISBN-13: 978-1435457515
  • Product Dimensions: 7.4 x 0.6 x 9.1 inches
  • Shipping Weight: 1.2 pounds (View shipping rates and policies)
  • Average Customer Review: 4.5 out of 5 stars  See all reviews (40 customer reviews)
  • Amazon Best Sellers Rank: #54,045 in Books (See Top 100 in Books)

Editorial Reviews

Review

1. Relational Databases and SQL. 2. Basic Data Retrieval. 3. Calculations and Aliases. 4. Using Functions. 5. Sorting Data. 6. Column Based Logic. 7. Row Based Logic. 8. Boolean Logic. 9. Inexact Matches. 10. Summarizing Data. 11. Combining Tables with an Inner Join. 12. Combining Tables with an Outer Join. 13. Self Joins and Views. 14. Subqueries. 15. Set Logic. 16. Stored Procedures and Parameters. 17. Modifying Data. 18. Maintaining Tables. 19. Principles of Database Design. 20. Strategies for Displaying Data. Appendix A. Getting Started with Microsoft SQL Server. Appendix B. Getting Started with MySQL. Appendix C. Getting Started with Oracle Database. Appendix D. Listing of All SQL Statements.

About the Author

Larry Rockoff has been involved with Business Intelligence and Data Warehouse development for many years. His main area of interest is with using reporting tools to explore, extract, and analyze data in complex databases. He holds an MBA from the University of Chicago, with a specialization in Management Science.

More About the Author

Larry Rockoff has been involved with Business Intelligence and Data Warehouse development for many years. His main area of interest is with using reporting tools to explore and analyze data in complex databases. He holds an MBA from the University of Chicago, with a specialization in Management Science.

For more information on his current activities or to contact the author, please visit larryrockoff.com.

Customer Reviews

4.5 out of 5 stars
5 star
27
4 star
8
3 star
5
2 star
0
1 star
0
See all 40 customer reviews
It was nicely organized and very well written.
Kathy
This is book is perfect for anyone who is just starting off with SQL and needs to get the basics down.
W.C. Wheels
I recommend this book for anyone who wants to begin learning about databases and SQL.
Bill Eberle

Most Helpful Customer Reviews

24 of 24 people found the following review helpful By Wikileaker on March 3, 2011
Format: Paperback
Rockoff gives the lowdown on SQL slowly and patiently, but not too much so.

In little embedded sections, functionally like sidebars, he details the minor differences in the three SQL dialects: Microsoft SQL Server, Oracle SQL, and the free open-source MySQL. Each chapter begins with an explanation of the material to be presented, and ends with a summary of what was covered and a preview of the following chapter. (the classic "tell them what you're gonna tell them, tell them, and then tell them what you told them" !) Sounds tiresome but it isn't really, since he phrases it with a little different emphasis each time, which I find greatly aids comprehension.

He gives tips and pointers on what he believes are the best ways to accomplish things in SQL. To perform most tasks in SQL there are usually several methods available; Rockoff points out the pros and cons of each of them. He also delineates how the various SQL commands relate to and complement one another.

The book is written with plenty of specific coding examples; as in the book's description on Amazon, it is written so that it can be comprehended without having to practice SQL at a computer. Everything needed is between the covers, except for detailed descriptions of all the available functions. For that, Rockoff directs the reader to his website and other documentation on the web.

Outstanding!

(postscript) Please note this is an introductory text. Some of the "advanced" SQL features are neglected, but the one covered are plenty enough to serve the book's purpose.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
9 of 9 people found the following review helpful By Alexandra on December 17, 2010
Format: Paperback Verified Purchase
I believe, this is a great SQL reference guide. One could refer to it very quickly when a certain query is needed. It would save time. Finding the info in the book would be easier than browsing online in an effort to locate something concrete that you need at a particular time, for a certain particular reason. Systems Analysts and Business Analysts can benefit from the book alike. I would recommend this book to both novice SQL Server developers as well as experienced database administrators.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
14 of 16 people found the following review helpful By Kathy on July 14, 2010
Format: Paperback Verified Purchase
As a SQL novice, I found this book very helpful and easy to read. Everything was understandable and clear. The author did a nice job of explaining how each new topic relates to what you already know. It was nicely organized and very well written. It's the kind of book you can read to get the concepts, and then keep around as a reference. I'd definitely recommend this book for anyone interested in learning SQL.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
7 of 7 people found the following review helpful By Jacqueline Morrison on May 19, 2013
Format: Paperback Verified Purchase
Good book for learning the basics and understanding SQL. SQL examples covered make sense and are easy to understand. There is no code in this book on how to handle the returned data from a query with code, you will have to learn this on your own. Instead, you view the data through console of which a database administrator would use and not necessarily a coder. If you are looking to understand how SQL works and what database is capable of doing, this book will guide you there. This book also gives a chapter on how to create a database which deserves a book by itself. Hope this helps.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
5 of 5 people found the following review helpful By David on June 1, 2012
Format: Paperback Verified Purchase
I want to start off by saying that this book is EXCELLENT for anyone who is completely new to SQL or a relative beginner like myself. The book is clearly laid out with relevant examples and queries that are easy to read and understand. It's a fine read and a great reference.

With that said, where did the Kindle version go??? I got this book on the Kindle and love it for its easy searching ability, which is great for reference books. However, it is no longer available in Kindle format! I recommended this book to one of my coworkers, but since it wasn't available on the Kindle he had to look elsewhere. The Kindle format is easier to search and navigate, can be accessed anywhere, and doesn't waste paper. Please bring it back!
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
5 of 5 people found the following review helpful By David H. Robinette on August 14, 2012
Format: Paperback Verified Purchase
The best thing about this book is the writing. The author does not waste words, and he explains SQL in plain English. Excellent book for beginners.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
5 of 6 people found the following review helpful By Computer Concepts of TN on January 17, 2012
Format: Paperback Verified Purchase
I was and still am taking and intro SQL class for a computre science degree, and the book the requested was not really a quick look reference type of book. BUT this book fulfilled my every request. It has quick and easy command references for very basic select and queries, to advance user modification, to privledages. THIS book is highly recommended by me and other computer science majors because of it no practice or code writting pages to learn the commands. You just look and find the one you might need and there it is. Has MySQL, ORacle, Java references, and other SQL access programs referenced in here too. VERY USER FRIENDLY AND NEEDS TO BE ON EVERY SQL USERS ARSENAL!!!!!
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
12 of 17 people found the following review helpful By James R on March 29, 2013
Format: Kindle Edition Verified Purchase
First, let me say that my background is not in database administration. I know some procedural programming languages, but because SQL is a declarative language, I'm not sure my previous programming experience was much help, and in fact could have prejudiced me with incorrect assumptions.

That being said, I just read multiple books on SQL, this being one of them, and I found the process of learning SQL miserable. None of the books had a good introduction that explained the declarative nature of SQL, the basics of its constructs (e.g., a simplified pseudo-code explanation of various query types), and, quite importantly once you get to queries of any complexity, when you have to realize that there actually are procedural aspects to SQL in that the structure of your query affects the order of operation or what information is available to other statements (sub-queries and grouping, for example).

Sure, you eventually figure this stuff out by reading between the lines and composing hundreds of queries that don't work the first time. As I said, miserable. It would be far, far easier to compose SQL queries that run without error, and produce the results you expect (it is VERY easy to write a query that runs, yet isn't doing what you think it is doing, especially in MySQL with its relaxed attitude about some of the SQL standards) if the internal logic was explained. There is no way examples can cover every conceivable situation, but if you know WHY something works the way it works, it is much easier to extrapolate how to fit an example to your needs. I do not feel like this book (nor any other that I've read - if you have suggestions, please let me know!) does a good job of explaining the "Why's" of SQL, nor how it differs from "normal" programming (which may not be an obligatory topic, but I'm guessing that programmers wanting to learn some database design and administration skills is a common enough situation to warrant addressing).
3 Comments Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Most Recent Customer Reviews


What Other Items Do Customers Buy After Viewing This Item?