Programming Books C Java PHP Python Learn more Browse Programming Books
Buy Used
$3.99
FREE Shipping on orders over $35.
Condition: Used: Like New
Comment: Used, but looks brand new. Only very slight signs of use. Cover and binding are undamaged, and pages are crisp and unmarked. Unbeatable customer service, and we usually ship the same or next day. Over one million satisfied customers!
Add to Cart
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

Sams Teach Yourself SQL in 10 Minutes (2nd Edition) Paperback

ISBN-13: 075-2063321287 ISBN-10: 0672321289 Edition: 2nd

Amazon Price New from Used from Collectible from
Paperback
"Please retry"
$7.99 $0.01

There is a newer edition of this item:


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



NO_CONTENT_IN_FEATURE

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

  • Series: Sams Teach Yourself in 10 Minutes
  • Paperback: 272 pages
  • Publisher: Sams; 2nd edition (April 26, 2001)
  • Language: English
  • ISBN-10: 0672321289
  • ISBN-13: 978-0672321283
  • Product Dimensions: 8.2 x 5.5 x 0.6 inches
  • Shipping Weight: 9.6 ounces
  • Average Customer Review: 4.6 out of 5 stars  See all reviews (35 customer reviews)
  • Amazon Best Sellers Rank: #1,094,349 in Books (See Top 100 in Books)

Editorial Reviews

From the Back Cover

Sams Teach Yourself SQL in 10 Minutes, 2E is a tutorial-based book, organized into a series of easy-to-follow, 10-minute lessons. These well targeted lessons teach you in 10 minutes what some books take several hours or days to teach. Instead of dwelling of database theory and relational design, this book takes a very hands-on approach to solving the needs of the majority of SQL users who simply need to interact with data.

The reader of this book will learn how to:


* Retrieve and sort data
* Filter data using comparisons and wildcards
* Use the aggregate functions to analyze data
* Perform insert, update, and delete operations
* Join relational tables using inner, outer, and self joins
* Combine queries using unions
* Use views
* Create and use stored procedures, triggers, and other advanced database features

About the Author

Ben Forta is Allaire Corporation's product evangelist for the ColdFusion product line. Ben has over 15 years of experience in the computer industry, and spent 6 years as part of the development team responsible for creating OnTime, one of the most successful calendar and group-scheduling products, with over one million users worldwide. Ben is the author of the popular ColdFusion Web Application Construction Kit, and it's sequel Advanced ColdFusion 4 Application Development, as well as books on JSP (JavaServer Pages), WAP, and other technologies.

More About the Author

Ben Forta is Adobe Inc.'s Senior Technical Evangelist, and has over two decades of experience in the computer industry in product development, support, training, and marketing. Ben is the author of the best-selling ColdFusion Web Application Construction Kit and its sequel Advanced ColdFusion Application Development, as well as books on SQL, Regular Expressions, JavaServer Pages, WAP, Windows development, and more. Over 1/2 million Ben Forta books have been printed in a dozen languages worldwide. Ben co-authored the official ColdFusion training material, as well as the certification tests and official study guides for those tests, writes regular columns on ColdFusion and Internet development, and now spends a considerable amount of time lecturing and speaking on application development worldwide.

Customer Reviews

4.6 out of 5 stars
5 star
24
4 star
9
3 star
1
2 star
1
1 star
0
See all 35 customer reviews
This book is worth it's weight in gold!
Brian Yager
I recommend this book to anyone that needs to learn SQL for reports or programming.
Donald W. Long
It is easy to read with very good hands-on examples.
Saeed C. Rezaiyeh

Most Helpful Customer Reviews

35 of 36 people found the following review helpful By A Customer on September 16, 2003
Format: Paperback
I generally don't write reviews of products unless they are fantastic or absolutely horrible. This is FANTASTIC.
If you have programming experience and some familiarity with MS Access, this is a great book for you. I was able to go through the entire thing in 8 hours, take notes and import 3500 records from an old database into a new one with much greater ease.
Pros:
-It differentiates between SQL Server, Oracle and the SQL specification on several examples.
-An introduction to advanced features is given in the last few chapters with examples.
-Small book allows quick scanning
Cons:
-Not very visual. Organization of information and the layout of it is done well, but as far as pictures go, they are absent.
-Title is somewhat deceiving, 10 minutes if you are only trying to find an example to use for reference.
-Not for those who have little or no programming experience. Explains functionality of code and the big picture. On more complex examples, details on sections of code are left out and assumed to be understood.
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
10 of 10 people found the following review helpful By A Customer on August 15, 2003
Format: Paperback
Buy this book. When I first purchased this book I knew just enough SQL to be dangerous. Since that time I have gone through the entire book (3 weeks) trying everything. I really needed this to work on a peoplesoft project so time was short. Its been great to be able to translate the examples in the book to real work situations. Its a must for someone who has had "some" exposure, but needs to write some sophisticated queries for work or school.
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
16 of 18 people found the following review helpful By "udsteve" on July 15, 2003
Format: Paperback
Ok, I would give it 4 1/2 if I could, but can't so I will round down. If you are learning SQL or are going to in a class room, this is a GREAT way to start, even before you start taking lessons. this book will break up learning into "10 minute" lessons, which the first few can be done thourghly in 5. (Possibly because I had already learned it but oh well). Anyway, if you go through every lesson seriously, you will walk away with a GOOD knowledge of SQL, take it from someone who uses SQL in the field.
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
8 of 8 people found the following review helpful By Don Matteson on April 20, 2002
Format: Paperback
I absolutely love this book. I'm fairly new to relational databases and SQL, and I can say quite honestly that this is one book that never leaves my computer's side. Any time I have to write a query that goes beyond simple SELECTs, I turn to Forta's book because it offers quick, concise, and useful information on getting the job done.
I've had the book for about 4 months and so far, I've been able to get answers that I can apply usefully in just minutes. It's worth repeating that I'm fairly new to all this, so my demands aren't necessarily all that great.
A word of caution to other database beginners: This is ***NOT*** a beginning book on databases. Forta offers about 5 pages on database rudiments, which won't be nearly enough unless you've been exposed to the material before. For instance, if you're not familiar with the term "normalization" or the ideas behind "one-to-many" or "many-to-many" relationships, you should bone up on your basics first.
If you need to learn about database basics (especially if you're using MS Access), I'd recommend "Inside Relational Databases" by Whitehorn and Marklyn.
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 8 people found the following review helpful By A Customer on July 2, 2002
Format: Paperback
This book is practical and is packed with useful examples. It builds slowly and clearly states all the various outcomes for each SQL example. I like this book namely because it keeps the various DBMSs in mind while plowing through each concept. Each lesson/chapter is about 10mins long - thus the title, but its long enough so that going back to review is not a chore. Keep in mind it is a beginner's book, but as a start its a great foundation.
I recommend that before you start with the first lesson you go straight to the Appendices and get the tables (structure and data) so that you can follow along with whatever tool you're working with (Access, SQL SERV 7, etc.). I've found this to be the best method of attack.
Bravo Ben Forta! Thanks for the help!
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
4 of 4 people found the following review helpful By Marvin Fretwell on June 19, 2003
Format: Paperback Verified Purchase
If you are a beginner, and have a database to practice SQL on, then this book is for you. If you have never created a database, you will need to in order to use this book. Trouble is, the book tells you how to create the database in Appendix A, and Appendix A is not very thorough. If you succeed in blindly creating your database, the book is excellent thereafter.
Some of the coding does not follow current ANSI standards, but it works.
I was an absolute raw beginner when I picked up this book. It served me well. Had I tried the companion "21 day" book by SAMS first, I would have quit trying before I learned SQL. Thankfully, I read this book first.
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
4 of 4 people found the following review helpful By Doug Bell on June 16, 2003
Format: Paperback
I searched for the smallest book on SQL, hoping to find a book that cut out the fluff and just gave me the essential information. I was coming from a programming perspective and didn't want a book that droned on and on about why I wanted to learn SQL, or how databases worked. I just wanted to learn how to write basic and not-so-basic SQL, and this is definitely the book. The pleasantly surprising part was that it actually does a great job of simply and directly explaining SQL, and it even serves as a passable reference once you've finished reading it.
I just can't say enough for the format of the book. Ben Forta has divided the book into short comprehensible chapters and then used short, direct explanations of the concepts, followed by several examples of increasing complexity that build on each other to introduce the finer points. I read this entire book on a 4-hour plane ride with time to spare. It was an easy read and there was no problem remembering it all. I can't imagine how to write a book to teach SQL either faster, easier or more effectively than this book does. I can't really say how my opinion of the book might be different if I came from a non-programming background, but for my money (and not much of it at that), this is the first SQL book anyone should buy.
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

Product Images from Customers

Most Recent Customer Reviews

Search
ARRAY(0x9dfe4990)

What Other Items Do Customers Buy After Viewing This Item?