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

Ben Forta (Author)

Book Description

ISBN-10: 0672321289 | ISBN-13: 978-0672321283 | Publication Date: April 26, 2001 | Edition: 2nd

Sams Teach Yourself SQL in 10 Minutes, Second Edition 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.

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.

Product Details

• Paperback: 272 pages
• Publisher: Sams; 2nd edition (April 26, 2001)
• Language: English
• ISBN-10: 0672321289
• ISBN-13: 978-0672321283
• Product Dimensions: 8 x 5.5 x 0.7 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: #691,115 in Books (See Top 100 in Books)

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

Most Helpful Customer Reviews

35 of 36 people found the following review helpful:

5.0 out of 5 stars Quick and Dirty, as it Implies, September 16, 2003

By A Customer

This review is from: Sams Teach Yourself SQL in 10 Minutes (2nd Edition) (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.

10 of 10 people found the following review helpful:

5.0 out of 5 stars IF you need to learn SQL THEN.., August 15, 2003

By A Customer

This review is from: Sams Teach Yourself SQL in 10 Minutes (2nd Edition) (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.

15 of 17 people found the following review helpful:

4.0 out of 5 stars Yah, just get it, July 15, 2003

By 

"udsteve" (Dayton, Ohio United States) - See all my reviews

This review is from: Sams Teach Yourself SQL in 10 Minutes (2nd Edition) (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.