Vous voulez voir cette page en français ? Cliquez ici.


or
Sign in to turn on 1-Click ordering.
More Buying Choices
Have one to sell? Sell yours here
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 10 Minutes [Paperback]

Ben Forta
5.0 out of 5 stars  See all reviews (1 customer review)
List Price: CDN$ 14.60
Price: CDN$ 13.60 & FREE Shipping on orders over CDN$ 25. Details
You Save: CDN$ 1.00 (7%)
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
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.
There is a newer edition of this item:
Sams Teach Yourself SQL in 10 Minutes (4th Edition) Sams Teach Yourself SQL in 10 Minutes (4th Edition) 5.0 out of 5 stars (1)
CDN$ 19.43
Usually ships in 3 to 5 weeks

Book Description

August 1999 Sams Teach Yourself
Sams Teach Yourself SQL in 10 Minutes 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. It is for those users who don't have the time to read lengthy chapters, or are not inclined to read "manuals." You will learn retrieving and sorting data, advanced data filtering, using wildcard filtering, manipulating data, combining queries, using views, creating and using stored procedures, and creating triggers.

Product Details


Product Description

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 the more recent Advanced ColdFusion 4 Application Development Kit.

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

Customer Reviews

4 star
0
3 star
0
2 star
0
1 star
0
5.0 out of 5 stars
5.0 out of 5 stars
Most helpful customer reviews
5.0 out of 5 stars Good Succinct Primer on SQL July 9 2004
Format:Paperback
I taught a class to co-workers who had no SQL experience using this book, covering the first 6 chapters in approximately 4 hours; and the next day they were able to assist in writing queries, easing my workload (this is an excellent book to use for learning how to write queries, but it does not cover design, for that see Steven Roman's Access Database Design and Programming). This book demands a careful reading as it explains the syntactical differences between different implementations of SQL (e.g., Access uses * and ? as wildcards as opposed to % and _).
Was this review helpful to you?
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 4.7 out of 5 stars  57 reviews
219 of 226 people found the following review helpful
5.0 out of 5 stars Very good job at its intended job Jan. 16 2000
By Charles Arehart - Published on Amazon.com
Format:Paperback
Ben Forta has done a great job distilling the most pertinent basic SQL concepts into simple, easy to read form. Befitting its "10 minute" moniker, this is a wonderful book for new SQL programmers. But it's also subtly different in a way that will particularly suit folks coming into SQL for the first time as part of their involvement in using web database development tools such as ColdFusion and Active Server Pages.
One one level, any new SQL programmer using any DBMS will appreciate the easily digested coverage of the fundamental query and update basics. The books is well-written, an easy read, and goes beyond those basics without going too far.
Even moderately experienced readers will be well-served by the clear, simple discussions of important topics (like data manipulation and aggregating functions, grouping data, subqueries, views, etc) that can be easily forgotten, as well as other topics (such as using transactions, constraints, triggers, etc.) that can get lost in wading through other more voluminous tomes. Ben presents a very nice balance of fundamental topics.
But there's more to this book than being a simple intro to SQL. That audience of web db developers is an exploding one, and they bring some unique needs for which Ben provides a valuable perspective. Most SQL books have some DBMS-specific bias, despite SQL's purpose as a tool for accessing any kind of database in a consistent manner. Web application development environments like ASP and CF are also similarly database-agnostic. There are subtle points about using SQL in such environments that are different from using it, say, in a query builder or in a client/server environment.
Ben, who was lead author of the highly regarded ColdFusion Web Application Construction Kit, presents the subjects in a manner suitable to such programmers and the way they'd code SQL and use its results, and he also sprinkles in discussions of how to take care of cross-platform issues on particular tasks, and often offers specific solutions for the most popular DBMS's used by that audience, such as Access, SQL Server, and Oracle.
On still another level, other books also get bogged down in issues of database design, creation, administration, security, etc. Important though those topics are, most development shops are growing to a point where those tasks are being handled by different people, and the developer who simply wants to code retrieval and update applications is challenged to find a good intro sql book that doesn't wade into detail on topics that they may not yet be able to understand, let alone ever need to perform. There are other great books that do cover those subjects, and readers would do well to seek those out as they progress in their learning.
It certainly makes it challenging to find (and no less to write) a SQL book. There are just so many potential audiences. For its intended purpose though, "Teach Yourself SQL in 10 Minutes" is very well done. As in his previous books, Ben is right on the money--and for a very low price, at that!
148 of 154 people found the following review helpful
5.0 out of 5 stars Easily Understood by a 13 year old Aug. 20 2000
By bob - Published on Amazon.com
Format:Paperback
I am only 13 years old and understood every line of this book!
This is a great book to get you started in database management using SQL. The format of the book is one I've never seen, I love it. He first explains a new concept, compares it to other previously learned concepts, and then gives an example. Following this he explains the example. There are lots of other things helpful in his technique as well, such as showing the examples for Oracle users (a Database management program).
The thing that I really like is the perfect balance of explanations and examples. It is hard to find a page in the book without at least one example.
Upsides to this book
---------------------
not to many words
easy to handle concepts
well written
great for beginners

Downsides to book
------------------
Not the best book for reference, but not bad.
not for advanced SQL users

Over all, the best computer book I've ever read, don't hesitate to get yourself a copy.
53 of 61 people found the following review helpful
3.0 out of 5 stars Good as a basic intro, but don't depend solely on this book Oct. 18 2000
By "schapel" - Published on Amazon.com
Format:Paperback
This book is clearly aimed at the beginning SQL programmer with little or no knowledge of relational databases. It's a good intro that will quickly get the reader up to speed at writing some very simple queries and updates on an existing database.
However, in working with other programmers, I've learned that it's true about a little knowledge being a dangerous thing. If your only knowledge of SQL and relational databases comes from this book, you're in danger of missing out on some very basic information, such as how to normalize a database or perform an outer join.
If you learn SQL from this book, you'll quickly want to get another book on SQL that's more complete to fill you in on this missing critical information. Unless for some reason you need to start programming in SQL as soon as possible (in other words, before you understand what you're doing), just skip this book and buy just the more complete book.
17 of 17 people found the following review helpful
5.0 out of 5 stars Absolutely Fabulous Lesson in SQL Jan. 18 2001
By Christopher LaVesser - Published on Amazon.com
Format:Paperback
If you are new to Database Application Design/Web Based Application Design, as I am, you will find this title most helpful in getting you off the ground. I bought this book in hopes that it would help me build SQL statements into my ASP pages, and it has done that and more. This book is an easy read and very clearly explains the basic concepts of the SQL language, techniques, capabilities, etc. It also offers a concise look into the way databases are designed and how they function. The book does a wonderful job of remaining non-proprietary, and is quick to point out when you are learning something that is specific to one Database Management System or another. This is a wonderful little book to add to your reference library if you wish to spend little and learn tons.
14 of 14 people found the following review helpful
4.0 out of 5 stars A Good Introduction and Quick Reference Feb. 4 2001
By Ronald L. Mendell - Published on Amazon.com
Format:Paperback
Structured Query Language (SQL), if it is a foreign tongue to you, after reading this book carefully, you'll speak SQL. From the start, the author explains the purpose of the language, to query relational databases, and he also defines what relational databases are. He covers how databases are tables of data containing columns and rows. In a well-organized sequence of chapters, he describes how each SQL command affects those rows and columns. My suggestion with the text is to divide its reading into two parts. If you're new to computer programming, read Chapters 1-16, then try an online free SQL tutorial on the Web for awhile. Once you get comfortable with searching for data, come back and do the last chapters, which have a programming emphasis. With constant practice, SQL programming can become straightforward and quick for you. The book has clear descriptions and is useful for the newcomer to SQL.
Search Customer Reviews
Only search this product's reviews
ARRAY(0xc15be030)

Look for similar items by category


Feedback