Buy New

or
Sign in to turn on 1-Click ordering.
Buy Used
Used - Good See details
Price: £3.57
Fulfilled by Amazon

or
Sign in to turn on 1-Click ordering.
 
   
More Buying Choices
Have one to sell? Sell yours here
or
Get a £0.25 Amazon.co.uk Gift Card
Sams Teach Yourself SQL in 21 Days
 
See larger image 
Share your own customer images
Publisher: learn how customers can search inside this book.
Tell the Publisher!
I’d like to read this book on Kindle

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Sams Teach Yourself SQL in 21 Days [Paperback]

Ron Plew (Author), Ryan Stephens (Author)
3.2 out of 5 stars  See all reviews (6 customer reviews)
RRP: £30.99
Price: £26.34 & this item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
You Save: £4.65 (15%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Usually dispatched within 1 to 2 months.
Dispatched from and sold by Amazon.co.uk. Gift-wrap available.

Formats

 Amazon Price New from Used from
Paperback £26.34   -- --
Trade In this Item for up to £0.25
Get an extra £5 when you trade in books worth £10 or more until June 30, 2012. Trade in Sams Teach Yourself SQL in 21 Days for an Amazon.co.uk gift card of up to £0.25, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Find more products eligible for trade-in.
There is a newer edition of this item:
Sams Teach Yourself SQL in One Hour a Day Sams Teach Yourself SQL in One Hour a Day
£31.44
In stock.

Frequently Bought Together

Customers buy this book with Sams Teach Yourself Java 6 in 21 Days by Rogers Cadenhead Paperback £27.19

Sams Teach Yourself SQL in 21 Days + Sams Teach Yourself Java 6 in 21 Days
Price For Both: £53.53

One of these items is dispatched sooner than the other. Show details

  • This item: Sams Teach Yourself SQL in 21 Days by Ron Plew Paperback

    Usually dispatched within 1 to 2 months.
    Dispatched from and sold by Amazon.co.uk.
    This item Delivered FREE in the UK with Super Saver Delivery. See details and conditions

  • Sams Teach Yourself Java 6 in 21 Days by Rogers Cadenhead Paperback

    In stock.
    Dispatched from and sold by Amazon.co.uk.
    This item Delivered FREE in the UK with Super Saver Delivery. See details and conditions

Product details

  • Paperback: 864 pages
  • Publisher: Sams; 4 edition (15 Oct 2002)
  • Language English
  • ISBN-10: 0672324512
  • ISBN-13: 978-0672324512
  • Product Dimensions: 23 x 18.6 x 5 cm
  • Average Customer Review: 3.2 out of 5 stars  See all reviews (6 customer reviews)
  • Amazon Bestsellers Rank: 550,785 in Books (See Top 100 in Books)

    •  Would you like to update product info or give feedback on images?

More About the Author

Ryan K. Stephens
Discover books, learn about writers, and more.

› Visit Amazon's Ryan K. Stephens Page

Product Description

Product Description

Sams Teach Yourself SQL in 21 Days, Fourth Edition provides a sold foundation in understanding the fundamentals of SQL (Structured Query Language). SQL is the query language used by relational databases such a Oracle, Microsoft Access, and Microsoft SQL Server. The new edition covers object-oriented programming with SQL, ODBC, JDBC, embedded SQL, accessing remote databases, and constructs. All new examples based on an open source database such as MySQL enhance this new edition by making the examples readily useable for readers.

From the Author

Examples in book that may not work with some databases
Some readers have purchased this book with the expectation that all examples in the book will work with all implementations of SQL. This book does not completely cover any particular vendor of SQL, but covers ANSI SQL. ANSI SQL is a standard and not a database itself. Please note that some implementations of SQL are not completely ANSI compliant. In this book, we have shown the ANSI (standard) syntax of code, and have shown examples from various implementations of SQL. The majority of the examples have been performed using Oracle since Oracle is mostly ANSI compliant, and since Oracle is the most popular relational database. If you are using an implementation that does not comply with standard SQL, some of the examples may not work. --This text refers to an out of print or unavailable edition of this title.
See all Product Description

Suggested Tags from Similar Products

 (What's this?)
Be the first one to add a relevant tag (keyword that's strongly related to this product)
 
(4)
(2)
(2)
(2)
(1)
(1)
(1)
(1)
(1)
(1)

Your tags: Add your first tag
 
See most popular tags

Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more

What Other Items Do Customers Buy After Viewing This Item?

› Explore similar items

Customer Reviews

Most Helpful Customer Reviews
14 of 14 people found the following review helpful
Format:Paperback
First impressions from this book (as I'm currently only 2 days and a few chapters into it) are that it is good and does get across the SQL syntax etc.

However - BEWARE - it's absolutely riddled with typo's!! One classic example of this is a table you have to create with low and high temperature fields. This book often mixes the two up and transposes them.

Since programming languages are generally, by definition, VERY reliant upon correct syntax this can be frustrating if you blindly follow the book.

I have a number of other SAMS books and they usually offer on their website a page for typo's etc, as well as downloadable data for use with the book's exercises. Here that doesn't appear to be the case. I can't find a "known errors" page or a way of shortcutting the data entry. You'll probably soon get sick of labourious data entry at the command line.

However, I am learning SQL effectively in spite of these limitations. Just bear in mind that if you blindly follow the book's examples that you'll have more than the odd moment of "why is this not working?". It's most likely that you assumed all the tables were set up correctly in the book's examples and you copied them word for word. An assumption I would normally take for granted, but sadly not in this case.

A good teaching book, but whoever did the proofreading should be shot! Keep your wits about you and THINK as you go, don't just assume this book will teach you everything you need to know by following it parrot-fashion.

(but then again, who ever learnt anything by drifting along in autopilot anyway?)

Comment | 
Was this review helpful to you?
1 of 1 people found the following review helpful
Format:Paperback
I read tiggerinamsterdam's review of this book but thought he was maybe exagerrating the number of typos. He's right - the book is full of them. I've done a bit of SQL before so I managed to notice that the output they give for some of the example queries is totally wrong. I can't believe they managed to even release this book as it obviously hasn't been proof read at all. It's a real pity as the book actually semms to be quite good. Another major problem is that there is no CDROM included that contains the example tables. The authors could have at least given a link to download the tables. Instead, the book has two appendices containing all the code for creating and populating the tables used in the examples (17 pages which would take forever to type manually). A tip is that if you do a web search for "Appendix B. Code Examples to Create Tables" and "Appendix C. Code Examples to Populate Tables" you will be able to view these appendices on the O'Reilly site and copy-and-paste the commands. Be warned though - the code also has typos. For example, I'm using MySQL to do the examples. The first example table "checks" has a column named "check". This is a keyword in MySQL and hence gives you an error. You have to rename it to something like "check1" for the code to work. The other tables I had to change were "hilow" and "convert" before they would work. The values in appendix C to be entered for the "products" table will also give an error (they try to insert alphanumeric values into a numeric column). Hopefully this will help someone out.
Comment | 
Was this review helpful to you?
By A Customer
Format:Paperback
For a start-from-scratch introduction to SQL, this book is paced OK and is pretty approachable. I woudn't recommend it to anyone past the low novice level, though. Many subjects are dealt with far too lightly and often very uneven. "DISTINCT" is mentioned, for instance, in the Common Error section and in one other note area, but I didn't find an actual definition anywhere. This might be due to the index, which seemed half-hearted at best. This complicates learning, in that it's dificult to cross-refference and build on the lessons. As for using the book once the lessons have been run through, forget it. This book is pretty much worthless as a refference. Since this is a teaching book, I guess I shouldn't harp too much on it's value for ongoing refference. However, I doubt anyone buys a book with the intention of throwing it away after one read-through. There are better options out there.
Comment | 
Was this review helpful to you?
Most Recent Customer Reviews
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

Search Customer Discussions
Search all Amazon discussions
   

Listmania!

Create a Listmania! list

Look for similar items by category

Look for similar items by subject



















i.e., each product must be in subject 1 AND subject 2 AND ...

Feedback


Amazon.co.uk Privacy Statement Amazon.co.uk Delivery Information Amazon.co.uk Returns & Exchanges