• List Price: CDN$ 45.37
  • You Save: CDN$ 7.37 (16%)
Temporarily out of stock.
Order now and we'll deliver when available. We'll e-mail you with an estimated delivery date as soon as we have more information. Your account will only be charged when we ship the item.
Ships from and sold by Amazon.ca. Gift-wrap available.
Quantity:1
Beginning SQL Queries: Fr... has been added to your Cart
+ CDN$ 6.49 shipping
Used: Good | Details
Sold by Daily-Deal-
Condition: Used: Good
Comment: This Book is in Good Condition. Used Copy With Light Amount of Wear. 100% Guaranteed.
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 3 images

Beginning SQL Queries: From Novice to Professional Paperback – Apr 16 2008

5.0 out of 5 stars 1 customer review

See all 3 formats and editions Hide other formats and editions
Amazon Price
New from Used from
Paperback, Apr 16 2008
CDN$ 38.00
CDN$ 38.00 CDN$ 31.91

Harry Potter Book Boutique
click to open popover

No Kindle device required. Download one of the Free Kindle apps to start reading Kindle books on your smartphone, tablet, and computer.
Getting the download link through email is temporarily not available. Please check back later.

  • Apple
  • Android
  • Windows Phone
  • Android

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




Product Details

  • Paperback: 240 pages
  • Publisher: Apress; 2008 edition (April 16 2008)
  • Language: English
  • ISBN-10: 1590599438
  • ISBN-13: 978-1590599433
  • Product Dimensions: 18.4 x 1.4 x 23.5 cm
  • Shipping Weight: 517 g
  • Average Customer Review: 5.0 out of 5 stars 1 customer review
  • Amazon Bestsellers Rank: #321,057 in Books (See Top 100 in Books)
  •  Would you like to update product info, give feedback on images, or tell us about a lower price?

  • See Complete Table of Contents

Product Description

From the Back Cover

Get started on mastering the one language binding the entire database industry. That language is SQL, and how it works is must-have knowledge for anyone involved with relational databases, and surprisingly also for anyone involved with NoSQL databases. SQL is universally used in querying and reporting on large data sets in order to generate knowledge to drive business decisions.

Good knowledge of SQL is crucial to anyone working with databases, because it is with SQL that you retrieve data, manipulate data, and generate business results. Every relational database supports SQL for its expressiveness in writing queries underlying reports and business intelligence dashboards. Knowing how to write good queries is the foundation for all work done in SQL, and it is a foundation that Clare Churcher's book, Beginning SQL Queries, 2nd Edition, lays well.

  • Write simple queries to extract data from a single table
  • Combine data from many tables into one business result using set operations
  • Translate natural language questions into database queries providing meaningful information to the business
  • Avoid errors associated with duplicated and null values
  • Summarize data with amazing ease using the newly-added feature of window functions
  • Tackle tricky queries with confidence that you are generating correct results
  • Investigate and understand the effects of indexes on the efficiency of queries


--This text refers to an alternate Paperback edition.

About the Author

Clare Churcher is currently a senior lecturer in the Department of Applied Computing at Lincoln University, New Zealand. She holds a degree in physics with first class honors and completed a Ph.D in physics at the University of Canterbury, New Zealand. She has done postdoctoral research in the Cavendish Laboratory at the University of Cambridge, England. Clare s research interests are in the management and visualization of data especially for scientific research. She has a background in database design, and has taught programming, analysis and design of information systems, and database management at undergraduate level, as well as software engineering and scientific visualization at post graduate level.


What Other Items Do Customers Buy After Viewing This Item?

Customer Reviews

5.0 out of 5 stars
5 star
1
4 star
0
3 star
0
2 star
0
1 star
0
See the customer review
Share your thoughts with other customers

Top Customer Reviews

Format: Paperback Verified Purchase
good book
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 Helpful Customer Reviews on Amazon.com (beta)

Amazon.com: HASH(0xa1e3ad74) out of 5 stars 17 reviews
23 of 25 people found the following review helpful
HASH(0xa1e5f7d4) out of 5 stars Solid start Dec 17 2008
By Pas content - Published on Amazon.com
Format: Paperback
Disclaimer: although I have had nothing to do with this book and I have never met the author (we live at the antipodes of each other), I was the technical reviewer for her previous book - and I am the author of two SQL books, none of them for beginners.

Knowing Clare's style, I have been extremely surprised by some of the reviews of this book, which are rather harsh. I got a copy of "Beginning SQL Queries", and read it to have an opinion of my own.
Several reviewers complain about the references to algebra and calculus; I think they have missed Clare's point, which was to show that there are two writing styles with SQL. She could have called them style A and style B, but unfortunately she is rather precise in what she writes and chose to call them by their received names of algebra and calculus, which I agree are dirty names. Which one is algebra and which one is calculus is usually something I forget very fast, and I've practiced SQL for a quarter of a century; believe me, you can use both styles without knowing their names.
I also take objection to one reviewer's comment that "it is clear the author doesn't actually understand SQL. A table alias is not a 'row variable'". Perhaps Clare didn't make her point clear enough; but when you write a correlated subquery, as in

select ...
from ta outer
where exists
(select 1
from tb inner
where inner.id = outer.id)

"outer" (the table alias) in the subquery actually refers to the current row from the outer query. Perhaps an unusual way to introduce the topic; but I have always believed that the goal of a book should be to intellectually challenge the reader and bring him or her to see the topic in a different light.

All this being said, I'm not convinced by some aspects of the book. For one thing, if the author actually starts from the "novice" stage, she doesn't really bring the reader to the "professional" stage in my humble opinion; the coverage of topics like indexing is light, and none of the examples is even remotely as complex as what I routinely encounter. This makes the introduction (fortunately discrete) of formal notations look like an overkill with no real added value. Better to concentrate on the figures, which are extremely clear.

If you just wish to make some quick and dirty SQL job, "Beginning SQL Queries" is probably not a book for you - I guess that any tutorial on the web and a bit of trial and error will get you started. You won't go very far, but sometimes you don't want to.
I rather see this book as a good bridge between college and the professional world - it combines the rigor of text books (although it doesn't theorize, all the key points from the theory are here) with the conversational tone of books that are aimed at the professional world; strictly correct without being dry. It will not turn you into a full-blown database professional, but if what you have seen - or not seen - at school is hazy and if you are serious about ensuring that you have sound foundations, reading "Beginning SQL Queries" is a good way to start.
14 of 14 people found the following review helpful
HASH(0xa1e5f828) out of 5 stars Perfect little problem solver July 5 2008
By Ian Lill - Published on Amazon.com
Format: Paperback
I'm a computer-savy first time SQL'er. I found this book to provide a quick and complete introduction to SQL that allowed me to straight away get going. It's written from a practical stand point which is really useful if you're like me and just want to get the job done.

I also like the way book tackles the subject from two different angles - she calls it the Algebra or Calculus angles. Sounds mathematical but it simply means that when you're got a complicated problem you've got twice the chance of finding a solution.

This book comes totally recommended. I became quite intrigued by the stuff about how you should design your database right that I'm now reading her book on Database Design.
6 of 6 people found the following review helpful
HASH(0xa1e5fc60) out of 5 stars Highly Reccommended for SQL Newcomers July 20 2011
By Bradley_M - Published on Amazon.com
Format: Paperback
As somebody new to databases, I found this book to be a fantastic read, essential for any new comer. The book systematically educates the reader in a way that is palatable and enjoyable. My confidence level has risen immensely and I would recommend this book to anybody seeking to become proficient in SQL whilst avoiding unnecessary technical jargon. This is a resource that you will enjoy referencing again and again.
3 of 3 people found the following review helpful
HASH(0xa1cd203c) out of 5 stars Beginning SQL Queries Sept. 24 2012
By cyn - Published on Amazon.com
Format: Paperback Verified Purchase
I bought this book based upon the publisher recommendations. I think
the book did very well to explain the logic behind Oracle SQL and its
inner workings. For me personally, it was not difficult to write
queries. Rather, it was more difficult to understand the logic
behind queries. Failing to understand the logic behind queries but
writing good queries can present a danger to your progress especially
in taking exams. This book helped to clarify those issues.
3 of 3 people found the following review helpful
HASH(0xa1e5ffcc) out of 5 stars Get a thorough foundation to practical problems Sept. 16 2012
By Scott I. Lawley - Published on Amazon.com
Format: Paperback Verified Purchase
There are at least a couple of ways to approach gaining skills in SQL. One is to learn a few superficial ideas that might make you dangerous around a database. The other is to gain foundational skills that give you what you need to move on to expert status. One might as well start with the latter approach as well as the former. I remember learning to alpine ski as a young person and being told that it is difficult to unlearn bad habits on the slopes. I believe the same idea is applicable to programming, particularly when it comes to relational databases.

You might as well understand what a database is, what it does, and why they work the way they do. Clare Churcher assumes that the reader of this book wants to start from a solid base with the intention of moving on with the skills they need to become a professional. I appreciate her approach. I don't feel as if Churcher is insulting my ability or intelligence. As it says on the cover, "A thoughtful approach to learning SQL that helps you think about language--and about your data--so that you can apply the right operations to the right problem to generate the right results, every time."

This title is worth your attention. Buy it, read it, and you'll have the skills you need.


Feedback