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

by Sams

$14.99
buy from amazon.com
Average Rating: * * * * half star
Sales Rank:482825 (lower is better)
Price Used:$0.60
Shipping:Free Shipping on most orders over $25*
Availability:
Label:Sams
UPC:752063321287
Pages:272
Binding:Paperback
Publication Date:2001-04-26
Published By:Sams
ASIN:0672321289
Category:Book

Authors

Editorial Reviews and Product Descriptions

Book Description

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

Customer Reviews

Precisely what it promises to be: an introduction to SQL - Reviewed on 2008-05-26
* * * * *

Ben Forta has a commendable honesty about him. He explains the intent of his books clearly in their Introductions and then proceeds to deliver just that. In this instance, Forta is clear that the book is for those new to SQL and who quickly want to learn how to get the most out of SQL. He is equally clear that the book does not cover every last aspect of SQL.

The book is becoming a bit long in tooth since it has not been updted since 2004. DBMSs covered are IBM DB2, Microsoft Access, Microsoft SQL Server, MySQL (Version 4), Oracle, PostgreSQL, Sybase Adaptive Server. Some of the information is now outdated and MySQL v5 has added new capabilities. On the whole, though, everything Forta presents here is still usable.

In 22 chapters, Forta teaches the reader the basics of SQL, more than enough to deal with perhaps 80% or more of common SQL requirements. Beyond that and you're in the realm of system architects and administrators who are simply not the audience for this book.

Be sure to download the sample databases and errata from the author's website.

On the whole, one of the best introductions to SQL available.

Jerry
PERFECT! AWESOME! Need I say more? - Reviewed on 2008-05-07
* * * * *
2 customers found this review helpful, 1 did not.

When I went for a job interview a few months ago all I knew about SQL was that it had something to do with databases. When I informed the interviewer I didn't know SQL, the look on his face let me know I was doomed. So as soon as I left that interview I got online and purchased this book determined to learn as much as I can, in an inexpensive way, and quickly. Wow! This book turned out to be all of those things. It is very easy to understand and made SQL seem like a breeze. I loved the examples and plan to purchase an intermediate-advanced SQL book very soon. Hope SAMS Teach Yourself can help me out with one of those too. With their help I think I can add 'knowlege of SQL' on my resume.
I knew nothing about SQL - Reviewed on 2008-04-01
* * * *
1 customer found this review helpful, 1 did not.

Good intro and you do learn the language and how to understand and write it by using this book
THIS AUTHOR IS SERIOUS!!!........within 10 minutes you can teach yourself a new language - Reviewed on 2008-02-21
* * * * *
2 customers found this review helpful.

SQL in 10 minutes?? ......I thought this guy was kidding. He wasn't. The main reason why I couldn't get a job was because I didn't know SQL, within one hour I read the book, tried all the examples, wrote SQL on my resume, applied for a job and got the job the next day requiring SQL experience :)

This language is so easy to learn, it feels more like an application than a programming language. It seems as though the whole language is really just 3 words, select, from & where, although I'm still new and theres probably a tonne more but I didn't need to know that to get the job.

Compare it to learning c,c++, Fortran and other languages for the first time where you learn to define variables, learn the functions, test cases, inputs, outputs, etc, etc. SQL you pretty much type in the inputs and you receive the outputs...its a really intuitive language, anyone can start learning within minutes. Highly recommend this book, its also probably the best quick reference out there if you need to solve a particular problem.
Very Beginner - Reviewed on 2007-12-21
* * * *
1 customer found this review helpful, 3 did not.

This is a true beginner's book. This is a book for people who know nothing about SQL. It is very helpful for starters.
Read More Customer Reviews »
Go To Amazon Product Page

* - See Amazon Product Page for shipping and pricing details.


Book Subjects